DSXchange

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

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

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

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.

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.

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.