Xgetchar

This function extracts the Nth character of a CHAR or CLOB variable. This function runs much faster than the usual functions such as mid$ or seg$ when managing large CLOB data.

Syntax

EXTRACTED_CHARACTER=Xgetchar(CLOB_SOURCE,POSITION)

• CLOB_SOURCE has been declared by using a Clbfile or a Char declaration.
• POSITION has been declared by using an Integer declaration.
• EXTRACTED_CHARACTER has been declared by using a Clbfile or a Char declaration.

Example

# Find the 10th character in a CLOBLocal Clbfile PI_CHAR(0)Local Char CHAR10PI_CHAR=num$(pi) : # contains "3.14158265358979323846264338328"CHAR10=Xgetchar(PI_CHAR,10) : # Returns "5"