ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-11
Changing ODBC/SQL Server Object Names
To change an ODBC/SQL Server object name using INSERT and DELETE
statements, list all columns of the record containing that name and insert a new record
that is identical except for the ODBC/SQL Server name, which is column
T_OBJNAME.
Example 7-3 shows NonStop SQL/MP statements that list all columns of ZNUOBJ for
the tables mapped in Example 7-1.
Example 7-4 shows NonStop SQL/MP statements that assign new names for the five
tables that were mapped in Example 7-1.
Example 7-3. Listing All Columns of ZNUOBJ
>>select * from $noss.persnl.znuobj
+>where n_objname like '%EMPLOYEE%' or n_objname like '%T1%'
+>order by n_objname;
T_UID T_OBJNAME T_UNAME T_OBJTYPE
------ ------------------------------ ---------------------------- ----------
T_OBJID N_OBJNAME N_OBJTYPE N_ORIGIN
----------- ---------------------------------- --------- --------
N_SESSIONID
--------------------
44812 EMPLOYEE SQL_LYNNR U
37404 \TESS.$NOSS.PERSNL.EMPLOYEE TA N
0
44812 T_EMPLOYEE567490 SQL_LYNNR U
35906 \TESS.$NOSS.PERSNX.EMPLOYEE TA N
0
44812 T1 SQL_LYNNR U
973 \TESS.$NOSS.PERSNX.T1 TA N
0
44812 T_EMPLOYEE724838 SQL_LYNNR U
55532 \TESS.$NOSS.PERSNY.EMPLOYEE TA N
0
44812 T_T1809120 SQL_LYNNR U
46978 \TESS.$NOSS.PERSNY.T1 TA N
0
44812 T_EMPLOYEE891245 SQL_LYNNR U
56069 \TESS.$NOSS.PERSNZ.EMPLOYEE TA N
0
44812 T_T1961851 SQL_LYNNR U
23895 \TESS.$NOSS.PERSNZ.T1 TA N
0
--- 7 row(s) selected.