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:

Who is Participating?
bondtraderConnect With a Mentor Commented:
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.
dbms_chuAuthor Commented:
Thanks for your response.  I guess the authors of the various DB2 manuals were not in sync.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.