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

Accessing VSAM File


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Jad

New User


Joined: 29 Jul 2005
Posts: 1

PostPosted: Mon Aug 01, 2005 11:17 pm
Reply with quote

Hi,

I have a scenario where a same VSAM file will be accessed by multiple Jobs at the same time in read mode. Is it possible to access or it will fail for accessing problem.

Thanks in advance,
Jad
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Mon Aug 01, 2005 11:30 pm
Reply with quote

It is possible.Anyhow try it as u are just reading it .I think they should be no problem.
Back to top
View user's profile Send private message
Ravi gaur

New User


Joined: 12 Jul 2005
Posts: 38

PostPosted: Tue Aug 02, 2005 12:21 pm
Reply with quote

Jad,

if you will access the file in the edit mode it will fail (exclusive use in the edit mode) however if you will access this in the view or browse mode no problem at all..


If you have any concerns please let me know
Back to top
View user's profile Send private message
bandi

New User


Joined: 21 Jul 2005
Posts: 12

PostPosted: Wed Aug 03, 2005 12:29 pm
Reply with quote

what are the pre -requisites in cobol program while using cobol-db2 program? can you ple let me know asap

kishore
Back to top
View user's profile Send private message
vijayamadhuri

Active User


Joined: 06 Apr 2005
Posts: 180

PostPosted: Mon Aug 08, 2005 11:39 pm
Reply with quote

First u choose the method of communication with db2 which could be one of these
Static SQL
? Embedded dynamic SQL
? Open Database Connectivity (ODBC)
? JDBC application support

Then u declare all the tables and views required in the w-s section/linkage section

U then declare host variables and host structures.These are required for holding the data that is being retreived from the table something similar to the w-s variables we have in a cobo pgm.

then follows the precompile ,bind process after u finished writing the complete program
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 1
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 Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
Search our Forums:

Back to Top