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
How to get the ddl of a table in db2?
What are foreign keys in db2?
Why select is not preferred in embedded sql programs?
What is db2 catalog database?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the physical storage length of the data types date, time, and timestamp?
What is the role of the data page in the db2 database?
What is sqlca?
How to find schema of a table in db2?
is it compulsory commitment control in journal?
What are the various data types available in db2?
What is release/acquire in bind?
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 db2 400?
How can you classify the locks in db2?