Answer / Abhinav Asgola

Host variables in DB2 are used to pass values between the SQL procedure and the host program. They allow you to assign SQL result values to program variables for further processing.

What is the result of open cursor statement?

1 Answers  

---

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

Explain dclgen.

1 Answers  

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

what is Runstats? Whem will u choose to runatats?

1 Answers   Danske,

---

What is db2 bind?

1 Answers  

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

Mention the definition of cobol in varchar field.

1 Answers  

---

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

1 Answers   CTS,

---

Which is faster delete or truncate?

1 Answers  

---