I need to update existing rows in a table to set a column value to somevalue if there is atlest one row in source file and after update, I need to insert (append) the source file rows to that table.
Is this can be done in one datastage job.
Please advise.
Update one column value and insert source row to a table
Moderators: chulett, rschirm, roy