
June 17th, 2005, 07:02 PM
|
|
Contributing User
|
|
Join Date: Jun 2003
Location: Waco, Texas
|
|
|
Identity values on Z/OS
We have used identity values for years on DB2 UDB on Windows. They haven't used on DB2 for Z/os before today, they tend to like timestamps there....
Anyway - are there any gotchas with identity values on Z/os? My usual code run immediately after an insert to the that ID value just returns null - I tried in ASP.NET and through WinSQL.
usually run something like:
select sysibm.identity_val_local as myval
from sysibm.sysdummy1
right after the update and get that id. A cursory glance at the table looks like the identity column is defined correctly by our DBA.
Any ideas? Is this handled differently on Z/OS?
thanks,
fv
__________________
...because that is the way we have always done it. We've been doing it like that for 80 Years! (How do we change that mindset?)
|