ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-105
TABLE Statements
ADD TABLE
The ADD TABLE statement makes a NonStop SQL/MP base table visible to a
NOSCOM user. No REFRESH of the entire database is necessary.
To execute ADD TABLE, you must be a privileged user. However, the NonStop ODBC
Server does not verify privileges on the underlying NonStop SQL/MP table.
nssql-filename
is a Guardian file name 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.
AS logical-objectname
is the logical name you specify for the table. It can be in any of the following
formats:
objectname
logical-user-name.objectname
database-name.logical-user-name.objectname
database-name..objectname
The value you specify for database-name must be a customized NonStop ODBC
Server database.
The NonStop ODBC Server fully qualifies logical-objectname before
performing the statement. Any optional values you omit are determined by the user
profile of the current process.
Considerations – ADD TABLE
The ADD TABLE statement:
•
Creates a new entry in ZNUOBJ for the specified NonStop SQL/MP base table
•
Generates an error if file-name is already mapped in the appropriate object file
•
Generates an error if nssql-filename is not a valid NonStop SQL/MP table
ADD TABLE nssql-filename [ AS logical-objectname ]