Hi,
I haven't used this stage for quite some time. I am unable to refer to the input columns in the Db2 UDB API Stage.
My requirement is that, there is a primary key comprising of 3 columns, I want to update on of the column (Primary key) based on the primary key.
Regards,
Reference Input Column in DB2 UDB API
Moderators: chulett, rschirm, roy
Reference Input Column in DB2 UDB API
Regards,
Shree
785-816-0728
Shree
785-816-0728
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How would you do it in SQL ? Play with the properties or SQL in the DB2 API stage until you match that SQL. You may need user-defined SQL here, because you need to pass the old key value as a Key column and the new key value as a non-key column.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.