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 are the bind parameters ibm db2?
How do I delete a table in db2?
what are bind concepts in db2 cobol?
What are foreign keys in db2?
What is an instance database?
What is bufferpool in db2?
Mention data types used in db2 ?
What is image copy in db2?
What is explain plan in db2?
Describe major components of db2?
How to find the number of rows in db2 tables?
Explain the contents that are a part of dclgen.
what is a corelated subquerry?
Can we insert update delete in view?
What is catalog database in db2?
