[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

create sequence in DB2 os/390 v7

Posted on 2004-08-16
2
Medium Priority
?
1,172 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
bondtrader earned 1000 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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 (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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

650 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