Kbase P28356: How to specify an storage area when creating a table using SQL-92.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/11/2005 |
|
Status: Verified
GOAL:
How to specify an storage area when creating a table using SQL-92.
GOAL:
Can I specify a storage area when creating a table using SQL-92?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
UNIX
Windows
FIX:
The solution below assumes a database structure which already contains the "Data" storage area (as suggested by the following database structure file):
b .
d "Schema Area":6:32
d "Data" .
d "User" .
The following SQL-92 syntax can be used to create a table called "myTable" within the "Data" storage area of a Progress 9.x database:
CREATE TABLE myTable
(fld varchar(20))
AREA "Data";
Please be aware that the storage area name needs to be contained within double quotes. Additionally, the storage area name is case sensitive. This is not mentioned within the Progress database documentation.