Answer / sadiq afroze

EXPLAIN is used to display the access path as determined by
the optimizer for a SQL statement. It can be used in SPUFI
(for single SQL statement) or in BIND step (for embedded
SQL). The results of EXPLAIN is stored in U.PLAN_TABLE
where U is the authorization id of the user

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

Explain the contents that are a part of dclgen.

0 Answers  

---

What is the difference between nvl and coalesce?

0 Answers  

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  

---

What is a composite index and how does it differ from a multiple index?

1 Answers  

---

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

3 Answers   Cap Gemini, RBS,

---

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,

---

What is the size of a data page?

2 Answers   IBM,

---

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,

---

What is coalesce in db2?

0 Answers  

---

What is the cobol picture clause of the db2 data types date, time, timestamp?

0 Answers  

---