Kbase 33692: How to create sequence with SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Solution ID: P3692
GOAL:
How to create sequence with SQL-92?
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
Progress 9.1D
FIX:
The sequence can be created from any third party tool that allows you to enter a SQL Statement to be sent to a SQL-92 Progress Database.
Example: "create sequence pub.mysequence;" can be executed from SQL Explorer.
The above example assumes the following defaults values:
INCREMENT BY: defaults to 1 and thus defaults to be an ascending sequence.
START VALUE: MINVALUE is the default for ascending. MINVALUE default is 1.
In a descending sequence the default is MAXVALUE, whose default is -1.
MAXVALUE: -1 is the default for descending, 2147483647 is the default for ascending.
NOMAXVALUE: Specifies the MAXVALUE defaults.