Kbase 21954: SQL-92: Error -- Tablespace Not Found (7534)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/9/2002 |
|
SUMMARY:
This Knowledge Base Solution applies to the Progress SQL-92 engine.
When an area name is specified in the CREATE TABLE statement, the following error may be encountered.
Tablespace Not Found (7534)
EXPLANATION:
The area name needs to be surrounded by double quotes and it is also case-sensitive. This syntax requirement is missing from the SQL-92 Guide and Reference, but will be added in the future.
SOLUTION:
The solution is illustrated by an example referring to the following .st file:
b .
d "Schema Area":6:32
d "Data" .
d "User" .
The following CREATE TABLE statement will result in error 7534:
CREATE TABLE myTable
(fld varchar(20))
AREA data
The following statement works fine:
CREATE TABLE myTable
(fld varchar(20))
AREA "Data"
References to Written Documentation:
Progress SQL-92 Guide and Reference