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 Profile Log in to check your private messages Log in
 
Accessing VSAM File

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
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    Post subject: Accessing VSAM File
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    Post subject: Hi
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    Post subject:
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    Post subject: pre-requisites in cobol program while using cobol-db2 progra
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    Post subject: HI
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    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm
No new posts editting the file by inserting zeros ... pramodrsingh DFSORT/ICETOOL 9 Mon Aug 21, 2017 5:58 pm
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am

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