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 |
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
how to u check the query is executing or not ?where will u check for sqlcode ?
What are host variables in db2?
How connect db2 database to datastage?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is a NULL value? What are the pros and cons of using NULLS?
What happens in bind step in a db2 program?
What is node in db2?
how 2 resolve the -311 sqlcode
Are views updatable ?
What is clone table?