ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-50
INDEX Statements
All processes dependent on scs-processname are also affected. If you omit
scs-processname, the DEFINE statement applies to all SCS processes and their
dependent processes.
UPDATE_SYSTEM_CONFIG
resets the time to update system configuration values to the current time. This
option causes running system components to reread their configuration values on
the next polling cycle.
Example
REMOVE DEFINE =_SQL_CMP_PARALLEL_ON
INDEX Statements
Use the following statements to control whether a NOSCOM user can access an index
on a NonStop SQL/MP base table:
•
ADD INDEX
•
REMOVE INDEX
ADD INDEX
The ADD INDEX statement makes an index on a NonStop SQL/MP base table visible
to a NOSCOM user. No REFRESH of the entire database is necessary.
To execute ADD INDEX, you must be authorized to modify the current user catalog.
However, the NonStop ODBC Server does not verify privileges on the underlying
NonStop SQL/MP index.
nssql-filename
is the name of a Guardian file that specifies the physical location of the index;
nssql-filename can be in any of the following formats:
filename
subvolume.filename
$volume.subvolume.filename
\node.filename
\node.subvolume.filename
\node.$volume.subvolume.filename
The NonStop ODBC Server fully qualifies nssql-filename before performing the
INDEX operation. Any optional values you omit are determined by the user profile
of the current process.
ADD INDEX nssql-filename [ AS logical-objectname ]