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 node in db2?
What is a bind card?
What is query_cache_limit?
List some fields from sqlca?
What is a Foreign Key?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What are the contents of a dclmgen?
Highlight all the advantages that are attached to a package.
What does db2 stand for?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is dbrm? What it contains?
Define data page.
What are the bind parameters ibm db2?
Explain the benefits you can get from mainframe connect?
What is a db2 cursor?
