Answer / vaneesh khurana

Basically n+1, one for the main programs and n for n sub
programs.

Answer / satheesh

n dbrm members must be used in bind process

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

What is bind in db2?

0 Answers  

---

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

0 Answers  

---

What is the difference between primary key & unique index ?

6 Answers   Patni, Temenos,

---

What is a storage group (stogroup)?

0 Answers  

---

---

How does db2 sample database connect?

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  

---

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation

1 Answers   IBM,

---

What is read-only cursor?

1 Answers  

---