Answer / rizwan

Indexing is nothing but keying a Physical File.
If you specify a key field for a Physical file,then the
Physical file is referred as Indexed Physical File Or Keyed
Physical File.

Answer / ken

Set key order in PF.

Suppose we add one field in physical file and this physical file is used by several programs.how do we know which program is using that file? What are the impact analysis.

6 Answers  

---

How to declare the more than one file in cl/400.

13 Answers   IBM,

---

list down and describe the sub systems vailable

5 Answers   IBM,

---

wat is curser?? and its types???

4 Answers   HSBC,

---

Mr.Sidc sirfor my question{how to convert date format from one format to another i think in CL/400 its CVTDAT,Please tell in RPG/400 sir not in RPGILE} you have answered using MOVE opcode,can you illustrate me with a small example sir very kind of you.

1 Answers   CTS, IBM, iGate,

---

how to display all the members records in a physical file without using ovrdbf?

9 Answers  

---

What is SFLNXTCHG keyword why it has used and where? Briefly explain with Example.

2 Answers   IBM,

---

1) How to declare a file? 2) How to define a display file? 3) How to monitor error messages in RPG? 4) How to find the attributes for subfiles? and what is the DDS for subfiles?

2 Answers   TCS,

---

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

6 Answers   IBM,

---

How do you proceed in case your active AS400 session has got disconnected suddenly, how can you get back to your session ? Is it possible??

1 Answers  

---

2. Which of the following statement(s) explains the difference(s) between the /INCLUDE and ICOPY directives? a.) No difference, they function the same b.) ACOPY cannot be used as a conditional directive c.) IINCLUDE files cannot contain embedded SQL d.) Nesting /TNCLUDE directives is not allowed

2 Answers   IBM,

---

How to get only unique records from a file which contains duplicate data using CPYF command ? Example : FILEA has duplicate records and FILEB is a UNIQUE defined.... and I want to get the data from FILEA to FILEB by eliminating all the duplicate records...

2 Answers  

---