Answer / deepu

AS400 FREQUENTLY ASKED QUESTONS

How to select highest score of each subject or how to select highest income of every month?

0 Answers  

---

Need a sql query: retrive all duplicate records in table

3 Answers  

---

How can we read a particular record from the database file which is not having DDS (Flat File). For example, there are 100 records in the flat file. How can we retrive 15th record in RPG/400 program (Without using CL)

6 Answers   CTS, IBM,

---

What is the purpose of FRCDTA keyword?

3 Answers   IBM,

---

1.WHAT IS WRONG WITH THE CODE BELOW? C CUSTNO CHAIN CUSTMAST IF %ERROR can any body find the wrong please? 2.What builtin function will you use to achieve the following functionality? C QTY IFLT *ZERO C QTY MULT-1 QTY ENDIF

5 Answers   CTS,

---

how can an indexed file be used as arrival sequence in RPG?

3 Answers   IBM,

---

1. If there are two programs using same file and 2 users are using the file at the same time and what can be done to allow them both to access? 2. How can remove lock from the file for accessing it by both users?

0 Answers  

---

what is program status data structure?

1 Answers   IBM,

---

what is EXCEPT command in rpg and use

1 Answers   Active Brains,

---

If the last record of a file has been read, and the next operation on that file is a READ operation, what will be the values of the input fields for that file? A. They will be blank and/or zero. B. They will be null. C. They will equal the values of the first record in the file. D. They will equal the values of the last record read.

3 Answers  

---

what is a rpg?

0 Answers   IBM,

---

I know chain keyword retreive records randomly but how chain keyword exactly works internally????

4 Answers  

---