ODBC Stage

Magesh_bala · Post by **Magesh_bala** » Wed Feb 14, 2007 7:17 am

Hi,
In my ODBC Stage i have selected user defined queries, I want to write a two queries in Enter SQL box. How do i separate two quries, Whether its possible???

First i have to delete records from the table and i have to insert into the same table, Please clearify...

DSguru2B · Post by **DSguru2B** » Wed Feb 14, 2007 8:04 am

You can use DRS stage and write a the delete statement in the before sql tab.
When you say "first delete and then insert", an option already exists for it. Is this a selective delete. Give more info on the delete 'where predicate'.

narasimha · Post by **narasimha** » Wed Feb 14, 2007 10:49 am

Alternativly, you could also use ODBC stage, and depending on your requirement,
in the Update action you could use "Replace existing rows completely" or "Clear the table and then insert rows"

ray.wurlod · Post by **ray.wurlod** » Wed Feb 14, 2007 2:30 pm

The "replace existing rows completely" option deletes the row whose key is supplied from DataStage then inserts a new row with this key.