Answer / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Answer / jagan

select top 100 from tableName;

Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

what is static sql? what is dynamic sql? Give me details

3 Answers  

---

what is load and unload in db2

1 Answers   IBM,

---

What is explain in db2?

0 Answers  

---

What do you mean by commit and rollback?

0 Answers  

---

How do you retrieve the data from a nullable column?

2 Answers  

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

Define db2.

0 Answers  

---

What are packages in db2?

0 Answers  

---

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 Answers  

---

What is cloudant database?

0 Answers  

---