Neoview SQL Reference Manual (R2.3)

GET SERVICE Statement
The GET SERVICE statement shows the service that is in effect for queries in the current session
and whether query plans and SQL text are enabled for the service. 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
GET SERVICE
Considerations
Because GET SERVICE is an SQL statement, it requires an SQL terminator.
Examples
• This statement shows that the default service, HP_DEFAULT_SERVICE, is in effect for the
current NCI session:
SQL>get service;
CUR_SERVICE PLAN TEXT
-------------------------------------------------- ----------- -----------
HP_DEFAULT_SERVICE 0 0
--- SQL operation complete.
SQL>
By default, the query plan and SQL text are turned off (represented by 0 in the output) for
HP_DEFAULT_SERVICE.
• This GET SERVICE statement shows that SALESQUERIES is the current service for the NCI
session:
SQL>set service salesqueries;
--- SQL operation complete.
SQL>get service;
CUR_SERVICE PLAN TEXT
-------------------------------------------------- ----------- -----------
SALESQUERIES 1 1
--- SQL operation complete.
SQL>
The query plan and SQL text are turned on (represented by 1 in the output) for the
SALESQUERIES service.
GET SERVICE Statement 117