Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Posts
    7

    Unhappy Unanswered: Create Sequence with OS/390

    Hello guys,
    I'm working on DB2 V7 on OS/390, does anyone know how to create a sequence?
    the syntax:

    CREATE SEQUENCE MY_SEQ;

    does not work.
    Kind regards

    Matteo

  2. #2
    Join Date
    May 2003
    Location
    SWEDEN
    Posts
    10

    Re: Create Sequence with OS/390

    Originally posted by matteogd
    Hello guys,
    I'm working on DB2 V7 on OS/390, does anyone know how to create a sequence?
    the syntax:

    CREATE SEQUENCE MY_SEQ;

    does not work.
    Kind regards

    Matteo
    Hej Matteo.
    Do you mean "CREATE SEQUENCE" ?
    I can't find it in ...OS/390 and z/OS V7 SQL Reference: 2.8.1.5 .
    /uffe

  3. #3
    Join Date
    Apr 2003
    Posts
    7

    Re: Create Sequence with OS/390

    Thanks ulfnsc,
    yes while it is possible on Unix & Windows on OS/390 I cannot find a simple way to define a sequence.
    Do you know a simple way to do that?
    thanks

    Matteo


    Originally posted by ulfnsc
    Hej Matteo.
    Do you mean "CREATE SEQUENCE" ?
    I can't find it in ...OS/390 and z/OS V7 SQL Reference: 2.8.1.5 .
    /uffe

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Create Sequence with OS/390

    I hope the following topics are familiar to you ... Just in case, they are not ...

    http://www7b.software.ibm.com/dmdd/l...05pilaka2.html

    http://www7b.software.ibm.com/dmdd/l...2fielding.html

    Cheers

    Sathyaram

    Originally posted by matteogd
    Thanks ulfnsc,
    yes while it is possible on Unix & Windows on OS/390 I cannot find a simple way to define a sequence.
    Do you know a simple way to do that?
    thanks

    Matteo

  5. #5
    Join Date
    May 2003
    Posts
    113

    Re: Create Sequence with OS/390

    As I know, sequence currentlly are not in db2/390. but it will definitely available after v8 release. And quite possible available on V7 with sev package

    Originally posted by sathyaram_s
    I hope the following topics are familiar to you ... Just in case, they are not ...

    http://www7b.software.ibm.com/dmdd/l...05pilaka2.html

    http://www7b.software.ibm.com/dmdd/l...2fielding.html

    Cheers

    Sathyaram

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •