ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-12
Changing ODBC/SQL Server Object Names
Enter the name in uppercase letters. When you assign the new ODBC/SQL Server
object names, follow these guidelines:
•
Check that the name is a valid ODBC/SQL Server identifier.
•
Check that the name is unique for the database and owner.
•
Check that you change only the ODBC/SQL Server object name (T_OBJNAME).
Example 7-4. Changing the ODBC/SQL Server Object Names in ZNUOBJ
>>delete from persnl.znuobj where
+>t_objname like '%T_EMP%' or
+>t_objname like '%T_T1%';
--- 5 row(s) deleted.
>>
>>insert into persnl.znuobj (*) values
+>(44812, 'T_EMPL178234', 'SQL_LYNNR', 'U', 35906,
+>'\TESS.$NOSS.PERSNX.EMPLOYEE', 'TA', 'N', 0);
--- 1 row(s) inserted.
>>
>>insert into persnl.znuobj (*) values
+>(44812, 'T_EMPL246802', 'SQL_LYNNR', 'U', 55532,
+>'\TESS.$NOSS.PERSNY.EMPLOYEE', 'TA', 'N', 0);
--- 1 row(s) inserted.
>>
>>insert into persnl.znuobj (*) values
+>(44812, 'T_EMPL435790', 'SQL_LYNNR', 'U', 56069,
+>'\TESS.$NOSS.PERSNZ.EMPLOYEE', 'TA', 'N', 0);
--- 1 row(s) inserted.
>>
>>insert into persnl.znuobj (*) values
+>(44812, 'T1_Y', 'SQL_LYNNR', 'U', 46978,
+>'\TESS.$NOSS.PERSNY.T1', 'TA', 'N', 0);
--- 1 row(s) inserted.
>>
>>insert into persnl.znuobj (*) values
+>(44812, 'T1_Z', 'SQL_LYNNR', 'U', 23895,
+>'\TESS.$NOSS.PERSNZ.T1', 'TA', 'N', 0);
--- 1 row(s) inserted.
>>
>>select t_objname, n_objname from persnl.znuobj where
+>n_objname like '%EMPLOYEE%'
+>order by n_objname;
T_OBJNAME N_OBJNAME
------------------------------ ----------------------------------
EMPLOYEE \TESS.$NOSS.PERSNL.EMPLOYEE
T_EMPL178234 \TESS.$NOSS.PERSNX.EMPLOYEE
T_EMPL246802 \TESS.$NOSS.PERSNY.EMPLOYEE
T_EMPL435790 \TESS.$NOSS.PERSNZ.EMPLOYEE
--- 4 row(s) selected.>>
>>select t_objname, n_objname from persnl.znuobj where
+>n_objname like '%T1%' order by n_objname;
T_OBJNAME N_OBJNAME
------------------------------ ----------------------------------
T1 \TESS.$NOSS.PERSNX.T1
T1_Y \TESS.$NOSS.PERSNY.T1
T1_Z \TESS.$NOSS.PERSNZ.T1
--- 3 row(s) selected.