Answer / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Answer / jagan

select top 100 from tableName;

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---

What is CHECK PENDING ?

5 Answers  

---

how to take the back up of the DB2 table.

7 Answers  

---

Define declaration generator (dclgen).

0 Answers  

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

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

1 Answers   TCS,

---

Define db2 and its databases?

0 Answers  

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

---