Answer Posted / 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 View All Answers
What are the 2 sqlcodes that are returned?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is the difference between drop table and delete table?
What is the function of logging in the db2 database?
How to check last update on table in db2?
What is lock escalation in db2?
What is the role of data manager in the db2 database?
How can we read records for specific member in CL? AND rpg?
What is innodb buffer pool?
Where do you specify them?
What is a storage group (stogroup)?
How do you find the maximum value in a column in db2?
Is the primary key a clustered index?
How and when does the db2 enforces the unique key?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?