SUBSTR function

The SUBSTR function provides the capability to return a portion of a large object.

The function returns a BLOB(32767) (for a BLOB) or VARCHAR (for a CLOB) value for the returned portion of the large object read by the function.

Syntax


1  SUBSTR ( lob_loc?  , amount?  , offset  )

Parameters

lob_loc
An input argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object to be read.
amount
An optional input argument of type INTEGER that specifies the number of bytes or characters to be returned. The default value is 32,767.
offset
An optional input argument of type INTEGER that specifies the position within the large object to begin returning data. The first byte or character is at position 1. The default value is 1.