Pass an entire SQLQuery as a parameter, in userdefined sql?
Moderators: chulett, rschirm, roy
Pass an entire SQLQuery as a parameter, in userdefined sql?
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?
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.
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.
Ping me if I am wrong...
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom