Answer / prachi

SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;

This will fetch 1st 100 records

Answer / ankit.:-)

if u want to fetch first 100 go for

select * from tablename fetch only 100 rows;

this will select only 100

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

Explain various types of locks in db2?

0 Answers  

---

How do I delete a table in database?

0 Answers  

---

What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

What are the four lockable units for DB2?

1 Answers  

---

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

1 Answers   IBM,

---

List some fields from sqlca?

0 Answers  

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,

---

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,

---