getSubstrFromClob()

The lobLib.getSubstrFromClob() system function returns a substring from the value referenced by a CLOB variable.

Syntax

  lobLib.getSubstrFromClob(
    clobVariable CLOB in,
    pos BIGINT in, 
    length BIGINT in)
  returns (result STRING)
clobVariable
The CLOB variable. If this parameter has a null value, EGL throws a NullValueException.
pos
Identifies the numeric position of the character that starts the substring. The first character in the CLOB variable is at position 1. If pos is less than 1 or greater than the length of the CLOB, EGL throws a RuntimeException.
length
Identifies the number of characters in the substring. If length is less than 0 or greater than the length of the CLOB, EGL throws a RuntimeException.
result
A value of type STRING.

Feedback