Answer / sulthan

OPNQRYF dynamically creates the records required according
to the parameterrs and this process could be slow. While
using logic files , we already have the a record fectching
path and it is faster. so if a program needs to be run
multiple times, use LF's and if once in a while, go for opnqryf.

Answer / kcsyam

Logical Files

how we retrieve records without using key field (ex:name) from Physical File through RPG in as/400?

8 Answers  

---

How do u design a physical file, when you have 2 Unique fields like for eg in A student file student ID and student examination no both are unique

0 Answers  

---

Is it possible to call a subfile using CL. IF yes.. kindly help me out with explanation...?

3 Answers  

---

what are the array operations?

1 Answers   IBM,

---

Why we cannot call a service program? If I add a PEP can i call the service program?

1 Answers   DELL,

---

1.String operatio such as moving the characters to the variables? 2.what are the building functions for check file longs? 3.which of the following methods will make externally describe file fields available to a program? A: A/copy statement that specifies the library file and member of the field reference file source code B: A data structure definition specification that names the file on the EXTNAME keyword C: A data structure definition specification that names the file on the IMPORT keyword? D: A Definition specification for each desired field with the REFFLD keyword

1 Answers   CSC, CTS,

---

Suppose in CL we reach at end of file and again we have to reach from 1 record

3 Answers   TCS,

---

how can we can we the data decimal error?how can we open such file in support

1 Answers  

---

We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?

0 Answers  

---

Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?

0 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,

---

can any body correct the following code? Following a procedure which returns the maximum of two numbers.Correct the following code. P GETMAX B D GETMAX PI D NUM1 35 0 D NUM2 45 0 C IF NUM1 > NUM2 C RETURN NUM1 C ELSE C RETURN NUM2 C ENDIF P GETMAX E

1 Answers  

---