Single “Filler” Field Flat File vs Multiple Fields Defined Flat File
What are the Pros and Cons of using a Flat File with a single large field defined compared to a Flat file with multiple defined fields?
For example:
Physical File: TESTFILE1
R TESTFILE
FIELDA 50
Physical File: TESTFILE2
R TESTFILE
DEFINED1 20
DEFINED2 10
DEFINED3 5
DEFINED4 15
Software/Hardware used:
Software/Hardware used:
ASKED:
February 3, 2009 3:20 PM
UPDATED:
February 4, 2009 11:25 AM
Answer Wiki:
Hi,
If you have fields defined, then it's not really a "flat" file anymore. I can't honestly think of what you gain or lose by doing this, unless you're going to define the file completely with every possible field.
If you need to access data in position 2-3 and you don't have that position defined as a field, then you will still need to define a subfield or substring of the data.
Regards,
Martin Gilbert.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
