Answer / s

You can use TSO to run a batch program using the TSO
Terminal Monitor Program IKJEFT01 which involes the DSN
command and runs the application program.

What is the meaning of -805 SQL return code?

3 Answers  

---

What is subquery ?

6 Answers  

---

What is the result of open cursor statement?

0 Answers  

---

Explain the contention situations caused by locks?

0 Answers  

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

Is db2 free?

0 Answers  

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  

---

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers   Fidelity,

---

How is the SUBSTR keyword used in sql?

1 Answers  

---

What are leaf pages?

3 Answers  

---

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

---

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  

---