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

What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


What is a system catalog table in db2?

0 Answers  


What is null indicator in db2?

0 Answers  


can you use symbolic parameters in JOB?

5 Answers   IBM,






EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  


Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,


What is DCLGEN ?

2 Answers  


explain about index with examples

2 Answers   Syntel,


Can you Average the Characters ?

3 Answers  


what are the bind parameters?

5 Answers   IBM,


What are the various data types available in db2?

0 Answers  


Categories