WLM_SET_CLIENT_INFO procedure

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

Read syntax diagramSkip visual syntax diagramWLM_SET_CLIENT_INFO(CLIENT_USERID => client-useridNULL,CLIENT_WRKSTNNAME => client-wrkstnnameNULL,CLIENT_APPLNAME => client-applnameNULL,CLIENT_ACCTSTR => client-acctngNULL,CLIENT_PROGRAMID => client-programidNULL )

The schema is SYSPROC.

Start of changeIf a parameter is omitted or the NULL value is specified for a parameter, the value of the corresponding special register is not changed.End of change

client-userid
A character or graphic string expression containing the value to set for the CLIENT USERID special register for the current connection.
client-wrkstnname
A character or graphic string expression containing the value to set for the CLIENT WRKSTNNAME special register for the current connection.
client-applname
A character or graphic string expression containing the value to set for the CLIENT APPLNAME special register for the current connection.
client-acctng
A character or graphic string expression containing the value to set for the CLIENT ACCTNG special register for the current connection.
client-programid
A character or graphic string expression containing the value to set for the CLIENT PROGRAMID special register for the current connection.

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