Declaration of large object locator type host variables in REXX embedded SQL applications

You must declare LOB locator host variables in your application. When a REXX embedded SQL application encounters these declarations the host variables are treated as locators for the remainder of the program. Locator values are stored in REXX variables in an internal format.
The syntax for declaring LOB locator host variables in REXX is:
Read syntax diagramSkip visual syntax diagramDECLARE ,:variable-name LANGUAGE TYPE BLOBCLOBDBCLOB LOCATOR
Example: 
   CALL SQLEXEC 'DECLARE :hv1, :hv2 LANGUAGE TYPE CLOB LOCATOR'

Data represented by LOB locators returned from the engine can be freed in REXX/SQL using the FREE LOCATOR statement which has the following format:

Syntax for FREE LOCATOR statement

Read syntax diagramSkip visual syntax diagramFREELOCATOR ,:variable-name
Example: 
   CALL SQLEXEC 'FREE LOCATOR :hv1, :hv2'