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 reorg?
How many buffer pools are available in db2?
what is the name of the default db2 catalog database?
What is the role of schema in the db2 database?
What is meant by isolation level?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What is lock contention?
How connect db2 database to datastage?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
What is a db2 collection?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?