Deleting first record from stream files in IFS.

[Kelly Cookson <kc62301@xxxxxxxxx>]

I'm wanting to use a IFS stream file (CSV) to serve as
an interface between MS Excel and iSeries DB2 file. I
have a CL program that uses CPYTOIMPF and CPYFRMIMPF
to transfer data between the stream file and the CSV
file. However, the copy commands do not deal with
headers for the stream file.

I know I can put headers in the first record of the
DB2 file, but this puts limitations on how fields are
defined in the DB2 file. For example, I want to use
DB2 files that have uniquely keyed numeric fields.

I also have a way to put headings into the CSV file
using the DSPFFD command and the IFS APIs in a HLL
program. (DSPFFD to an outfile, call HLL to read
outfile, create heading line for CSV file, use IFS
APIs to clear CSV file and write heading line, then
perform CPYTOIMPF with the *ADD option for data
following the heading line).

My problem is dealing with the headings when
transferring data from the CSV to a DB2 not designed
to handle a record for headings. My only idea at this
point is to use the IFS APIs in an HLL program to read
all CSV records except the first one into a temporary
CSV file, then perform CPYFRMIMPF on the temporary CSV
file.  

Anyone have any better ideas for deleting the first
line (headings) in a stream file in the IFS?

Thanks,
Kelly 

__________________________________
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com