Page 1 of 1
User defined Query in Datastage
Posted: Wed Oct 24, 2007 1:48 am
by shiv4003
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.
Posted: Wed Oct 24, 2007 3:45 am
by AmeyJoshi14
Can you please elobrate your question..I am not getting exactly what is your requirement?
Posted: Wed Oct 24, 2007 5:50 am
by shiv4003
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
Posted: Wed Oct 24, 2007 6:08 am
by WoMaWil
choose "user defined" and past your query in!
Posted: Wed Oct 24, 2007 6:50 am
by shiv4003
But how to select the table used the ODBC Table definitions
Posted: Wed Oct 24, 2007 7:18 am
by chulett
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?