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

How do you define a correlated name?

Question Posted / s

Answer Posted / s

Correlation name is defined in the FROM clause as a short
name for the table in the query

SELECT * FROM DSND810.EMP X
WHERE X.EMP = '0010'

X is the correlation name for DSND810.EMP

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to rename a table in DB2 ?

1075

How can record locking be achieved in those DB2 versions which do not support it?

1061

How do I import data from excel to db2?

1054

What is the physical storage length of time data type?

1108

If I have a view which is a join of two or more tables, can this view be updateable?

1128

What is clone table?

1029

What is the use of reorg in db2?

1068

How does cobol compile db2 program?

1034

What is cascading rollback?

1191

What is collection in db2 bind?

992

What is the difference between oracle and db2?

1075

What is the use of runstats in db2?

1089

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1053

How to find the maximum value in a column in the db2 database?

1061

How do I import a csv file into db2?

970