Deleting rows from an SQL table

gpbarsky · Post by **gpbarsky** » Mon Feb 19, 2007 10:27 am

Hi, my friends... :D

Given a file which is composed by keys of a table, I need to delete the rows of the table corresponding to the keys of the file. I mean, for each record of the file, I need to delete the rows of the table.

How can I do this ?

Thanks in advance.

chulett · Post by **chulett** » Mon Feb 19, 2007 10:30 am

Read the file and send the keys to your database stage of choice using the 'Delete existing rows' update action. Easy Peasy.

narasimha · Post by **narasimha** » Mon Feb 19, 2007 10:33 am

You could design your job like below

Code: Select all

Sequential File Stage -------> Transformer -------> DRS Stage

You can specify "Delete existing rows only" in the target stage.

gpbarsky · Post by **gpbarsky** » Mon Feb 19, 2007 11:39 am

Thanks, but I have not the option for deleting rows. I'm using the ODBC stage.

chulett · Post by **chulett** » Mon Feb 19, 2007 11:45 am

Then either switch to the DRS stage, which does have that option for ODBC, or use user-defined sql.

kduke · Post by **kduke** » Mon Feb 19, 2007 7:57 pm

chulett wrote:Easy Peasy.

Been watching "The Greatest Game Ever"?

chulett · Post by **chulett** » Mon Feb 19, 2007 10:16 pm

Lemon squeezie.

kduke · Post by **kduke** » Mon Feb 19, 2007 10:33 pm

Me too.