Kbase P137202: CREATE INDEX AREA IndexQ returns error "Tablespace not found (7534) "
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/11/2008 |
|
Status: Unverified
SYMPTOM(s):
Tablespace not found (7534)
ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol
driver][OPENEDGE]Tablespace not found (7534)
FACT(s) (Environment):
Executing the statement:
CREATE INDEX idxU_17508_100001 ON qvr (U_17508_100001) AREA IndexQ
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
The area name needs to be surrounded by double quotes and it is also case-sensitive.
FIX:
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"