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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.