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
Close statement in oracle enterprise edition stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Thu Mar 11, 2004 10:32 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 48
- Joined: Thu Mar 11, 2004 10:32 pm
Ray,ray.wurlod wrote:Have you tried to and, if so, with what result? What does the manual or on-line help suggest? ...
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
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
You could always build them into a stored procedure and invoke that. Might even make redirecting/capturing their output easier.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.