Answer / s

Free space is used by DB2 to maintain data clustering and
variable length rows. FREE PAGE,PCTFREE

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 Answers  

---

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

What are delete-connected tables?

1 Answers  

---

What is lock escalation?

2 Answers  

---

Is db2 relational database?

1 Answers  

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

what is difference between Plan and Package

1 Answers   Syntel,

---

What is db2 and what is the use of db2 optimizer?

1 Answers  

---

What is ibm db2 client?

1 Answers  

---

What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?

4 Answers  

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

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

2 Answers   IBM,

---