Get Inserted Identity column Value

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Titto
Participant
Posts: 148
Joined: Tue Jun 21, 2005 7:49 am

Get Inserted Identity column Value

Post by Titto »

Hi,

I have situation where i need to get the Identity Key column value for the inserted record. I could able to insert the record but I want the value of Identity column. I am using DB2 stage for this. Is there a way using After Sql in DB2 stage
How to acheve this?
any help is really appreciated.

Thanks,
Titto
pnchowdary
Participant
Posts: 232
Joined: Sat May 07, 2005 2:49 pm
Location: USA

Post by pnchowdary »

Hi Titto,

This topic seems to be a duplicate of the one you posted in the Server section. Please dont post in the wrong section. Please delete this thread.
Thanks,
Naveen
Post Reply