View previous topic :: View next topic
|
Author |
Message |
sangeetha
New User
Joined: 06 May 2005 Posts: 4
|
|
|
|
why are flat files called so, what makes them different from vsam files? |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
Quote: |
why are flat files called so, |
Interesting question...sorry don't know the answer.
Quote: |
what makes them different from vsam files? |
VSAM Files need to have an index value in it.....there is no such constraints with Flat Files.......
Regards,
Priyesh. |
|
Back to top |
|
|
vasanthanc
New User
Joined: 01 Apr 2005 Posts: 58
|
|
|
|
flat files are called so because they are simple files which stores text, will not have any indexes or keys. Only sequential access is possible. It gives a flat llok to file and hence its called as flat files |
|
Back to top |
|
|
kanak
Moderator
Joined: 12 Mar 2005 Posts: 252 Location: India
|
|
|
|
the organization of VSAM file is different than flat file. The way VSAM file is defined, is it need cluster which will consists of index and data area and that is mandatory.Where as for flat file index is not mandatory.
Flat file which are acces using index is just to make acces faster nothign else, but for VSAM fiel u always need an index. |
|
Back to top |
|
|
brain_s390
New User
Joined: 06 May 2005 Posts: 58 Location: Mumbai
|
|
|
|
Vsam is IBM's virtual storage access method.It provides sequential
indexed relative record dataset.VSAM increases the disk space requirements of systems. This is because VSAM offers certain
capabilities like partial self-reorganization to make things more efficient in data sets that can be
modified. |
|
Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
sangeetha wrote: |
why are flat files called so, what makes them different from vsam files? |
I don't know why they're called "flat files" either. I've heard of programmers referring to ASCII text files as "flat files", but I never heard of anyone referring to mainframe datasets by that term until I started to participate in this and other forums. It seems to me that usually only an applications programmer will refer to a dataset as a "flat file", whereas most of the rest of the IT world will call it a "Physical Sequential" or "QSAM" dataset. |
|
Back to top |
|
|
GAFUR
New User
Joined: 19 May 2005 Posts: 31
|
|
|
|
HI
In VSAM files records are stored in control intervals where as in FLAT files records are stored in blocks.
FLAT files are sequential read . VSAM files can sequential and random read.
In VSAM acess is fast because of organization of records.
In FLAT files you can delete the record logicaly where as in VSAM physical delete is possible. |
|
Back to top |
|
|
|