How would you find out the total number of rows in a db2 table?

0 Answers  

---

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  

---

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

---

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

how can we find nth max salary from A table

5 Answers   IBM,

---

What is database manager in db2?

0 Answers  

---

How does DB2 store NULL physically?

2 Answers  

---

What's the maximum number of characters that a tablename can have?

3 Answers  

---

What are the uses of db2 optimizer?

0 Answers  

---

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  

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---