Single “Filler” Field Flat File vs Multiple Fields Defined Flat File

20 pts.
Tags:
Flat files
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: