User settable process information

The set command includes options that allow you to assign each client an individual name, host name, and application name. This is useful for differentiating among clients in a system where many clients connect to Adaptive Server using the same name, host name, or application name. The partial syntax for the set command is:

set [clientname client_name | clienthostname host_name | clientapplname application_name]

Where client_name is the name you are assigning the client, host_name is the name of the host from which the client is connecting, and application_name is the application that is connecting to Adaptive Server. These parameters are stored in the clientname, clienthostname, and clientapplname columns of the sysprocesses table.

For more information, see Chapter 10, “Managing Adaptive Server Logins and Database Users” in the System Administration Guide.