ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-10
Changing ODBC/SQL Server Object Names
Changing ODBC/SQL Server Object Names
The recommended method for changing an ODBC/SQL Server object name is to
execute a REMOVE TABLE, REMOVE INDEX, or REMOVE VIEW statement for the
name you want to change, then execute an ADD TABLE, ADD INDEX, or ADD VIEW
statement for the new name. You can execute these mapping table statements from
either the NOSCOM command interpreter or the NonStop ODBC Server Configuration
Manager graphical user interface tool.
You can also change the ODBC/SQL Server object names by using INSERT and
DELETE statements on ZNUOBJ. In this scenario, you cannot use UPDATE
statements because the column you need to update, T_OBJNAME, is part of the
primary key (T_UNAME and T_OBJNAME). Although using INSERT and DELETE is
not the recommended method, it is shown in Example 7-3
for illustrative purposes.
Example 7-2. ODBC/SQL Server Object Names Generated by USERCAT INSTALL
>>select t_objname, n_objname
+>from \tess.$noss.persnl.znuobj
+>order by n_objname;
T_OBJNAME N_OBJNAME
------------------------------ ----------------------------------
BASETABS \TESS.$NOSS.PERSNL.BASETABS
COLUMNS \TESS.$NOSS.PERSNL.COLUMNS
COMMENTS \TESS.$NOSS.PERSNL.COMMENTS
CONSTRNT \TESS.$NOSS.PERSNL.CONSTRNT
DEPT \TESS.$NOSS.PERSNL.DEPT
DEPTBAK \TESS.$NOSS.PERSNL.DEPTBAK
EMPLBAK \TESS.$NOSS.PERSNL.EMPLBAK
EMPLOYEE \TESS.$NOSS.PERSNL.EMPLOYEE
FILES \TESS.$NOSS.PERSNL.FILES
INDEXES \TESS.$NOSS.PERSNL.INDEXES
JOB \TESS.$NOSS.PERSNL.JOB
JOBBAK \TESS.$NOSS.PERSNL.JOBBAK
KEYS \TESS.$NOSS.PERSNL.KEYS
PARTNS \TESS.$NOSS.PERSNL.PARTNS
PROGRAMS \TESS.$NOSS.PERSNL.PROGRAMS
TABLES \TESS.$NOSS.PERSNL.TABLES
TRANSIDS \TESS.$NOSS.PERSNL.TRANSIDS
USAGES \TESS.$NOSS.PERSNL.USAGES
VERSIONS \TESS.$NOSS.PERSNL.VERSIONS
VIEWS \TESS.$NOSS.PERSNL.VIEWS
ZNUIX \TESS.$NOSS.PERSNL.ZNUIX
ZNUOBJ \TESS.$NOSS.PERSNL.ZNUOBJ
SYSCOLUMNS \TESS.$NOSS.PERSNL.ZVUCOL
SYSTYPES \TESS.$NOSS.PERSNL.ZVUDT
SYSINDEXES \TESS.$NOSS.PERSNL.ZVUIX
SYSOBJECTS \TESS.$NOSS.PERSNL.ZVUOBJ
SYSPROTECTS \TESS.$NOSS.PERSNL.ZVUPROT
SYSUSERS \TESS.$NOSS.PERSNL.ZVUUS
T_EMPLOYEE567490 \TESS.$NOSS.PERSNX.EMPLOYEE
T1 \TESS.$NOSS.PERSNX.T1
T_EMPLOYEE724838 \TESS.$NOSS.PERSNY.EMPLOYEE
T_T1809120 \TESS.$NOSS.PERSNY.T1
T_EMPLOYEE891245 \TESS.$NOSS.PERSNZ.EMPLOYEE
T_T1961851 \TESS.$NOSS.PERSNZ.T1
--- 34 row(s) selected.