Re: Deleting first record from stream files in IFS.

Sounds like excellent ideas for DCRs!
http://faq.midrange.com/data/cache/189.html

Add a few options to handle headers to both of those commands.

Go for it!

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Kelly Cookson <kc62301@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/19/2004 01:49 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

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.