Answer Posted / abirami

Sorry.. Answer 1 given by me is incorrect.

Correct Query is

select disntinct salary from tablename
Order by salary
Fetch first 10 rows only

What is the reason behind not using select * in embedded sql programs?

1047

---

What does db2 plan contain?

961

---

What is dbrm? What it contains?

1112

---

What is the difference between cursor stability and repeatable read isolation levels?

1116

---

What is database reorganization?

1056

---

What is a trigger in the db2 database?

1015

---

Describe major components of db2?

1044

---

How to test SQL -911 error while developing COB-DB2 program

7445

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4215

---

what is the responsibility of the construction superintendent

2081

---

What is check constraint. Explain with example.

1047

---

Is it possible using max on a char column?

1087

---

How do you stop a db2 database in linux?

960

---

What are the various isolation levels possible?

1051

---

What is rebind in db2?

1002

---