Solved

create sequence in DB2 os/390 v7

Posted on 2004-08-16
2
1,124 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

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 (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

759 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now