Re: Deleting first record from stream files in IFS.

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Kelly,

You can use an interim file, do the CPYTOIMPF to that file and than either:
a) CPYF thatfile FROMRCD(2) *ADD
b) process it in an RPG prgramme sequentially and do SETLL on second record 
before starting reding the file.

Just some thoughts.

Regards,
Carel Teijgeler.

*********** REPLY SEPARATOR  ***********

On 19-3-04 at 10:49 Kelly Cookson wrote:

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