Name some fields from SQLCA.

2 Answers  

---

When do you specify the isolation level?

0 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

---

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,

---

Where are plans stored?

2 Answers  

---

What is the size of a data page?

2 Answers   IBM,

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---

How do you insert a record with a nullable column?

2 Answers  

---

How can you split a table in to exactly half?

7 Answers   HSBC,

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  

---