Answer / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Answer / jagan

select top 100 from tableName;

Explain about dbrm.

0 Answers  

---

What are some SQL aggregates and other built-in functions?

2 Answers  

---

What is reorg?

0 Answers  

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

How to get the ddl of a table in db2?

0 Answers  

---

---

Where is the output of EXPLAIN stored?

2 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

explain about index with examples

2 Answers   Syntel,

---

why should we bind the DB2 program . What if we did not BIND a BD2 program ??

9 Answers   Infosys, TCS, Xansa,

---

What is reorg and runstats in db2?

0 Answers  

---

Which transaction use a command thread ?

1 Answers  

---