DB2 Version 9.7 for Linux, UNIX, and Windows

CURRENT CLIENT_APPLNAME special register

The CURRENT CLIENT_APPLNAME (or CLIENT APPLNAME) special register contains the value of the application name from the client information specified for this connection. The data type of the register is VARCHAR(255). The default value of this register is an empty string.

The value of the application name can be changed by using the Set Client Information (sqleseti) API or the wlm_set_client_info procedure.

Note that the value provided via the sqleseti API is in the application code page, and the special register value is stored in the database code page. Depending on the data values used when setting the client information, truncation of the data value stored in the special register may occur during code page conversion.

Example: Select which departments are allowed to use the application being used in this connection.

   SELECT DEPT
     FROM DEPT_APPL_MAP
     WHERE APPL_NAME = CURRENT CLIENT_APPLNAME