WLM_SET_CLIENT_INFO procedure

The WLM_SET_CLIENT_INFO procedure sets values for the SQL client special registers.

Authorization: None required.

Read syntax diagramSkip visual syntax diagramWLM_SET_CLIENT_INFO(CLIENT_USERID => client-userid,CLIENT_WRKSTNNAME => client-wrkstnname,CLIENT_APPLNAME => client-applname,CLIENT_ACCTSTR => client-acctng,CLIENT_PROGRAMID => client-programid,VERBOSE => verbose )

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.
If this parameter is omitted, the value of the CURRENT CLIENT_USERID special register is not changed.
client-wrkstnname
A character or graphic string expression containing the value to set for the CURRENT CLIENT_WRKSTNNAME special register for the current connection.
If this parameter is omitted, the value of the CURRENT CLIENT_WRKSTNNAME special register is not changed.
client-applname
A character or graphic string expression containing the value to set for the CURRENT CLIENT_APPLNAME special register for the current connection.
If this parameter is omitted, the value of the CURRENT CLIENT_APPLNAME special register is not changed.
client-acctng
A character or graphic string expression containing the value to set for the CURRENT CLIENT_ACCTNG special register for the current connection.
If this parameter is omitted, the value of the CURRENT CLIENT_ACCTNG special register is not changed.
client-programid
A character or graphic string expression containing the value to set for the CURRENT CLIENT_PROGRAMID special register for the current connection.
If this parameter is omitted, the value of the CURRENT CLIENT_PROGRAMID special register is not changed.
Start of changeverboseEnd of change
Start of changeA 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.
End of change

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');