Neoview Command Interface (NCI) Guide (R2.5)

Considerations
• To run this command in SQL mode, you must first run the CMDOPEN command. This
command does not run in CS mode.
• The command requires an SQL terminator.
• The wild card (*) is not supported for the data source name, and the data source name is
case-sensitive.
• If you do not specify the name of a data source, this command displays the resource
management policies defined for each data source in the NDCS configuration.
• The command displays this information about the resource management policies:
Table C-3 INFO RESOURCE Output
DescriptionColumn
Name of the data sourceDSNAME
Name of the resource management policy attributeATTRNAME
Maximum value for the attributeLIMITVAL
Action taken when the limit is exceeded:
1 = LOG, meaning the query continues executing
2 = STOP, meaning the query stops executing and returns an error message
5 = LOG_WITH_INFO, meaning the query returns a warning message while
executing
In each case, an event message is sent to the event log.
ACTIONID
Not usedSETTABLE
Example
This command displays the resource management policies for the data source DDLTestDS:
SQL>info resource DDLTestDS;
INFO USER Command
The INFO USER command displays the Neoview roles and their NDCS privileges.
Syntax
INFO USER
Considerations
• To run this command in SQL mode, you must first run the CMDOPEN command. This
command does not run in CS mode.
• The command requires an SQL terminator.
• You must have OPERATOR privileges to change the NDCS privileges. Initially, only members
of SUPER.SUPER, SUPER.SERVICES, ROLE.DBA, and ROLE.SECMGR have OPERATOR
privileges.
• The command displays this information about the roles and their NDCS privileges:
174 Connectivity Commands