View previous topic :: View next topic
|
Author |
Message |
princeaggarwal
New User
Joined: 22 Feb 2007 Posts: 5 Location: Chandigarh
|
|
|
|
VSAM files are for reason being used in Mainframe. |
|
Back to top |
|
|
vkphani
New User
Joined: 29 Oct 2003 Posts: 29
|
|
|
|
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 |
|
|
vkphani
New User
Joined: 29 Oct 2003 Posts: 29
|
|
|
|
5. You can directly go to a particular record in case of RRDS file. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Quote: |
2. You can not add or delete records in an ESDS file. |
Are you sure about this ? |
|
Back to top |
|
|
vkphani
New User
Joined: 29 Oct 2003 Posts: 29
|
|
|
|
Quote: |
Are you sure about this ? |
Yes |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
|