ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-6
Locating an Object Using the NonStop SQL/MP
Object Name
A row is displayed listing the column N_OBJNAME, which contains the
NonStop SQL/MP name of the table.
For details about the mapping table ZNUOBJ, see ZNUOBJ (For Logical Object
Names Mapping) on page 8-51.
Locating an Object Using the NonStop SQL/MP Object Name
Sometimes you will know the NonStop SQL/MP name of an object but not the
corresponding ODBC/SQL Server name. For example, you must have the ODBC/SQL
Server name of a table if the following occurs:
•
You create the table in NonStop SQL/MP, refresh the mapping tables, and then
need to access the table using the NonStop ODBC Server.
•
You customize a NonStop SQL/MP catalog, a table name is mapped, but you
cannot locate the table using the NonStop ODBC Server.
You can determine the ODBC/SQL Server name by accessing the mapping table
ZNUOBJ, which is in the same subvolume as your customized catalog.
For example, suppose you know the following information about a table:
•
Your database name is TEST_VOL2_PERSNL.
•
The owner of the database is ADMIN_JANET.
•
The NonStop SQL/MP name of the table is
\TEST.$VOL13.ALLEMPS.EMPLOYEE.
By using the NonStop ODBC Server, you can determine the ODBC/SQL Server owner
name and table name by executing the following statement.
SELECT t_uname, t_objname
FROM test_vol2_persnl.admin_janet.znuobj
WHERE n_objname = "\TEST.$VOL13.ALLEMPS.EMPLOYEE"
A row is returned listing the columns T_UNAME and T_OBJNAME, which contain the
ODBC/SQL Server owner name and table name.
For details about the mapping table ZNUOBJ, see ZNUOBJ (For Logical Object
Names Mapping) on page 8-51.
Note. You must enter the entire file name, including the node, volume, and subvolume, and
the name must appear in uppercase letters.