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
What are host variables in db2?
How can you classify the locks in db2?
Why db2 is called db2?
What is schema in db2?
What is a bind in db2?
What is a db2 collection?
What is the use of commit in db2?
Explain packages.
What is db2 command?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is ibm db2 client?
Differentiate between cs and rr isolation levels? Where do you specify them?
Are view updateable?
Mention the definition of cobol in varchar field.
How do you find the maximum value in a column in db2?