IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

how can access db2 data onto cics


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ravi_asgm
Warnings : 2

New User


Joined: 07 Jun 2007
Posts: 5
Location: ap

PostPosted: Mon Jun 25, 2007 11:53 am
Reply with quote

how can access db2 data onto cics
and from cics to db2
Back to top
View user's profile Send private message
ParagChouguley

Active User


Joined: 03 Feb 2007
Posts: 175
Location: PUNE(INDIA)

PostPosted: Mon Jun 25, 2007 11:57 am
Reply with quote

Hi,
You can do this, as the same way you do in batch programs, using SQL queries.

--Parag
Back to top
View user's profile Send private message
Nimesh.Srivastava

New User


Joined: 30 Nov 2006
Posts: 78
Location: SINGAPORE

PostPosted: Mon Jun 25, 2007 7:33 pm
Reply with quote

Ravi,
Your query spawns multiple aspects
1. how is CICS initiating a DB2 connection
2. accessing DB2 data using SQL queries from a CICS defined transaction
3. compiling and linking of a program utilizing SQL commands in CICS env
Please specify which of the above you need help on.
Thanks
Nimesh
Back to top
View user's profile Send private message
socker_dad

Active User


Joined: 05 Dec 2006
Posts: 177
Location: Seattle, WA

PostPosted: Tue Jun 26, 2007 1:32 am
Reply with quote

Chapters 6, 7 and 8 of Murach's DB2 for the COBOL Programmer Part 2 has an excellent example of exactly how to do this. I have used it with great success.

http://www.murach.com/books/db2r/index.htm
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts Using API Gateway from CICS program CICS 0
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts How to access web services/website? Mainframe Interview Questions 4
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
Search our Forums:

Back to Top