query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

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

1 Answers  

---

What is a DB2 bind?

3 Answers  

---

What is the use of reorg in db2?

0 Answers  

---

What is runstats db2?

0 Answers  

---

---

What is database alias db2?

0 Answers  

---

What is RUNSTATS?

3 Answers  

---

How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  

---

What does the CHECK Utility do ?

1 Answers  

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

---

how to unload different table data into different gdg files/ vsam files.

3 Answers  

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---