Answer Posted / sree

SELECT * FROM TABLENAME ORDER BY PRIMARYCOLUMNNAME DESC
FETCH FIRST 5 ROWS ONLY ;

THIS ANSWER IS VALID ONLY IF THERE IS A PRIMARY KEY
COLUMN,OTHERWISE IT WONT WORK

IF THERE IS NO PRIMARY KEY COLUMN IN GIVEN TABLE ,I DON'T
KNOW THE ANSWER

FOR FETCHING FIRST 5 ROWS

SELECT * FROM TABLENAME FETCH FIRST 5 ROWS ONLY;

What is a bind card?

1214

---

What is ibm db2 database?

998

---

List down the data types in the db2 database.

1112

---

What is copy pending status in db2?

1117

---

is it compulsory commitment control in journal?

2474

---

What is scrollable cursor in db2?

1050

---

What is dclgen (declaration generator)?

1052

---

What is the use of db2?

1048

---

Why db2 is called db2?

1030

---

What is the role of schema in the db2 database?

1267

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2358

---

Mention the location where the output received from explain statement is stored.

1120

---

What are packages in db2?

1019

---

How do we specify index to include or not during bind process.

2124

---

What is release/acquire in bind?

1102

---