Answer / sabahat khan

50 4K size Buffer Pool BP01 to BP49
10 8K size Buffer Pool 8KBP0 to 8KBP9
10 16K size Buffer Pool 16KBP0 to 16KBP9
10 32K size Buffer Pool 32KBP0 to 32KBP9

Answer / sunil1405

4 Buffer pools. BP0,BP1,BP2

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  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

---

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,

---

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

What does the sqlcode of -818 pertain to?

3 Answers  

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

What is correlated subquery?

1 Answers  

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---