Kbase P24928: Syntax error when attempting to run the sample code for the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/2003 |
|
Status: Unverified
SYMPTOM(s):
Executing the CREATE SEQUENCE SQL-92 Statement provided within the "H.1.2 Progress SQL-92 Support For Progress Sequences" section of the Progress Version 9 Product Update Bulletin.
=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
CAUSE:
There is a misspelling in the syntax for the CREATE SEQUENCE SQL-92 Statement provided within the documentation:
CREATE SEQUENCE pub.customer_sequence
START WITH 100, INCREMENT BY 1, NOCYLCE;
The last option within the above command should be NOCYCLE and not NOCYLCE as described in the documentation.
CAUSE:
Bug# 20030408-001
FIX:
Change the given code to look like as follows:
CREATE SEQUENCE pub.customer_sequence
START WITH 100, INCREMENT BY 1, NOCYCLE;