Kbase P120797: SQL error 7484 when executing a statement referencing the BIGINT data type
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/11/2007 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.0x
SYMPTOM(s):
Executing a SQL statement results in error 7484
[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Sorry, operation not implemented yet (7484)
SQLState=HY000
ErrorCode=-20024
[JDBC OpenEdge Driver]:Sorry, operation not implemented yet (7484)
SQL statement references the BIGINT data type, for example:
CREATE TABLE pub.test (
field1 BIGINT
);
Changing data type to INT avoids the issue
CAUSE:
The BIGINT data type is not supported in this Progress/OpenEdge version. It is only supported in 10.1B or later.
FIX:
Upgrade to OpenEdge 10.1B or later.
If upgrading is not an option, change the data type to INT as a workaround.