Reference Input Column in DB2 UDB API

Sreedhar · Post by **Sreedhar** » Fri Oct 23, 2009 4:16 pm

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,

ray.wurlod · Post by **ray.wurlod** » Fri Oct 23, 2009 4:36 pm

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.