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
Updating a specific column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.