DB2 z/OS V9 - IDENTITY_VAL_LOCAL() ?

Nenad Vidak

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."
_____________________________________________________________________

Paul Ogborne

Re: DB2 z/OS V9 - IDENTITY_VAL_LOCAL() ?
(in response to Nenad Vidak)
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."
_____________________________________________________________________