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 SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Submit job from Cobol with input data abdulrafi COBOL Programming 4 Wed Feb 01, 2017 12:41 pm
No new posts Dynamic array request/response contai... Suja.Sai CICS 2 Tue Jan 24, 2017 11:37 am


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