I've had good success by saving the Excel as tab-delimited text, then using the PC5250 data transfer wizard to set up the .FDF and send it to the 400. CPYFRMIMPF works OK on tab-delim files too.
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
Download Excel file to AS400 Physical File
Collapse
X
-
Download Excel file to AS400 Physical File
Winnie, Download the CPYFRMIMPF PTF that will automatically convert NULLs to blanks and zeros for you. The problem is that your database fields do not have ALWNUL specified and your import file has "" null values in it. Alternatively, you could specify a dummy file that uses ALWNUL and then CPYF from that file to your real file. Chris
Comment
-
Download Excel file to AS400 Physical File
ALWNULL is a DDS keyword just like COLHDG or TEXT that specify at the field level. And, the CpyFrmImpF command has the parm is RPLNULLVAL(*FLDDFT) which would eliminate your need to use ALWNULL. Your version of CpyFrmImpf may not have this parm unless you download the PTF. Chris
Comment
Comment