We took the easy way out, and FTP'd the .CSV to a flat 400 file (CrtPF
RcdLen(500 or so)).  This was because it was originating on a PC anyway.
Then copied to QTEMP FromRcd(2) prior to CpyFrmImpF.  Mebbe some part of
this would work for you.  (Cumbersum process, a li'l, but just a couple/few
lines of code.  Main advantage being it didn't need tested much, which is
where I "lose" THE MOST time.)  Plenty of other types of solutions, of

| -----Original Message-----
| [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Kelly Cookson
| Sent: Friday, March 19, 2004 1:50 PM

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

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.