User defined Query in Datastage

shiv4003 · Post by **shiv4003** » Wed Oct 24, 2007 1:48 am

Hi

Can anyone please help me out of how to apply user defined Queries in an RDBMS stage in the datastage Tool.
Please help me out

Regards,
Shiva.

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed Oct 24, 2007 3:45 am

Can you please elobrate your question..I am not getting exactly what is your requirement?

shiv4003 · Post by **shiv4003** » Wed Oct 24, 2007 5:50 am

Hi

instaed of an SQL getting generated by the datastage itself, i need t give my own query. Can you plz help me out.

Regards,
Shiva

WoMaWil · Post by **WoMaWil** » Wed Oct 24, 2007 6:08 am

choose "user defined" and past your query in!

shiv4003 · Post by **shiv4003** » Wed Oct 24, 2007 6:50 am

But how to select the table used the ODBC Table definitions

chulett · Post by **chulett** » Wed Oct 24, 2007 7:18 am

Your query will need to be complete and thus include the table name. Not sure what exactly you are having a problem with, can you be more specific?