The CURRENT CLIENT_APPLNAME special register specifies
a VARCHAR(255) value that contains the value of the application name
from the client information specified for
the current
connection.
In ODBC, SQLSetConnectAttr() can be used to set
the ODBC_ATTR_INFO_APPLNAME connection attribute.
Select the departments that are allowed to use the application being used in this connection.
SELECT DEPT FROM DEPT_APPL_MAP WHERE APPL_NAME = CURRENT CLIENT_APPLNAME