SQL query in routine activity stage

krisp321 · Post by **krisp321** » Tue Jun 14, 2011 3:53 am

Hi

I have a routine which generates some report based on requirements. Now I just want to add some query to that routine, to get some additional statistics from a database table which should go into that file.

So, can I execute an SQL query in routine activity stage.
If so, can you please help me how to do that

thanks in advance
kris

srinivas.g · Post by **srinivas.g** » Tue Jun 14, 2011 5:18 am

Better write one unix script ,in that call your sql query through sql plus. Call the same unix script from execute command activity.

chulett · Post by **chulett** » Tue Jun 14, 2011 6:11 am

Yes, you can execute SQL from a routine but it is on the complex side which a search here for "BCI" would reveal. Easier to leverage the command line interface (like sqlplus in Oracle) via DSExecute().