Delete data from a table based on four non-key columns
Moderators: chulett, rschirm, roy
Which DB2 stage? Shouldn't need anything 'custom' for this as there is (typically) a "Delete existing rows only" update action or equivalent available. Don't confuse "key" columns with indexes or primary keys, they are basically just columns to bind into the where clause.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am
DB2 Stage: DB2 UDB API
Tried with custom sql using two different options. But unable to delete data from a table.
Tried with custom sql using two different options. But unable to delete data from a table.
Code: Select all
Delete from temp_table1 where col1= orchstrate.col1,co2= orchestrate.col2, col3= orchestrate.col3, col4= orchestrate.col4;
Code: Select all
Delete from temp_table1 where col1= orchstrate.col1 and co2= orchestrate.col2 and col3= orchestrate.col3 and col4= orchestrate.col4;
-
- Participant
- Posts: 160
- Joined: Tue May 02, 2006 7:49 am