Updating a specific column

Diya · Post by **Diya** » Thu Sep 14, 2006 3:06 am

I have a job which inserts/updates data in a table.

I have one more job in which I want to update ONLY ONE column of that table.(The second job is only meant for this purpose)

Im using a dynamic RDBMS stage to load the table and it is not allowing me to update only one column as it is asking for key columns.But if I provide key columns I dont want to update them and since there is no source 4 those key columns it will result in inserting null which is not acceptable.

Can anyone help me on this?

Thanks,
Diya

kduke · Post by **kduke** » Thu Sep 14, 2006 7:03 am

If you look at the generated SQL then you will see that it will only do an UPDATE ... WHERE KEY1 = ...

You should be safe.

meena · Post by **meena** » Thu Sep 14, 2006 9:01 am

Hi Diya,

You need atleast one key to update.Without a key I think it is difficult to update.
By selecting a key your going to update your required column based on the key match.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 14, 2006 3:18 pm

Of course it's asking for key - it wants to know in which row(s) to perform the update. If you want to update every row, fake it - specify any column as "key" - it ends up in the WHERE clause - and a condition that is always true (for example WHERE key = key). You may, depending upon the stage type, require user-defined SQL.