View previous topic :: View next topic
|
Author |
Message |
tarun_bhardwaj
New User
Joined: 18 Jul 2003 Posts: 39 Location: delhi
|
|
|
|
I need to execute multiple SQL SELECT statements (present in a dataset) thru JCL and want to capture the results in SYSOUT. Can someone please provide me with a sample JCL to achieve this. |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
Back to top |
|
|
r.ravikumar
New User
Joined: 05 Jan 2007 Posts: 18 Location: chennai
|
|
|
|
HI tarun,
We can execute the SQL statement in the JCL using the utility SQLPLUS. But make suer that you have given all the necessary DB2 or Oracle Libraries, and connection protocols. |
|
Back to top |
|
|
|