ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-52
INDEX Statements
Example
ADD INDEX \sales.$db1.region1.ix AS db.o.ix
REMOVE INDEX
The REMOVE INDEX statement deletes an existing mapping entry for the specified
index. The underlying NonStop SQL/MP index is unaffected. To execute REMOVE
INDEX, you must be a privileged user.
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.
FROM database-name
specifies a customized NonStop ODBC Server database. If you omit
database-name, the default is the default database defined in the current profile.
If the current profile does not specify a default database, then database defaults
to MASTER unless a USE DATABASE statement is in effect.
Considerations – REMOVE INDEX
The REMOVE INDEX statement:
•
Deletes the mapping entry in ZNUOBJ for nssql-filename
•
Deletes the mapping entry in ZNUIX associated with nssql-filename
•
Generates an error if you are not a privileged user
Example
REMOVE INDEX \sales.$db1.region1.ix UPDATE_SYSTEM_CONFIG
REMOVE INDEX nssql-filename [ FROM database-name ]