Answer / adarshag

SELECT Name
FROM S-Tabl
WHERE Status IS NULL;

Answer / shobha

by using null indicator

How can deadlocks be resolved?

0 Answers  

---

What is a LIKE table and how is it created?

2 Answers  

---

What is a lock?

1 Answers  

---

Define predicate?

0 Answers  

---

what is rebinding ?

1 Answers   IBM,

---

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 Answers  

---

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,

---

What is a bind card?

0 Answers  

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---