Re: CPYFRMIMPF, and none *crlf record delimiters -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Rick, did a google on "record delimiter" and tilde and got this link at Midrange Server - uses the sed command in QShell to replace the tilde with an accepted delimiter (note, I did not say acceptable)

http://www.midrangeserver.com/mgo/mgo092702-story01.html

HTH

Vern

At 04:55 PM 4/7/2003 -0500, you wrote:

I'm trying to copy a stream file to a flat file on the 400 using
CPYFRMIMPF.

the stream file has tildes for record delimiters, so I keyed in this
command:

CPYFRMIMPF FROMSTMF('ifsPath/file.txt')
   TOFILE(mylib/myflatfile) MBROPT(*REPLACE) RCDDLM('~')
   STRDLM(*NONE) RMVBLANK(*NONE) FLDDLM(*TAB) RPLNULLVAL(*FLDDFT)

and I get the following error:

Message ID . . . . . . :   CPF2845
Message . . . . :   The copy did not complete for reason code 11.

  11 - The RCDDLM parameter for a stream file can only be *CR, *CRLF, *LF,
or *LFCR and for a data base file the RCDDLM parameter can be *EOR or a
valid value.

why can't I use a character value instead of cr or lf?

Thanks,

Rick

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.