Answer / sujata

The DB2 UDB for AS/400 commitment control support provides
a means to process a group of database changes (updates,
inserts, DDL operations, or deletes) as a single unit of
work (transaction). A commit operation guarantees that the
group of operations is completed. A rollback operation
guarantees that the group of operations is backed out. A
commit operation can be issued through several different
interfaces.

How to read data from Nth member of a physical file containing some X number of members in it? "Provided member names are unknown"

4 Answers  

---

There is a excel sheet having details of Old account number and new account number. I need to update these details in my AS400 files. i.e. all the records having old account number should be replaced with new account number. There can be 100 or 200 or 300 PFs...no fix files known. how can we do this?Solution should be performance oriented

3 Answers   Cap Gemini, IBM,

---

What is the OPEN and CLOSE accesspath?

3 Answers   CTS,

---

I have a file .In that file i have 3 fields. Those fields are eno, ename, esal.Keyfield is eno. In that file i have data like this for eno 1,2,3,4,5. Now i need to display 2nd record. That means i need to set the pointer on 2nd record... Then, write the complete rpg program using setll.

1 Answers  

---

1) How to retrieve RRN through RPG ? 2) How to pass parameter by value ? 3) How to trap the error through the RPG/400

10 Answers   IBM, Tech Mahindra,

---

How do you know if a record exists without doing a READ and CHAIN?

6 Answers   IBM,

---

Suppose you have 3 members in a database file. How to read records from all the members without using CL (OVRDBF) i.e. Entire process should be handled exclusively in a RPG program?

7 Answers  

---

what is file identifier wher we can use

1 Answers   IBM,

---

what is edit word and edit code

0 Answers   Cap Gemini,

---

If my rpg program has a date field, what extra care I have to take while compiling that rpg program? If the file is keyed and I have declared the file as well as key list properly in my program. Still am getting an error message like "chain/reade operation is not allowed" what may be the case?

0 Answers  

---

Can an indexed file be accessed in arrival sequence in RPG?

3 Answers  

---

How can you delete a record from a file in RPG without using DELETE oppcode?

2 Answers   UST,

---