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

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers   IBM, TRD,

---

What does db2 stand for?

0 Answers  

---

What is load utility in db2?

0 Answers  

---

What is normalization and what are the five normal forms?

1 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  

---

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

0 Answers  

---

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?

3 Answers  

---

Can a Db2 table data be retrived through JCL?

4 Answers  

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  

---

What is schema in db2?

0 Answers  

---