can we execute oracle queries through any Datastage function
Posted: Sun Jan 07, 2007 11:48 pm
Hi all,
can we execute oracle queries through any Datastage function like how we execute unix commands.
As when i want the output of a single select query
'select * from tablename' i put this in a sqlfile in my unix directory and execite this file through the unix commands in the routine and assign to a variable in the datastage.
Can it be done in a simpler way?
Thanks
can we execute oracle queries through any Datastage function like how we execute unix commands.
As when i want the output of a single select query
'select * from tablename' i put this in a sqlfile in my unix directory and execite this file through the unix commands in the routine and assign to a variable in the datastage.
Can it be done in a simpler way?
Thanks