> The report is somehow formatted, however columns are separated with 'X00' > characters.
I believe the binary zeros you see are for columns that are defined with NULL. You can use the scalar function IFNULL or Coalesce to convert them to spaces/zeroes https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-ifnull https://www.ibm.com/docs/en/db2-for-zos/13.0.0?topic=functions-coalesce Thanks, Sri Hari Kolusu ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
