Link to home
Start Free TrialLog in
Avatar of alanjbrown
alanjbrown

asked on

reading and writing files of type record where there is a header or trailer record

How can I read or write files of type record where there is a header and or trailer record which has a different length and structure to the records in the body of the file?
Avatar of developmentguru
developmentguru
Flag of United States of America image

Normally this is done in one of two ways.  XML will allow you to mix this sort of data but it is wildly inefficient.  If you want the speed of a database in what you are working on, this is normally achieved by writing the records to two different tables and loading them separately based on a common ID field.  If you have large volumes of data each data file is normally accompanied by an index (to speed the lookups).
ASKER CERTIFIED SOLUTION
Avatar of 2266180
2266180
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial