Chaps,
I'm starting to play with db2 V9.1 and am writing a stored procedure
to manage accounting records from oiur RADIUS server.
I've got an XML aware table with an auto increment primary key, a few
sql columns and an XML column. For every XML object I'm inserting, i'd
lke to have an ID attribute that has the same value as the SQL primary
key that'll be created upon executing the insert.
Is there any way in my Java stored procedure I can get hold of what the
"next" primary key will be so that I can do the above.
Of course I could cheat and insert the sql primary key into the
attribute when i retrieve the data, but that would stop me doing other
things
TIA
alex