SQL server multiple queries in Datastage

shave · Post by **shave** » Tue Jul 01, 2008 7:01 pm

Hello

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.

Thanks in Advance

keshav0307 · Post by **keshav0307** » Tue Jul 01, 2008 7:49 pm

your requirement is not very clear. eplain in details, what exactly you want to do.

shave · Post by **shave** » Tue Jul 01, 2008 8:10 pm

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.

keshav0307 · Post by **keshav0307** » Tue Jul 01, 2008 8:48 pm

its still not clear.

do you want to store the output in a single file?

does the output column of the queries are same?

if yes then, can you write user defined query and union to to run as a single query.

shave · Post by **shave** » Tue Jul 01, 2008 10:42 pm

I want to store the results of all my queries into a singlefile

and the columns were not related as I am using many tables. Seperate queries with different columns

chulett · Post by **chulett** » Tue Jul 01, 2008 11:41 pm

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?

John Smith · Post by **John Smith** » Wed Jul 02, 2008 12:06 am

Are the SQL queries look the same? You can use RCP in a generic job that can run all your queries.