Page 1 of 1
how to delete data using datastage job?
Posted: Thu Aug 12, 2010 8:32 am
by qutesanju
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?
Posted: Thu Aug 12, 2010 8:38 am
by kris007
Have you tried User defined SQL?
Posted: Thu Aug 12, 2010 9:00 am
by chulett
The option would be there in the 'native' stages, plus the DRS from what I recall, can you not use one of them?
Re: how to delete data using datastage job?
Posted: Mon Aug 16, 2010 2:08 am
by HariK
What do you want to delete. delete all the records or just one record?
What is your target?
Posted: Mon Aug 16, 2010 3:15 am
by arunpramanik
Looks like this topic is related to earlier post
viewtopic.php?t=135099
Posted: Mon Aug 16, 2010 4:28 am
by sultan@cts
kris007 wrote:Have you tried User defined SQL?
As kris007 suggested user defined delete statement will work in ODBC stage to delete records.