What can cause SQL-105 when executing Log Analyzer REDO/UNDO SQL for BLOB column with encoding scheme of ASCII

Products

• Log Analyzer for DB2 for z/OS

Issue/Introduction

What can cause SQL-105 when executing Log Analyzer for Db2 for z/OS (PLA) REDO/UNDO SQL for BLOB column with encoding scheme of ASCII?

Resolution

REDO/UNDO SQL generated by PLA that includes a BLOB column may encounter a -105 SQL error when the encoding scheme of the table is ASCII.

Please review IBM APAR PM37439 with title:
SQLCODE105 WHEN INSERT DATA INTO BLOB TYPE COLUMN OF ASCII TABLE WITH HEX CONSTANT