Answer / Avneesh Kumar

The B37 ABEND during SPUMF (System Program for Updating Master Files) can occur due to various reasons, such as invalid data input or table inconsistencies. To resolve this issue, you should first identify the cause of the error and correct it. This may involve correcting the data, modifying the program that caused the error, or updating the database structure.

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  

---

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

What will the COMMIT accomplish?

5 Answers  

---

What is a db2 package?

1 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was

5 Answers   IBM,

---

What is reorg in DB2

3 Answers   Virtusa,

---

What is a bind card?

1 Answers  

---

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  

---

What information is used as input to the bind process?

2 Answers  

---