Sql query as parameter

LD · Post by LD » Wed Feb 02, 2011 9:15 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Feb 02, 2011 3:09 pm

No real limit. Try it. It works.

chulett · Post by **chulett** » Wed Feb 02, 2011 11:04 pm

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.

LD · Post by LD » Thu Feb 03, 2011 4:05 pm

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

Thanks,

Shashank