Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
Rani

New User


Joined: 23 Oct 2003
Posts: 2

PostPosted: Thu Oct 23, 2003 12:14 pm    Post subject: Samples for the using Dynamic SQLs in COBOL for OS/390
Reply with quote

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

Thanks
Back to top
View user's profile Send private message

mdtendulkar

Active User


Joined: 29 Jul 2003
Posts: 238
Location: USA

PostPosted: Fri Oct 24, 2003 8:55 am    Post subject: Dynamic SQL in COBOL
Reply with quote

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
View user's profile Send private message
yesgokul

New User


Joined: 20 Aug 2003
Posts: 9

PostPosted: Sat Oct 25, 2003 1:20 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
Rani

New User


Joined: 23 Oct 2003
Posts: 2

PostPosted: Mon Oct 27, 2003 1:59 pm    Post subject:
Reply with quote

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
View user's profile Send private message
yesgokul

New User


Joined: 20 Aug 2003
Posts: 9

PostPosted: Mon Nov 03, 2003 9:33 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts REXX - Dynamic file Creation d_sarlie CLIST & REXX 7 Tue Jun 27, 2017 7:30 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us