I have a major project wherein I have to clean up some 500k string records in a DB2 environment. This entails removing line breaks, tabs, stray code, etc. Unfortunately, I'm not as familiar with DB2 as I thought. I tried to use REPLACE() and CHR() functions, but CHR() does not work: (Error: CHR in *LIBL type *N not found). What can I use in its place?
December 13, 2013 4:00 PM
December 14, 2013 9:08 AM