[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1173
  • Last Modified:

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
0
dbms_chu
Asked:
dbms_chu
1 Solution
 
bondtraderCommented:
Sorry, only available with DB2 for Z/OS v8 on the mainframe.  You can, however, use identity fields with the proper APAR applied on v7.
0
 
dbms_chuAuthor Commented:
Bondtrader,
Thanks for your response.  I guess the authors of the various DB2 manuals were not in sync.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now