RE: Query in CPYFRMIMPF

Nisha,
Here is what I have been doing to transfer excel files to DB2:
1) open System i Navigator and open the IFS
I have created a personal folder in the IFS which I typically use for projects like this
2) use Excel to save the workbook as a .csv file
(this seem to me quicker and easier than using notepad)
3) As you are doing: use Iseries navigator to place the .csv file to the location I want
4) create a physical file that "matches" the .csv file
5) I use a mix of RPGLE programs and command line CPYFRMIMPF to handle
the actual load of the .csv into the physical file:
RPGLE for daily operations
manual/command line for special one time projects
6) One possible explanation for your problem with
only getting one .csv record is the CPYFRMIMPF RCDDLM parameter
which I usually set to "*LF"


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of WAJE0822
Sent: Friday, October 05, 2012 2:51 PM
To: RPG programming on the IBM i / System i
Subject: Re: Query in CPYFRMIMPF

You can use the Client Access iSeries Navigator add on to Excel to transfer the file directly to a DB2/400 physical file.

On Oct 5, 2012, at 2:49 PM, Nisha Ramesh <n4nisha@xxxxxxxxx> wrote:

Hi,

Could you please extend your help to me as I am stuck here with one issue.
This is the requirement. I have an excel sheet with some rows of data
in it. It is in .xls format. The first row is heading and second row
onwards are data. I need to copy this file to a physical file in
AS400. For this, I have opened the excel, copied the data to a notepad
and I have put the
delimeters(,) after each field and saved it back as .csv. Now I used
Iseries navigator and placed this .csv file onto the location I want it.
Inorder to get the data onto a PF, I am changing an existing RPG
program which uses CPYFRMIMPF. with the help of QCMDEXC. But this command fails.
But when I try to enter the same command from command line it is
copying data to PF. The other issue here is with the heading. If I
include heading,only heading is coming in. But if I remove heading,
then first row alone comes in . Please let me know why the QCMDEXC
fails when it runs properly in command line. Second is if the excel
has one row of heading, how to deal with it? Then how do I copy
multiple rows of data here? It will be really helpful if u respond back..
--
This is the RPG programming on the IBM i / System i (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.

--
This is the RPG programming on the IBM i / System i (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.