What is an alias and how does it differ from a synonym?
Answer Posted / guru
Alias & Synonyms are alternate of table or a view.
ALIAS SYNONYM
1. it is a global object. 1. it is aprivate object.
2. any one can access the 2. but the one who create
alias. the alias can only
access it.
3.when the base table is
droped.Alias is not dropped. 3. when the base table is
droped.SYNONYM is dropped
automatically.
Is This Answer Correct ? | 19 Yes | 3 No |
Post New Answer View All Answers
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is node in db2?
What do you mean by commit and rollback?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
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?
How do I create a view in db2?
Are views updateable?
Define db2 and its databases?
How is a typical db2 batch pgm executed?
Why do we need reorg in db2?
What is runstats utility in db2?
What is an instance database?
What is catalog database in db2?
What is a plan and package in db2?
Can you use max on a char column?