Answer / sadiq afroze

The CHECK Utility checks the referential integrity of table
relations and checks the integrity of the indexes by
matching index column values to table column values.

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

where will u check for sqlcode ?

2 Answers   TCS,

---

What is the maximum number of tables that can be stored on a Partitioned Table Space ?

1 Answers   IBM,

---

Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.

3 Answers   IBM,

---

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,

---

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,

---

How many databases are there?

0 Answers  

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

0 Answers  

---

What will the DB2 optimizer do?

2 Answers  

---

if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,

---

What are the two types of logging in the db2 database? Explain them.

0 Answers  

---

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---