cpyfrmimpf

Subject: cpyfrmimpf
From: A Paul <amandapaul1@xxxxxxxxxxx>
Date: Sat, 5 Jan 2013 22:52:31 +0000 (GMT)
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Hello All,

Below is one record of my csv file downloaded into AS/400 as a flat file, I'm trying to load this file into externally described physical file.

date1,client id, principal, date2, balance, type, date3, net amount
12/17/2012,FIT:20111004:3739:25:50118:3,"7777.99",12/17/2012,"154,700.00",Float,12/17/2012,"-15,879.47"

CPYFRMIMPF FROMFILE(DEVlib/FTPCSVF) TOFILE(DEVLIB/LOCALPF) MBROPT(*REPLA
CE) RCDDLM(*CRLF) STRDLM(*NONE) FROMRCD(2)

When I did the above command(CPYFRMIMPF) I got just first field in LOCALPF with error, Data from file FTPCSVF in DEVMN truncated to 1 characters.

Then I build DDS and defined schema for 8 fields in physical file(LOCALPF) and did cpyfrmimpf, data does nt sit properly due to principal, balance and net amount fields carry double quotes. I would appreciate your help if you could provide some solution to this. Thanks very much.

Thanks
A

This thread ...

Start TCP/IP in CHGIPLA or in QSTRUP; TELNET may not restart , Eric Lehti

Re: Start TCP/IP in CHGIPLA or in QSTRUP; TELNET may not restart , Jerry Draper

RE: Start TCP/IP in CHGIPLA or in QSTRUP; TELNET may not restart , Jerry C. Adams

RE: Start TCP/IP in CHGIPLA or in QSTRUP; TELNET may not restart , Porterfield, Sean
cpyfrmimpf, A Paul <=
Re: cpyfrmimpf , CRPence
Re: cpyfrmimpf , A Paul
Re: cpyfrmimpf , A Paul
Re: cpyfrmimpf , John Yeung

References:
- Start TCP/IP in CHGIPLA or in QSTRUP; TELNET may not restart , Eric Lehti
- Re: Start TCP/IP in CHGIPLA or in QSTRUP; TELNET may not restart , Jerry Draper
- RE: Start TCP/IP in CHGIPLA or in QSTRUP; TELNET may not restart , Jerry C. Adams
- RE: Start TCP/IP in CHGIPLA or in QSTRUP; TELNET may not restart , Porterfield, Sean

Prev by Author: Update information on SQL
Next by Author: Re: cpyfrmimpf
Previous by thread: RE: Start TCP/IP in CHGIPLA or in QSTRUP; TELNET may not restart
Next by thread: Re: cpyfrmimpf
Index(es):

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact