if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,

---

What are data types?

2 Answers  

---

What is deadlock in db2?

0 Answers  

---

max number of columns in a db2 table?

6 Answers  

---

---

What are the 4 environments which can access DB2 ?

2 Answers  

---

What is filter factor?

2 Answers  

---

What is the picture clause of null indicator variable?

0 Answers  

---

How would you print the output of an SQL statement from SPUFI?

2 Answers  

---

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  

---

What do you mean by cursor?

0 Answers  

---

List some fields from sqlca?

0 Answers  

---