Search found 2 matches
- Tue Jul 31, 2018 6:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Accessing the value of an Identity column after insert
- Replies: 4
- Views: 4779
Arnd, the challenge is that this set of tables is shared and is also being updated by other (mainframe) processes that can handle Identity columns. Changing the tables (for example to use sequences) would impact the existing code. We are looking into using the stored procedure stage as an alternative.
- Mon Jul 30, 2018 10:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Accessing the value of an Identity column after insert
- Replies: 4
- Views: 4779
Accessing the value of an Identity column after insert
Any ideas on obtaining the value assigned to an Identity column (DB2 table) after an insert? There is no natural key to query on. The value is needed to use in subsequent logic. My coworkers have no experience in using Identity columns and seem to think DS doesn't handle them at all. IBM doc on the ...