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
 
why do we use VSAM files instead of ordiary files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
princeaggarwal

New User


Joined: 22 Feb 2007
Posts: 5
Location: Chandigarh

PostPosted: Thu Apr 05, 2007 1:46 pm    Post subject: why do we use VSAM files instead of ordiary files
Reply with quote

VSAM files are for reason being used in Mainframe.
Back to top
View user's profile Send private message

vkphani

New User


Joined: 29 Oct 2003
Posts: 29

PostPosted: Thu Apr 05, 2007 1:52 pm    Post subject:
Reply with quote

1. You can have primary key in case of VSAM files.
2. You can not add or delete records in an ESDS file.
3. Faster access to data.
4. CICS supports only VSAM files.

and many more.
Back to top
View user's profile Send private message
vkphani

New User


Joined: 29 Oct 2003
Posts: 29

PostPosted: Thu Apr 05, 2007 1:53 pm    Post subject:
Reply with quote

5. You can directly go to a particular record in case of RRDS file.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8619
Location: Back in jolly old England

PostPosted: Thu Apr 05, 2007 1:57 pm    Post subject:
Reply with quote

Quote:
2. You can not add or delete records in an ESDS file.

Are you sure about this ?
Back to top
View user's profile Send private message
vkphani

New User


Joined: 29 Oct 2003
Posts: 29

PostPosted: Thu Apr 05, 2007 2:03 pm    Post subject:
Reply with quote

Quote:
Are you sure about this ?


Yes
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8619
Location: Back in jolly old England

PostPosted: Thu Apr 05, 2007 2:03 pm    Post subject:
Reply with quote

Quote:

1. You can have primary key in case of VSAM files.
2. You can not add or delete records in an ESDS file.
3. Faster access to data.
4. CICS supports only VSAM files.


Point 1 - you can also have one or more alternate index(es) to acces the data via fields which are not the key of the base cluster.

Point 2 - In addition to the point raised in my previous post, ESDS can also be accessed via alternate index(es)

Point 3 - probably not since the introduction in RAID DASD technology.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Split files upto certain limit based ... bubbu75 DFSORT/ICETOOL 5 Tue Nov 14, 2017 11:11 pm
No new posts Copy selected columns from 2 input fi... Poha Eater DFSORT/ICETOOL 3 Thu Nov 02, 2017 3:43 pm
No new posts Finding difference between two PS fil... Vignesh Sid SYNCSORT 5 Mon Oct 30, 2017 1:13 pm

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