|
I'm trying to copy an excel spreadsheet from the IFS to an externally
described file whose fields allow nulls using CPYFRMIMPF as follows:
CPYFRMIMPF FROMSTMF('/QDLS/BW/BW/XFER/EDIPACER.XLS')
TOFILE(WLIBWH/MATPICK) MBROPT(*REPLACE) RCDDLM(*CRLF)
I get the following error messages:
Message ID . . . . . . : CPIA082 Severity . . . . . . . : 10
Message type . . . . . : Information
Date sent . . . . . . : 11/24/04 Time sent . . . . . . : 12:10:48
Message . . . . : End-of-file found before physical end of file.
Cause . . . . . : An end-of-file character was found in the stream file
before the end of the stream file was reached.
Recovery . . . : Check to ensure correct stream file code page is
specified, then submit the command again.
Message ID . . . . . . : CPF2973 Severity . . . . . . . : 10
Message type . . . . . : Diagnostic
Date sent . . . . . . : 11/24/04 Time sent . . . . . . : 12:10:48
Message . . . . : Data from file QACP678463 in QRECOVERY truncated to 3
characters.
Cause . . . . . : The maximum record length for member QACP678463 in
from-file QACP678463 in library QRECOVERY is longer than the maximum
record
length for to-file MATPICK in library WLIBWH.
Technical description . . . . . . . . : If the from-file is a tape file
with
variable length records or if multiple record formats are copied from a
logical file, only the records that are longer than 3 characters are
truncated. If the to-file has a *FCFC value on the CTLCHAR parameter
for
the printer file, the record length includes one byte for a control
character. If the from-file and to-file are different file types (*SRC
or
*DATA), this message is sent only if the data part of from-file records
is
truncated in the to-file. If FMTOPT(*NULLFLAGS) was specified then the
maximum record length of the to-file is the sum of the to-file record
length
and the number of null-capable fields in the to-file.
I'm only getting 1 record copied and only 3 characters in that record (the
length of the first field) and they're garbage. Can someone please tell
me what I'm doing wrong? Thanks,
Dave
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.