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

Stored Proc to read VSAM file


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kanisha_prabha

New User


Joined: 10 Mar 2006
Posts: 26

PostPosted: Tue Jan 12, 2010 5:25 pm
Reply with quote

Hi,
I have an online/real-time call to an SP via a webservice. The new requirement is to access some VSAM data.

Can I have the SP directly access VSAM data via something similar to how CICS handles VSAM? eg -

EXEC CICS READ
...
END-EXEC

What will be the best design given that I need to read/update VSAM KSDS along with the current DB2 SELECT/UPDATE that the SP does?

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

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Jan 12, 2010 5:33 pm
Reply with quote

Two of these three Redbooks may help you with this and future inquiries:

DB2 for z/OS Application Programming Topics

DB2 9 for z/OS SPs: Through the CALL and Beyond

DB2 for z/OS SPs: Through the CALL and Beyond
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Error to read log with rexx CLIST & REXX 11
Search our Forums:

Back to Top