Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

What is an alias?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is an alias?..

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

What is an alias?..

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

What is an alias?..

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

Post New Answer

More DB2 Interview Questions

What is the difference between dbm cfg and db cfg file in db2 ?

0 Answers   MCN Solutions,

What is sqlcode -922 ?

2 Answers  

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

How do I optimize a query in db2?

0 Answers  

Explain transactions, commits and rollbacks in DB2.

3 Answers  

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

How can you display the current date & current time ?

1 Answers   Cap Gemini,

What is UNION,UNION ALL?

2 Answers  

can you use symbolic parameters in JOB?

5 Answers   IBM,

What is EXPLAIN?

1 Answers  

Explain what a plan is?

3 Answers   CTS,

what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??

4 Answers   Xansa,

For more DB2 Interview Questions Click Here
Categories