Answer / ankitha

flat file is loaded to table by LOAD utility. BUT
UPDATE with RRN value ,please any body elaborate

Answer / vaneesh khurana

Also there is a option in FADB2 to load to table from flat
file using control card.
go to option 3.7

Answer / sachin borase

Mass insert is possible using the load utility.
but need to write the program for update operation

Answer / selva ganesh s

Flat file can be updated by using RRN value.

can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  

---

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

---

How does DB2 use multiple table indexes?

1 Answers  

---

What are the three types of page locks that can be held?

1 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  

---

Explain the benefits you can get from mainframe connect?

0 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  

---

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

0 Answers  

---

What is a DB2 bind?

3 Answers  

---

What is rebind in db2?

0 Answers  

---

What are the 4 environments which can access DB2 ?

2 Answers  

---