How do you define a correlated name?

Question Posted / guest

1 Answers
4004 Views
I also Faced
E-Mail Answers

How do you define a correlated name?..

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

is it compulsory commitment control in journal?

0 Answers TCS,

define clustering index.

0 Answers

wht displays the number of times a query modified ?

2 Answers TCS,

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers CTS,

What are host variables in db2?

0 Answers

What is a Cartesian product?

2 Answers

How can you quickly find out the # of rows updated after an update statement?

0 Answers

Is db2 a programming language?

0 Answers

How many buffer pools are available in db2?

2 Answers

How does a cursor work?

0 Answers

How can you find out the # of rows updated after an update statement?

0 Answers

How to rename a table in DB2 ?

0 Answers MCN Solutions,

For more DB2 Interview Questions Click Here