how to delete data using datastage job?

qutesanju · Post by **qutesanju** » Thu Aug 12, 2010 8:32 am

Hello Experts,

can we delete data using ODBC plugin?
i checked there no delete action specified.

Do we have an alternate way?to achieve data deletion?

kris007 · Post by **kris007** » Thu Aug 12, 2010 8:38 am

Have you tried User defined SQL?

chulett · Post by **chulett** » Thu Aug 12, 2010 9:00 am

The option would be there in the 'native' stages, plus the DRS from what I recall, can you not use one of them?

HariK · Post by **HariK** » Mon Aug 16, 2010 2:08 am

What do you want to delete. delete all the records or just one record?
What is your target?

arunpramanik · Post by **arunpramanik** » Mon Aug 16, 2010 3:15 am

Looks like this topic is related to earlier post
viewtopic.php?t=135099

sultan@cts · Post by **sultan@cts** » Mon Aug 16, 2010 4:28 am

kris007 wrote:Have you tried User defined SQL?

As kris007 suggested user defined delete statement will work in ODBC stage to delete records.

DSXchange

how to delete data using datastage job?

how to delete data using datastage job?

Re: how to delete data using datastage job?