Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am
No new posts ALPHABETIC check in COBOL vidyaa COBOL Programming 8 Thu Aug 17, 2017 7:13 pm
No new posts XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us