Neoview SQL Reference Manual (R2.3)

SET SERVICE Statement
The SET SERVICE statement sets the service for subsequent queries in the current session.
Neoview Workload Management Services (WMS) manages queries associated with a service
according to the priority and threshold limits of the service. For information about WMS, see the
Neoview Workload Management Services Guide.
Syntax
SET SERVICE service-name
service-name
represents a user-defined service for managing queries and can be a maximum of 24 characters.
The service name is not case-sensitive and is always converted to uppercase. If the service
name contains multibyte characters, enclose the service name in double quotes to ensure
correct translation. For guidelines on using multibyte character sets, see the Neoview Character
Sets Administrator's Guide.
Considerations
• Because SET SERVICE is an SQL statement, it requires an SQL terminator.
• You can execute this statement in client applications and in NCI in SQL mode only.
• If the service that you specify does not exist, WMS first looks for a service name that matches
the second part of the client role, such as MGR in ROLE.MGR. If WMS finds a service name
that matches the role, WMS manages the queries in that service. If WMS does not find a
service name that matches the role, WMS manages queries in the default service,
HP_DEFAULT_SERVICE.
Examples
• This statement sets the service to SALESQUERIES for subsequent queries that are executed
in the NCI session:
SQL>set service salesqueries;
--- SQL operation complete.
SQL>select * from sales.orders;
• This statement sets the service to DATALOADING for subsequent queries that are executed
from a script file:
set service dataloading;
set schema persnl;
insert into employee...
SET SERVICE Statement 167