Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mehdee
That is correct, Alias is an alternate name of the table
and it is used so that application programs will always be
right accessing these DB2 tables, for example:
table name alias name
- - - - - - - -
TABLE_A DATA_FOR_MON_0 (current mon)
TABLE_B DATA_FOR_MON_1 previous
TABLE_C DATA_FOR_MON_2
> now at the end of the month we want to purge the 3rd
month data and start fresh to add or load data for the
duration of the new cuurent month, so what DBADM does is
they simply EMPETY the last month DB2 table and reALIAS the
other two as:
table name alias name
- - - - - - - -
TABLE_C DATA_FOR_MON_0 (current mon)
TABLE_A DATA_FOR_MON_1 previous
TABLE_B DATA_FOR_MON_2
So the application programs using alias name will always
be right about which table is for which month.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the maximum length of sqlca?
What is meant by dclgen?
What parameters are used to control the free space in DB2?
What is meant by union and union all?
What is check constraint in db2?
Explain about mirror activator disk mirroring?
What is the syntax for FETCH in DB2 ?
Where do you specify them?
Is ibm db2 free?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What are union and union all?
Explain what are the various isolation levels possible?
Which command is used to remove all rows from a table?
is it compulsory commitment control in journal?
Define predicate?
