REVERSE function - Reverses a VARBINARY value

The REVERSE function reverses a VARBINARY value.

Syntax

Read syntax diagramSkip visual syntax diagramUTL_RAW.REVERSE(input)

Parameters

input
An input argument of type VARBINARY(32672) that specifies the value to be reversed.

Authorization

EXECUTE privilege on the UTL_RAW module.

Example

Example 1: The following example returns the reverse of a VARBINARY value:
db2 "select sysibmadm.utl_raw.reverse(bx’010203’) from sample "

1          
-----------
          X’030201’

  1 record(s) selected.