You are here: LANSA for i User Guide > Appendix C. Technical Notes > User Exit Programs > If the User Exit Program uses SQL CLI

If the User Exit Program uses SQL CLI

As some parts of LANSA use SQL CLI, and there can only be one connection to the IBM i database at a time, LANSA provides a mechanism to obtain its connection handle.

This is by calling the program named DCXP8210 with these parameters:

Description

Type

Length

Usage

Action

*CHAR

3

Use value 'GET'

Handle

*INT

4

If handle is returned as hex '00000000' then LANSA doesn't currently have a connection.