getSubStrFromClob()

The system function LobLib.getSubStrFromClob returns a substring from the value referenced by a variable of type CLOB.

  LobLib.getSubStrFromClob(
    clobVariable CLOB in,
    pos BIGINT in, 
    length BIGINT in)
  returns (result STRING)" 
result
A value of type STRING.
clobVariable
The variable of type CLOB.
pos
Identifies the numeric position of the character that starts the substring. The first character in the CLOB variable is at position 1.
length
Identifies the number of characters in the substring.

Related reference
CLOB
EGL library LobLib

Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.