DNIBLOB2VARCHAR: BLOB to VARCHAR

The user-defined DB2® function (UDF) DNIBLOB2VARCHAR returns the variable-length character (VARCHAR) representation of character code points stored in a binary large object (BLOB). If a null value is specified for any of the mandatory input parameters, DNIBLOB2VARCHAR returns a null value.

input_blob

The BLOB value that is to be converted to character data. To convert FIN messages that are stored in the audit log, specify the column name "AM_BODY".

ccsid

The CCSID of the code page used to encode the character data contained in <input_blob>. This CCSID must be one of those listed in Table 1, and the corresponding character set must be supported by your Java™ runtime environment (see Listing character set names). To convert FIN messages that are stored in the audit log, specify the column name "AM_BODY_CCSID".

REPORT

If one or more code points in the input BLOB cannot be mapped to a character, the function terminates and sets:

• SQLCODE = -1
• SQLSTATE = 38W05

REPLACE

If one or more code points in the input BLOB cannot be mapped to a character, each code point that cannot be mapped to characters is represented by the replacement character specified by the repchar parameter.

repchar

The character with which code points that cannot be mapped to characters are to be replaced. The default is the substitution character of the encoding scheme of the program that issues the SQL command.

If the input BLOB cannot be converted, DNIBLOB2VARCHAR returns one of the following SQLSTATE values:

38W01

Character conversion from the indicated CCSID is not supported. Check whether your Java runtime environment supports the corresponding character set (see Listing character set names).

38W04

Error reading the CCSID mapping file, which has the name ccsid_UNIX.properties. The fully qualified name of this file is indicated by the SQL error message.

38W05

The error action REPORT was specified, and the input BLOB contains unmappable code points.

38W06

An invalid value was specified for the indicated parameter.

38W07

The length of the output VARCHAR exceeds 32672 bytes.