Neoview Workload Management Services Guide (R2.4)

INFO SERVICE COMP Command
The INFO SERVICE COMP command returns the names of the compilation rules associated with
the specified service.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is ROLE.DBA or the super ID (super.services or super.super).
Syntax
INFO SERVICE service-name COMP
service-name
is the name of a user-defined service for managing queries. service-name can be a maximum
of 24 characters and must be a unique name in WMS. service-name must exist in the WMS
configuration but cannot be the SYSTEM service. The service name is not case-sensitive and
is always converted to uppercase. WMS supports multibyte characters in the service name.
For guidelines on using multibyte character sets, see the Neoview Character Sets Administrator's
Guide. For output information, see Table A-7.
Considerations
The INFO SERVICE COMP command returns this information:
Table A-7 INFO SERVICE COMP Output
DescriptionData TypeColumn Name
COMPVARCHAR(4)TYPE
Name of the ruleVARCHAR(96)RULE_NAME
Services to which rule is associated.VARCHAR(96)SERVICE_NAME
Examples
This command displays the names of the compilation rules that are associated with
SERVICE1:
INFO SERVICE SERVICE1 COMP;
INFO SERVICE COMP Command 121