QSH CMD(tail -n +2 sourcefilename >targetfilename)

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

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?

This email is for the use of the intended recipient(s) only.  If you have 
received this email in error, please notify the sender immediately and then 
delete it.  If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this email without the author's prior permission.  
We have taken precautions to minimize the risk of transmitting software 
viruses, but we advise you to carry out your own virus checks on any attachment 
to this message.  We cannot accept liability for any loss or damage caused by 
software viruses.  The information contained in this communication may be 
confidential and may be subject to the attorney-client privilege.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.