|
View previous topic :: View next topic
|
| Author |
Message |
Rani
New User
Joined: 23 Oct 2003
Posts: 2
|
|
|
|
Pls provide references/Samples for the using Dynamic SQLs in COBOL for OS/390.
Thanks |
|
| Back to top |
|
 |
mdtendulkar
Active User
Joined: 29 Jul 2003
Posts: 237
Location: USA
|
|
|
|
Hello Rani,
Have a look at the link below, this will give you some information about the same.
[url]
| Code: |
| http://sybooks.sybase.com/onlinebooks/group-cnarc/cng1000e/cobguide/@Generic__BookTextView/6015 |
[/url]Link broken
[url]
| Code: |
| http://www.csis.gvsu.edu/GeneralInfo/Oracle/appdev.920/a96590/adg09dyn.htm |
[/url]Link broken
If you want some other resources you can fire a query in Google with the following string 'dynamic sql in cobol'
Hope this helps,
Regards
Mayuresh Tendulkar |
|
| Back to top |
|
|
yesgokul
New User
Joined: 20 Aug 2003
Posts: 9
|
|
| Back to top |
|
|
Rani
New User
Joined: 23 Oct 2003
Posts: 2
|
|
|
|
Hi mdtendulkar/yesgokul,
ThanX for the Links. Just one clarification. my requirement needs the Table name to be changing. For eg. T1, T2, T3 etc. The number value appended is obtained at runtime. I beleive this can be done in a Procedure. But can I use a host variable for the table name in the embedded dynamic SQL?
Regards
Rani |
|
| Back to top |
|
|
yesgokul
New User
Joined: 20 Aug 2003
Posts: 9
|
|
|
|
Hi Rani,
Sorry for the late reply. From what i Know, if the table name is changing then you have to prepare the SQL stmt again & continue processing.(maybe there's another way).
Let me know if you need more info.
Thanks,
Gokul |
|
| Back to top |
|
|
|
|
