What is an alias?
Answers were Sorted based on User's Feedback
Answer / wellwisher
Alias is an alternate name of the table. It will be droped
when the base table is deleted.
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Answer / ram.g
the last ans is wrong.
alias usually used to hide the location of ds. alias wont
be dropped when ts is dropped. it's avaiable to all.
Is This Answer Correct ? | 1 Yes | 2 No |
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How to check last update on table in db2?
How does one remove entries from the SCT02 table?
What keyword does an SQL SELECT statement use for a string search?
Which catalog table stores referential constraints?
What happens to the PLAN if index used by it is dropped?
What parameters are used to control the free space in DB2?
Give the COBOL definition of a VARCHAR field.
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
i have a db2 variable how do u declare tht into working storage section ?
how to copy the host variables from ps file into cobol program other than include statement
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?