Can you please let me know how to run multiple SQL Sever queries (around 20 for different tables) in Datastage. I don't have permissions for creating stored procedures.
I need to run a set of SQL server queries and save the results into a text file.
I know that one way is to create stored procedure and use stored procedure stage. But I dont have permissions from DBA.
Let me know how can i execute these multiple SQL Server queries in Datastage.
You can still do a 'union' if the queries all return the same number of columns and like column types.
If you take a moment and actually provide some detail for your question rather than just basically repeating the same thing you might get some better advice. So... how similar are these queries?
-craig
"You can never have too many knives" -- Logan Nine Fingers