Solved

create sequence in DB2 os/390 v7

Posted on 2004-08-16
2
1,136 Views
Last Modified: 2008-01-16
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
Comment
Question by:dbms_chu
2 Comments
 
LVL 4

Accepted Solution

by:
bondtrader earned 250 total points
ID: 11843709
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
 
LVL 3

Author Comment

by:dbms_chu
ID: 11911211
Bondtrader,
Thanks for your response.  I guess the authors of the various DB2 manuals were not in sync.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question