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

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

book

Article ID: 21973

calendar_today

Updated On:

Products

Log Analyzer for DB2 for z/OS

Issue/Introduction

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

Resolution

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