Answer / saravana

select empname,empno from tablename order by empno fetch
first row only;

What is a data page?

1 Answers  

---

What are the bind parameters ibm db2?

0 Answers  

---

Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.

9 Answers   Cap Gemini,

---

What is a subselect? Is it different from a nested select?

1 Answers  

---

Why select is not preferred in embedded sql programs?

0 Answers  

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

How do you find the maximum value in a column in db2?

0 Answers  

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

What is with ur in db2?

0 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,

---

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

---