Answer / adarshag

SELECT Name
FROM S-Tabl
WHERE Status IS NULL;

Answer / shobha

by using null indicator

What is image copy in db2?

0 Answers  

---

Explain about rct in db2?

0 Answers  

---

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers  

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---

What is coalesce in db2?

0 Answers  

---

What is concurrency in db2?

1 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

Mention the definition of cobol in varchar field.

0 Answers  

---

i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

what is the role of the cursor in db2?

0 Answers  

---