What is a synonym? How is it used?

Answer Posted / s

Synonym is alternate name for a table.

Use of synonyms avoids changes to programs when you migrate
programs from test to production.

create synonym abc for test.abc in test

create synonym abc for prod.abc in production

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for FETCH in DB2 ?

663


When the like statement is used?

627


What is cloudant database?

636


What is netezza database?

561


What is the difference between drop table and delete table?

541






How can you classify the locks in db2?

624


How to find the number of rows in a db2 table?

642


What is bind and rebind in db2?

642


what is utility for parm lib

1867


B37 abend during spufi?

974


How do I add a column to an existing table in db2?

580


Is db2 a database?

566


How does db2 sample database connect?

563


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1887


Explain about rct in db2?

632