DSXchange

Hello All,

In my job, I want to run multiple sql queries in oracle stage and pass the output to a sequential file using RCP.

In parallel jobs, I can not provide sql in a file for oracle stage. This option is available with server jobs. This would have been first preference but looks like not possible. Any one know any hidden method to do so?

If not, I need to pass the sql as parameter. My queries will be huge in size. Is there any upper limit on parameter size to type String?

Thanks,

Shashank

No real limit. Try it. It works.

While there may be 'no limit' to the parameter string size, there is definitely one for SQL in the Oracle stage. Check with your official support provider.

Thanks Ray and Craig for clarification. I'm going ahead for now and will check with IBM on the Oracle stage limits.

Thanks,

Shashank