CONCAT function - Concatenates VARBINARY values into a single value

The CONCAT function concatenates up to twelve (12) VARBINARY values into a single value.

Syntax

Read syntax diagramSkip visual syntax diagramUTL_RAW.CONCAT( inputN)

Parameters

inputN
An input argument of type VARBINARY(32672) that specifies the value to be concatenated. This function supports up to 12 input values.

Authorization

EXECUTE privilege on the UTL_RAW module.

Example

Example 1: The following example concatenates three VARBINARY values into a single value:
db2 "select sysibmadm.utl_raw.concat(bx’0101’, bx’F0F0’, bx’AAAAA’) from sample "

1          
-----------
          X’0101F0F0AAAAA’

  1 record(s) selected.