Kbase P3692: How to create sequence with SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/12/2008 |
|
Status: Verified
GOAL:
How to create sequence with SQL-92?
GOAL:
How to use the Create Sequence statement?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The sequence can be created from the SQL Explorer or any third party tool that allows to enter a SQL Statement to be sent to a SQL-92 Progress Database.
Syntax:
CREATE SEQUENCE [schema_name.]sequence_name
[INCREMENT BY value],
[START WITH value],
[MAXVALUE value | NOMAXVALUE],
[MINVALUE value | NOMINVALUE],
[CYCLE | NOCYCLE]
Example:
CREATE SEQUENCE pub.mysequence;