How do you define a correlated name?



How do you define a correlated name?..

Answer / 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

More DB2 Interview Questions

Are views updateable?

0 Answers  


what is a corelated subquerry?

0 Answers   IBM,


COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?

1 Answers  


Is db2 a mainframe?

0 Answers  


how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,






What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

3 Answers   Tech Mahindra,


Explain the EXPLAIN statement?

1 Answers  


if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,


Explain about rct.

0 Answers  


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,


Explain about open switch business continuity software?

0 Answers  


Categories