DSXchange

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,

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.