RE: Deleting first record from stream files in IFS.

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Perhaps you should request a design change to the CPY...IMPF commands to
support optional heading rows.  Also needed is the option to trim blanks
from exported character fields. 

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Kelly Cookson [mailto:kc62301@xxxxxxxxx]
Sent: Friday, March 19, 2004 12:50 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Deleting first record from stream files in IFS.


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
_______________________________________________
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.