I'm trying to find and clean up line breaks, carriage returns, tabs and "SUB"-characters in a set of 400k string records but I'm having a ton of trouble with my DB2 environment.
After doing some searching, and I thought replacing with the "REPLACE()" and "CHR()" functions could work, but it's not available on our system. Here's what I'm working with:
DBMS = DB2
System = iSeries
Language = SQL
Encoding = Not sure, possibly EBCDIC
Any hints on what I could do?
December 20, 2013 4:52 PM
December 20, 2013 7:16 PM