Re: Read CSV file from IFS

[Jeff Young <cooljeff913@xxxxxxxxx>]

James,
Thanks, I did not see that parm on the CPYFRMIMPF command.
I added it and now it works the way I wanted.

 
Jeff Young 
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3 
  
 





----- Original Message ----
From: James Perkins <jrperkinsjr@xxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, October 14, 2008 2:47:04 PM
Subject: Re: Read CSV file from IFS

Jeff,
Writing a customer parser is most likely a bit overkill. Try adding the
RPLNULLVAL(*FLDDFT) to the CPYFRMIMPF command. That might give you want you
are after.

James R. Perkins


On Tue, Oct 14, 2008 at 11:43 AM, Jeff Young <cooljeff913@xxxxxxxxx> wrote:

> I have a text file in CSV format that I would need to load to a System
> i file.
> Although I can use iSeries Access file transfer, I would prefer to do
> this in a program as I do not want all fields.
> Some of the fields in the CSV file are NULL, so unless I change my file, I
> can not use theCPYFRMIMPF command.
> I am comfortable using the System API's to create files on the IFS, but
> have not had to read them.
> What things do I need to be aware of when reading a CSV file?
> How do I tell when a field ends?
> How do I tell when a record ends?
> How do I test the data in the PC field for NULL?
>
> TIA,
>
> Jeff Young
> Sr. Programmer Analyst
> IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions
> V5R2
> IBM  Certified Specialist- e(logo) server i5Series Technical Solutions
> Designer V5R3
> IBM  Certified Specialist- e(logo)server i5Series Technical
> Solutions Implementer V5R3
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.