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

How can one differentiate between a flat file and a VSAM


IBM Mainframe Forums -> HomeWorks & Requests
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
bh

New User


Joined: 19 Mar 2006
Posts: 26
Location: India

PostPosted: Thu May 24, 2007 4:58 pm
Reply with quote

Hi,

How can one differentiate between a flat file and a VSAM file being used in a COBOL program ?


Regards,
gp
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Thu May 24, 2007 6:08 pm
Reply with quote

Isn't a different SELECT specification required?
Back to top
View user's profile Send private message
pingte

Active User


Joined: 03 Dec 2005
Posts: 120
Location: india

PostPosted: Thu May 31, 2007 2:04 pm
Reply with quote

VSAM will have 2 components- data and index. This will be 2 separate files associated with the main file.
Flat file has no such components.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Thu May 31, 2007 2:45 pm
Reply with quote

Quote:
VSAM will have 2 components- data and index.

Where is the index component of an ESDS / RRDS ?
Also an ESDS can have an associated AIX and PATH !
Back to top
View user's profile Send private message
pingte

Active User


Joined: 03 Dec 2005
Posts: 120
Location: india

PostPosted: Thu May 31, 2007 2:57 pm
Reply with quote

KSDS will have data and index component..

Also AIX and PATH are for Alternate Cluster. It can be there for KSDS.
Back to top
View user's profile Send private message
donevin

New User


Joined: 07 Jun 2005
Posts: 70
Location: South Africa

PostPosted: Thu May 31, 2007 4:37 pm
Reply with quote

As William said a different slect statement is required. For flat files access mode and organization must be sequential. For relative record files, organization is relative, access mode can be sequential, random or dynamic and the same goes for key-sequential files where access mode is concerned. For key-sequential files organization is indexed and a record key must be declared. For RR files a relative key must be declared. This is off of the top of my head but should make the differences in the select statement clearer.
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 -> HomeWorks & Requests

 


Similar Topics
Topic Forum Replies
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
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top