Pass an entire SQLQuery as a parameter, in userdefined sql?

ds_infy · Post by **ds_infy** » Fri Jul 31, 2009 12:19 am

I have a job that extracts records from an oracle db. The same job is used to extract where only the SQL query changes. Can i use the same job for both extracts by passing the Query as a parameter?If so is there any particular syntax that needs to be adhered to?

BugFree · Post by **BugFree** » Fri Jul 31, 2009 1:43 am

Yes. We can parameterize the query. No seperate syntax.
It worked for me for simple queries.
I am not sure about the complex/Huge queries.

One more thing is, if you are running this job at a time for different queries, make sure that you build this job with Multi Instance enabled.

ArndW · Post by **ArndW** » Fri Jul 31, 2009 1:43 am

Yes, the user-defined query can be a parameter. You just have to ensure that the column names and number of columns returned matches.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jul 31, 2009 2:19 am

Lookout for any quote or special characters which may interrupt the string.