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 |
How to resolve deadlock issue
Which command is used to remove all rows from a table?
Which component is used to execute the sql statements?
What is check constraint in db2?
Can you access the DB2 Directory table using SQL?
how to copy the host variables from ps file into cobol program other than include statement
What is difference between isnull and coalesce?
Mention the location where the output received from explain statement is stored.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How to select the duplicate rows from a table?
What is buffer pool and list some of them?
What is reorg in DB2