Kbase P126445: Creating table in ABL schema returns: Invalid attribute "PRO_SQL_WIDTH" specified for column . (1277
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/15/2008 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1B
All Supported Operating Systems
SYMPTOM(s):
Specifying PRO_SQL_WIDTH when creating table in ABL schema returns: Invalid attribute specified for column
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Invalid attribute "PRO_SQL_WIDTH" specified (12776)
Invalid attribute "PRO_SQL_WIDTH" specified for column TESTCOL. (12776)
CREATE TABLE PUB.test (
testcol varchar(100)
PRO_SQL_WIDTH 200
) ;
CAUSE:
This is a known issue
FIX:
Workaround by altering the table after creation. Example:
CREATE TABLE PUB.test (
testcol varchar(100)
) ;
commit;
ALTER TABLE PUB.test ALTER COLUMN testcol SET PRO_SQL_WIDTH 200;
commit;