GETLENGTH function

The GETLENGTH function returns the length of a large object.

The function returns an INTEGER value that reflects the length of the large object in bytes (for a BLOB) or characters (for a CLOB).

Syntax

Read syntax diagramSkip visual syntax diagram
>>-GETLENGTH--(--lob_loc--)------------------------------------><

Parameters

lob_loc
An input argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object whose length is to be obtained.

Copyright© 2019 HCL Technologies Limited