When displaying QMF (V8.1) Query Results as an Excel spreadsheet, the Line control X'0A' characters within the data fields are causing:
fields to split (multiple fields) where the where the LineControl characters occur and,
the field and record to be continued [strong][em]on the following Excel row[/em][/strong].
I've tried the replace comand Replace(T.T_Task_Desc , X'0D', ' '). It is sucessfull in replacing the x'0D' carriage return with a space.
However the same command when used on the X'0A' line break does not seem to work.
Does anyone know of a way I can replace the X'0A' with a space?
Software/Hardware used: QMF DB2
Ask a Question
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!