Answer / s

EXPLAIN, determines the access path that will be used by
DB2 to execute that particular SQL statment. The results
are written to the PLAN table.

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

---

What is the difference between spufi and qmf?

0 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---

Explain dclgen.

0 Answers  

---

is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,

---

What is the difference between group by and order by?

2 Answers   IBM, TCS,

---

How do you retrieve the data from a nullable column?

2 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

What do you mean by storage group (stogroup)?

0 Answers  

---

select 100 records from million records ?

2 Answers   Verizon,

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---