ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-106
TABLE Statements
•
Generates an error if the table you specify is not registered in the NonStop
SQL/MP database
•
Generates an error if you are not authorized to modify the system catalog
•
Generates an error if database-name is not the name of a customized NonStop
ODBC Server database
•
Generates an error if logical-object-name is already mapped to a different
Guardian file name
Example
ADD TABLE \persnl.$db1.region1.tblA
AS persnl_db1_region1.dbo.summary_table_A
REMOVE TABLE
The REMOVE TABLE statement removes a mapping entry for the specified NonStop
SQL/MP table. The underlying table is unaffected. To execute REMOVE TABLE, you
must be a privileged user.
nssql-filename
is a Guardian filename that represents the physical location of the NonStop
SQL/MP table. It 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
statement. Any optional values you omit are determined by the user profile of the
current process.
FROM database-name
is an alphanumeric string up to 60 characters in length that specifies the NonStop
ODBC Server customized database from which to remove the NonStop SQL/MP
table.
The default is the current default database for the current user profile.
Considerations – REMOVE TABLE
The REMOVE TABLE statement:
REMOVE TABLE nssql-filename [ FROM database-name ]