View previous topic :: View next topic
|
Author |
Message |
Jayalakshmi
New User
Joined: 02 Sep 2005 Posts: 26 Location: Hyderabad
|
|
|
|
Hi all,
I want some sample code on how the below mentioned logic could be implemented:
The requirment is:
(1) Select col1,col2,col3 from table&date
Here, &date is variable.
(2) Suppose, I want to execute the above mentioned SQL 12 times by varying the value of &date as yymm i.e., 0503, 0504, ...0603
Any suggestions on how to implement this requirement?
Regards,
Jaya. |
|
Back to top |
|
|
anamikak
New User
Joined: 10 May 2006 Posts: 64 Location: Singapore
|
|
|
|
dynamic sql might help.
Anamika |
|
Back to top |
|
|
Muthukumar.PLindia
New User
Joined: 03 Jul 2006 Posts: 51 Location: Chennai
|
|
|
|
hi Anamika,
I find the statements for executing dynamic sql statements from cobol, using execute immediate command...
HOwever, could you brief aout how this program be compiled.. (i guess no need for binding in a plan)... and also explain abt runningg these programs |
|
Back to top |
|
|
|