Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.


    Jul 10
    2009

    DB2 z/OS V9 - IDENTITY_VAL_LOCAL() ?

    Nenad Vidak
    Hello,

    running DB2 z V9 NFM/CM.

    Is it expected that the following SQL query returns null ? :

    SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1

    Regards, Nenad

    _____________________________________________________________________

    * IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

    _____________________________________________________________________

    IDUG Europe Attendee Testimonial-
    "The clear and high level technical information of some of the sessions makes the conference a value for the money."
    _____________________________________________________________________
    Paul Ogborne
    [none]
    Hi Nenad,

    Can we assume that your SELECT followed an INSERT to a table with an Identity Column defined?

    Regards,

    Paul Ogborne

    -----Original Message-----
    From: Nenad Vidak <[login to unmask email]>
    To: [login to unmask email]
    Sent: Fri, 10 Jul 2009 11:50
    Subject: [DB2-L] DB2 z/OS V9 - IDENTITY_VAL_LOCAL() ?



    Hello,

    running DB2 z V9 NFM/CM.

    Is it expected that the following SQL query returns null ? :

    SELECT IDENTITY_VAL_LOCAL() FROM SYSIBM.SYSDUMMY1

    Regards, Nenad

    _____________________________________________________________________

    * IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

    _____________________________________________________________________

    IDUG Europe Attendee Testimonial-
    "The clear and high level technical information of some of the sessions makes
    the conference a value for the money."
    _____________________________________________________________________


    ________________________________________________________________________
    AOL Email goes Mobile! You can now read your AOL Emails whilst on the move. Sign up for a free AOL Email account with unlimited storage today.

    _____________________________________________________________________

    * IDUG 09 Rome, Italy * October 5-9, 2009 * http://IDUG.ORG/EU *

    _____________________________________________________________________

    IDUG Europe Attendee Testimonial-
    "The clear and high level technical information of some of the sessions makes the conference a value for the money."
    _____________________________________________________________________

    All Times America/New_York

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact