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 thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.