Answer Posted / swagga refic

The difference between logical and physical file organisation is that in physical file organisation contains data and have only one record format where as logical file organisation is a view of physical file organisation which does not contain any data and may be based on one physical file or more than one physical file.

(N.B) Logical can be non join or join logical file. Performance becomes better if you use the logical file in the program.

i am using non join multiple format my 3 database file is like that pf97 R REC ENAME ETENNO ESTATUS K ENAME pf98 R REC1 ENAME ESAL K ENAME PF99 R REC3 ENAME CRDCARD EID K EID & MY NON JOIN LOGICAL FILE IS ALSO SAME EXCEPT RECORD NAMES BEFORE I TRIED WITH 2 FILES SO ITS SAYS ERROR I.E.(Key field attributes must be same as for previous formats. ) SO I CHANGED KEYFIELD ACCORDING TO PF SO ITS WORKING BUT AFTER ADDING 3 FILES ITS SAYING SAME ERROR . I DONT KNOW I NEW IN AS400 PLLZ HELP ME I HAVE ONE MORE QUE. CANT BE USE DIFFERENT KEYFIELD (NOT ACCORDING TO PF) IN NON JOIN LOGICAL FILE.

1560

---

How to reverse a string using RPG?

1605

---

where will control be passed after the execution of the *pssr subroutine if the factor2 of the endsr is blank ?

1902

---

which of the following operations does not zero the field flda defined as 4,0?

1237

---

What is file information data structure(infds) in as400?

1525

---

when would you prefer logical file than opnqryf?

2562

---

what are the basic features of seu?

1270

---

what is the purpose of overrides?

1828

---

which type of object is used in db2/400?

1102

---

what opcode will be used to test the zone of a character field?

1837

---

define the purpose of the *bcat function?

1643

---

can you display a empty subfile?

1279

---

How to add 99 menu (page down) option in menu creation..

2411

---

what are the different types of variables available in cl?

1896

---

how many levels are there in a physical file?

1860

---