Interested to Buy Any Domain ? << Click Here >> for more details...
What is an alias?
- 3 Answers
- 6325 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 |
What are the Isolation levels possible ?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
What is a trigger in the db2 database?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
what is db2 restart?
What os does db2 run on?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is bind plan?
Explain in detail about buffer manager and its functionalities?
How can you display the current date & current time ?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
COBOL 
