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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!