READ_CLIENT_INFO procedure - Read and return client information

The READ_CLIENT_INFO procedure is used to read the client information field from the current session and return a value.

After this procedure runs, any messages that are in the message buffer are discarded. Calls to the PUT, PUT_LINE, or NEW_LINE procedures are ignored, and no error is returned to the sender.

Syntax

Read syntax diagramSkip visual syntax diagramDBMS_APPLICATION_INFO.READ_CLIENT_INFO (client_info)

Procedure parameters

client_info
An expression that returns a value of the client information currently registered in Db2®’s CLIENT_USERID special register. The value returned has a data type of VARCHAR(255).

Authorization

EXECUTE privilege on the DBMS_APPLICATION_INFO module.

Example

The following example shows a procedure call of the CLIENT_INFO value for the current session:

db2 call "DBMS_APPLICATION_INFO.READ_CLIENT_INFO(?)"
   
   Value of output parameters
   --------------------------
   Parameter Name  : CLIENT_INFO
   Parameter Value : <client info value>