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

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

Question:

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

 

Answer:

REDO/UNDO SQL generated by CA Log Analyzer for DB2 for z/OS (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