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

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

How to rename a table in DB2 ?

0 Answers   MCN Solutions,

Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA

8 Answers   CGI, Wipro,

What is the use of reorg in db2?

0 Answers  

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

How to define the data items to receive the fetch items for the SQL?

2 Answers  

How can you compare table column after update and before update?

5 Answers   Satyam,

Mention the various locks that are available in db2.

0 Answers  

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

What is database alias db2?

0 Answers  

What is concurrency in db2?

1 Answers  

What is blu acceleration in db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories