What is a synonym? How is it used?
- 2 Answers
- 4995 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vinod
A synonym is used to reference a table or view by another
name. The other name can then be written in the application
code pointing to test tables in the development stage and to
production entities when the code is migrated. The synonym
is linked to the AUTHID that created it.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is different three logs in DB2?
List out the three types of page locks that can be held.
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is scrollable cursor in db2?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
What is the difference between group by and order by?
Why do we bind in db2?
How to view db2 table structure?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
How many buffer pools are available in db2?
pls explain the precompilation process of cobol-db2 pgm
COBOL 
