Export to text file with Trailer Record

  • Thread starter Thread starter dee
  • Start date Start date
D

dee

We need to export records to a fixed width text file and
then add a trailer record with "TRLR" and the record count
[00000000 -zero filled, 8 char].

Anyone have any code already done on adding the trailer
record? If not, any ideas?

Sorry for the two posts...I'm just in a time crunch.

Appreciate any insight anyone can give me.

Feel free to email me direct.

Dee
 
I'd write the record out using the PRINT statement. An alternative is to
export a query then open the file, loop through it counting, and append a
row using the PRINT statement.

I've used it about 1,000 times and it work everytime.

Hope it helps.

Lance
 
Back
Top