Samples for the using Dynamic SQLs in COBOL for OS/390

Rani · New User Joined: 23 Oct 2003 Posts: 2

Pls provide references/Samples for the using Dynamic SQLs in COBOL for OS/390.

Thanks

mdtendulkar · Active User Joined: 29 Jul 2003 Posts: 257 Location: USA

Hello Rani,

Have a look at the link below, this will give you some information about the same.

http://sybooks.sybase.com/onlinebooks/group-cnarc/cng1000e/cobguide/@Generic__BookTextView/6015

http://www.csis.gvsu.edu/GeneralInfo/Oracle/appdev.920/a96590/adg09dyn.htm

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

yesgokul · New User Joined: 20 Aug 2003 Posts: 9

The following is the link for a Redbook from IBM.
http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246418.html?Open

Samples for Dynamic sql are present in ftp://www.redbooks.ibm.com/redbooks/sg246418/

Thanks,
Gokul

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

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