Kbase P11699: Setting the current value on a particular SQL-92 sequence does not work.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/15/2009 |
|
Status: Verified
SYMPTOM(s):
Setting the current value on a particular SQL-92 sequence does not work.
Getting error:
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error(7587)
FACT(s) (Environment):
Progress 9.1D
All Supported Operating Systems
CAUSE:
The Progress SQL-92 client does not support modifying sequence definitions or
attributes.
FIX:
The sequence must be removed and re-created with the DROP and CREATE commands in order to reset current value or change other attributes.