Neoview SQL Reference Manual (R2.4 SP2)

GET SERVICE Statement
The GET SERVICE statement returns the WMS service that is in effect for queries in the current
session and provides some information about the service and the client session. Neoview Workload
Management Services (WMS) manages queries associated with a service according to the priority,
threshold limits, and rules of the service. For information about WMS, see the Neoview Workload
Management Services Guide.
Syntax Description of GET SERVICE
GET SERVICE
Considerations for GET SERVICE
• Because GET SERVICE is an SQL statement, it requires an SQL terminator.
• You can run the GET SERVICE statement in NCI in SQL mode, and you can use the GET
SERVICE statement in JDBC and ODBC client applications.
• The GET SERVICE statement returns this information about the service and the client session:
Table 2-7 GET SERVICE Output
DescriptionData TypeColumn Name
Name of the service that is in effect for the sessionVARCHAR(50)
1
CUR_SERVICE
1 indicates that the query execution plans are collected for
display.
0 indicates that no query execution plans are collected for
display.
INTPLAN
1 indicates that the SQL syntax of executing queries is collected
for display.
0 indicates that no SQL syntax is collected for display.
INTTEXT
Name of the schema that is currently in effectVARCHAR(260)
1
CUR_SCHEMA
Name of the connection rule that is in effect for the serviceVARCHAR(50)
1
RULE_NAME
Name of the application that is running in the sessionVARCHAR(50)
1
APPL_NAME
Name of the session if it existsVARCHAR(50)SESSION_NAME
Name of the data source for the sessionVARCHAR(50)
1
DSN_NAME
Name of the client role that is logged in to the sessionVARCHAR(50)ROLE_NAME
1 This column might contain multibyte characters. For guidelines on using multibyte character sets, see the
Neoview Character Sets Administrator's Guide.
Examples of GET SERVICE
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 CUR_SCHEMA RULE_NAME APPL_NAME SESSION_NAME DSN_NAME ROLE_NAME
------------------ ---- ---- ---------- --------- --------- ------------ ---------------------- ---------
HP_DEFAULT_SERVICE 0 0 NEO.USR NCI TDM_Default_DataSource ROLE.MGR
--- 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, and there is no connection rule in effect.
GET SERVICE Statement 133