i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

How does coalesce work?

0 Answers  

---

What is dclgen (declaration generator)?

0 Answers  

---

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  

---

What is meant by dclgen?

0 Answers  

---

wht is d/f between union and joins ?

2 Answers  

---

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

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 db2?

0 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

---