Answer / basavaraj

Using bmc utlity we can find out

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What's The Percentage Free Space ?

0 Answers   IBM,

---

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 are the functions in DB2?

3 Answers   Satyam,

---

What types of tables are there in the db2 database?

0 Answers  

---

---

What can the SET option of the Repair Utility accomplish?

1 Answers  

---

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

0 Answers  

---

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---

How will you return the number of records in table?

0 Answers  

---

What does DSNDB07 database do?

2 Answers  

---

What is copy book?

1 Answers   Thomson Reuters,

---