Interested to Buy Any Domain ? << Click Here >> for more details...
What is a synonym? How is it used?
- 2 Answers
- 5703 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 |
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What can the SET option of the Repair Utility accomplish?
Can we install 2 different versions of Db2 on same mainframe?
how can u understand the end of the table ?
What is the use of predicate?
What is the function of logging in the db2 database?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
Why do we bind in db2?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
What is query_cache_limit?
how do u update the faltfile into db2 table ?
What does an outer join do?
COBOL 
