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
Which command is used to remove all rows from a table?
Why do we need reorg in db2?
Give a brief description of db2 isolation levels?
What is a db2 cursor?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is view db2?
Define db2 and its databases?
What is load replace in db2?
What is runstats db2?
How connect db2 database to datastage?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How do I start db2 in windows?
How is the value function used?
What os does db2 run on?
What are the different types of base tables?
