WLM_SET_CLIENT_INFO procedure
The WLM_SET_CLIENT_INFO procedure sets values for the SQL client special registers.
Authorization: None required.
The schema is SYSPROC.
- client-userid
- A character or graphic string expression containing the value to set for the CURRENT CLIENT_USERID special register for the current connection.
- client-wrkstnname
- A character or graphic string expression containing the value to set for the CURRENT CLIENT_WRKSTNNAME special register for the current connection.
- client-applname
- A character or graphic string expression containing the value to set for the CURRENT CLIENT_APPLNAME special register for the current connection.
- client-acctng
- A character or graphic string expression containing the value to set for the CURRENT CLIENT_ACCTNG special register for the current connection.
- client-programid
- A character or graphic string expression containing the value to set for the CURRENT CLIENT_PROGRAMID special register for the current connection.
- verbose
- A character or graphic string expression that indicates whether the informational, severity 10
message SQL799C should be sent to the joblog when this procedure is called. The message lists the
changed client special registers and their new values.
- NO
- SQL799C will not be sent to the joblog when this procedure is called.
- YES
- SQL799C will be sent to the joblog when this procedure is called. This is the default.
Example
- Change the values of the CURRENT CLIENT_USERID and CURRENT CLIENT_PROGRAMID special registers
for the current
connection.
CALL SYSPROC.WLM_SET_CLIENT_INFO(CLIENT_USERID => 'PGM1USER', CLIENT_PROGRAMID => 'PGM1');