Close statement in oracle enterprise edition stage

varshanswamy · Post by **varshanswamy** » Thu Jul 12, 2007 2:04 am

Hi All,

I would like to know if we can use multiple close statements, where we run muliple select statement per close statement in the Oracle Enterprise Edition Stage.

regards,
varsha

ray.wurlod · Post by **ray.wurlod** » Thu Jul 12, 2007 5:11 am

Have you tried to and, if so, with what result? What does the manual or on-line help suggest?

varshanswamy · Post by **varshanswamy** » Fri Jul 13, 2007 4:24 am

ray.wurlod wrote:Have you tried to and, if so, with what result? What does the manual or on-line help suggest? ...

Ray,

It did'nt allow to do so, I belive it is possible to us multiple close statements when we use DB2 Enterprise Edition, and there has been no reference abt how many close statements can be used in the manual.

regards,
varsha

DSguru2B · Post by **DSguru2B** » Fri Jul 13, 2007 6:07 am

I doubt you can use multiple statements. But as Ray said, if you can get it to work, well and good. Try it with different syntax. End it with semicolon without a newline character, with a newline etc.

chulett · Post by **chulett** » Fri Jul 13, 2007 7:04 am

The Parallel Job Developer's Guide states:

This is an optional property and only appears for the Load Write Method. Use it to specify any command, in single quotes, to be parsed and executed by the Oracle database on all processing nodes after the stage finishes processing the Oracle table. You can specify a job parameter if required.

Note that it says "command", singular.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 13, 2007 3:19 pm

What would you do with the output of "multiple SELECT statements" in a Close command anyway?

You could always build them into a stored procedure and invoke that. Might even make redirecting/capturing their output easier.