Neoview Workload Management Services Guide (R2.3)

4 Associating Queries With Services
If you do not associate an SQL query with a service, 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 client role, WMS manages the query in that service. If WMS does not find
a service name that matches the client role, WMS manages the query in the default service,
HP_DEFAULT_SERVICE.
If you want to manage query workloads using specific services, you must explicitly associate
the queries with those services. This chapter explains how to associate queries with services by
using these approaches, from lowest to highest precedence:
• “Specifying a Service in a Client Data Source” (page 35)
• “Using the SQLSetConnectAttr() Function to Associate Queries With a Service” (page 37)
• “Using the setServiceName() Method to Associate Queries With a Service” (page 37)
• “Using the SET SERVICE Statement to Associate Queries With a Service” (page 38)
NOTE: The service name is not case-sensitive and can contain multibyte characters. For
guidelines on using multibyte character sets, see the Neoview Character Sets Administrator's Guide.
Specifying a Service in a Client Data Source
You can specify a service for a client data source by using one these techniques:
• “Setting the Service in the ODBC Administrator on a Windows Workstation” (page 35)
• “Setting the Service in the MXODSN File on a Linux or UNIX Workstation” (page 37)
Setting the Service in the ODBC Administrator on a Windows Workstation
On a Windows workstation, you can set the service name for a client data source by using the
ODBC Data Source Administrator. For more information, see the ODBC Client Administrator
Online Help.
Specifying a Service in a Client Data Source 35