How to generate UNDO SQL in UNICODE instead of EBCDIC for VARGRAPHIC columns using CA Log Analyzer.

Document ID : KB000021973
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Have tables with VARGRAPHIC columns in UNICODE.  Need to be able to generate UNDO SQL that will come out in UNICODE using CA Log Analyzer for DB2 for z/OS (PLA).  Currently the UNDO SQL is generated in EBCDIC.

 

Answer:

PLA is working as designed.  The UNICODE data will be converted to EBCDIC.  SPUFI or CA Batch Processor is expecting the data to be in EBCDIC.  The data will be converted back to UNICODE upon the SQL execution.