What is correlation names?
Answer / s
Correlation names are used in the SQL statment as an
alternate name to a qualified table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Can we insert update delete in view?
is it compulsory commitment control in journal?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
How can we define a table? How can we apply SEARCH ALL on it ?
what is REORG? what is the use?
Q3. How will you fetch duplicate values from a DB2 table?
how to resolve -811 error. give clear explination
What is difference between *omit and *nopass?
How many clustering indexes can be defined for a table?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
How do you pull up a query which was previously saved in qmf?
How do you insert a record with a nullable column?