dbms_chu
asked on
create sequence in DB2 os/390 v7
Can someone with access to DB2 os/390 v7 tell me if SEQUENCES are available in v7?
I found a reference to "create sequence" in the "DB2 UDB for OS/390 and z/OS V7 Data Sharing: Planning and Administration"
manual, but I don't see the "create sequence" syntax in the SQL Reference.
I can see that SEQUENCEs are available in V8, but I am specifically interested in v7.
The statement that is referenced in the Data Sharing manual is: CREATE SEQUENCE SEQ1 START WITH 1 INCREMENT BY 1 CACHE 20
Here is a link to the Data Sharing manual: http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsndsh13/5.2?SHELF=&DT=20030505133231
TIA,
DBMS_CHU
I found a reference to "create sequence" in the "DB2 UDB for OS/390 and z/OS V7 Data Sharing: Planning and Administration"
manual, but I don't see the "create sequence" syntax in the SQL Reference.
I can see that SEQUENCEs are available in V8, but I am specifically interested in v7.
The statement that is referenced in the Data Sharing manual is: CREATE SEQUENCE SEQ1 START WITH 1 INCREMENT BY 1 CACHE 20
Here is a link to the Data Sharing manual: http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsndsh13/5.2?SHELF=&DT=20030505133231
TIA,
DBMS_CHU
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your response. I guess the authors of the various DB2 manuals were not in sync.