Answer Posted / naresh k

select * from table_name;
The above qurey get duplicate record also because the
database store records like multi-set..
if we want get distinct records then use following query.
select distinct(attribute_name) from table name

What is cursor stability in db2?

1276

---

What is plan in cobol db2?

1060

---

What is the difference between cursor and select statement?

1052

---

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

7441

---

What is the use of with ur in db2?

996

---

On which levels locks can be applied?

1060

---

How and when does the db2 enforces the unique key?

1028

---

What is the syntax for FETCH in DB2 ?

1137

---

What is db2 bind process?

1179

---

What does a deadlock mean in DB2?

1094

---

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

1030

---

What is the difference between spufi and qmf?

1053

---

Is ibm db2 free?

953

---

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1029

---

What are the 2 sqlcodes that are returned?

1128

---