How I can update primary key of table in Datastage jobs.

[anshumangupta1206]

Hi All,
I am using SYBASE as the database. I want to update the primary key of the table in Sybase OC stage. Actually the problem is, for a column I can pass the value once, so how can I pass the old and new value for primary key.
I am trying using use-defined SQl and passing two different values, but it is not working.
Please suggest some other ways to do this.

[ray.wurlod]

Trick it. Make the key column in your design the one that will appear in the WHERE clause, and mark the one that will appear in the SET clause non-key.