How do you define a correlated name?

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

What is the use of commit in db2?

628


List out the buffer pools in db2

624


How would the varchar column remarks defined?

631


Define check constraint.

642


Mention the definition of cobol in varchar field.

684






How to test SQL -911 error while developing COB-DB2 program

6705


Give a brief description of db2 isolation levels?

599


How to execute stored procedure in db2 command editor?

526


What is rebind in db2?

572


How to check last update on table in db2?

624


What is db2 plan table?

613


What is the clustering index in the db2 database?

580


What is cobol db2?

566


What is access path in db2?

560


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2684