Originally posted by: Greenspan

Our system uses ISO20022 XML messages ("pain.001.001.02" ). We want to migrate the processing to a batch job running WTX. We are facing a problem where the file when transferred to mainframe are being wrapped at end of records.When the map reads the file it considers the wrapping round as an insert of a <CR><LF> and fails.To illustrate the point let's say the XML data is as below

<GrpHdr><MsgId>XMLHVBMJUL17D</MsgId><CreDtTm>2008-07-14T10:07:13.206</CreDtTm><BtchBookg>false</BtchBookg><NbOfTxs>1....

However if the record length of the mainframe file is such that the record ends at " <BtchBookg>fals " then the mainframe file looks as below

<GrpHdr><MsgId>XMLHVBMJUL17D</MsgId><CreDtTm>2008-07-14T10:07:13.206</CreDtTm><BtchBookg>fals
e</BtchBookg><NbOfTxs>1....

The map considers the line wrapping as insertion of CRLFs and rejects.
Is there anyway we can handle that inside WTX ?

Thanks and regards
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: phil2030

Not been on that particular OS, but the simplest thing I can think of is to simply have a "wrapper" map read in the 'n' char records and then just do a seriestotext on them. You should then be able to echo the result into your map that reads XML with no CR+LF pairs every 'n' chars. Or you could just read the data in as a BLOB/CLOB and replace all the CR+LF pairs. You might of course run into other issues doing it this way e.g. if you have CDATA elements with CR+LF in which just happen to fall on the boundary.
Is there not some OS feature that stops this though...? Is it down to the transfer method...?
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: Greenspan

I have been trying various options. Including your suggestion. It seems this is the way to go for now. I am trying to replace the CRLFs . So far it is working .

Thanks for your reply.
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender