Re: Replacing carriage returns in a data file

[CRPence <CRPbottle@xxxxxxxxx>]

  So intuitively, the EOR for the stream file must be something other 
than *CR; i.e. if a *CR can be embedded in a record, then the 
End-Of-Record intuitively is not a single *CR within the stream.  Thus...

  Seems like the CPYFRMSTMF incorrectly was performed having left 
defaulted the parameter specification ENDLINFMT(*ALL); or possibly 
ENDLINFMT(*CR) was specified.  If so, then presumably the issue would be 
resolved by using any End Line Format specification *other than* either 
of *CR or *ALL; i.e. explicitly request instead, any of: *CRLF, *LF, 
*LFCR, or *FIXED... according to whatever is the End Of Record for the STMF.

Regards, Chuck

On 14 Aug 2013 14:24, Alan Shore wrote:
> <<SNIP>> The carriage return is NOT at the end of the record, but
> somewhere before then
>
> Alan Shore on Wednesday, August 14, 2013 3:52 PM wrote:
>
> > This day just keeps getting better and better (sarcasm switch off)
> > I have now realized that the file (with the carriage return) is
> > created using the command CPYFRMSTMF And the carriage return is in
> > the stream file. This then causes the one record to be split into 2
> > (or more) in the table. I have to replace the carriage return in
> > the ifs prior to the CPYFRMSTMF command. I cannot find any
> > examples of using SQL on an ifs file.