Re: CSV file with a header

Pat,

I think you need to do it with stream files in the IBM i. There are several
(free) utilities out there that can help you with your request. One that
comes to mind is DBG400's CRTCSVSTMF .

If you want to roll your own, you would need two files, one with the header
info and one with the detail data. Create a STMF file with your header info,
using the same delimiters as your CSV file, and CPY it to a new STMF, let's
call it MyFile.CSV. Then, with the CPYTOIMPF command *ADD your detail data
to MyFile.CSV

HTH,
Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Tue, May 18, 2010 at 11:15 AM, Pat Barber <mboceanside@xxxxxxx> wrote:

I have been asked to create a CSV file to send to an outside company.

They sent me a standard file layout and I created the file just fine using
a file transfer request using Access.

Got a note back and now they want a "header" record inserted as
the first record of the file. This header record is nothing but column
heading with descriptions.

Since the file has fixed field lengths, I can't just put a dummy record
there to create this stupid header.

I need to be able to store the CSV header record somewhere and copy it
as the first record on each file transfer.

Any ideas.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.