LOB Host Variable Clearing in REXX embedded SQL applications

On Windows operating systems, it might be necessary to explicitly clear REXX SQL LOB locator and file reference host variable declarations as they remain in effect after your application program ends. This occurs because the application process does not exit until the session in which it is run is closed. If REXX SQL LOB declarations are not cleared, they can interfere with other applications that are running in the same session after a LOB application has been executed.

The syntax to clear the declaration is:

   CALL SQLEXEC "CLEAR SQL VARIABLE DECLARATIONS"

You should include this statement at the end of LOB applications. Note that you can include it anywhere as a precautionary measure to clear declarations which might have been left by previous applications, such as at the beginning of a REXX SQL application.