The CONVERTTOBLOB procedure provides the capability to
convert character data to binary.
Syntax
>>-DBMS_LOB.CONVERTTOBLOB--(--dest_lob--,--src_clob--,--amount--,-->
>--dest_offset--,--src_offset--,--blob_csid--,------------------>
>--lang_context--,--warning--)---------------------------------><
Parameters
- dest_lob
- An input or output argument of type BLOB(10M) that specifies the
large object locator into which the character data is to be converted.
- src_clob
- An input argument of type CLOB(10M) that specifies the large object
locator of the character data to be converted.
- amount
- An input argument of type INTEGER that specifies the number of
characters of src_clob to be converted.
- dest_offset
- An input or output argument of type INTEGER that specifies the
position (in bytes) in the destination BLOB where writing of the source
CLOB should begin. The first byte is offset 1.
- src_offset
- An input or output argument of type INTEGER that specifies the
position (in characters) in the source CLOB where conversion to the
destination BLOB should begin. The first character is offset 1.
- blob_csid
- An input argument of type INTEGER that specifies the character
set ID of the destination BLOB. This value must match the database
codepage.
- lang_context
- An input argument of type INTEGER that specifies the language
context for the conversion. This value must be 0.
- warning
- An output argument of type INTEGER that always returns 0.
Authorization
EXECUTE privilege on the DBMS_LOB
module.
DB2 10.5 for Linux, UNIX, and Windows