Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias?
- 3 Answers
- 6308 Views
- I also Faced
- E-Mail Answers
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 |
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
On the create tablespace, what does the CLOSE parameter do?
Explain the use of the WHERE clause?
What is the use of dclgen in db2?
What is ibm db2 used for?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What is runstats db2?
Once you create a view, where would information about the view be stored?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is data manager?
How to find primary key of a table in db2?
is it compulsory commitment control in journal?
COBOL 
