What is the difference between a Physical File & a Logical?

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.

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why is as/400 called object oriented machine?

946


Hi,Can any body give the code for the below mentioned quetion.?Im trying to get coding in with easily inderstanding.Plese give me the coding for this? 1.How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should exit if the file is empty,a message should be displayed indicate that there are no records to display. Database file Name=EMPDBF Fields in EMPDBF to be displayed on screen Employee Number- EMPNUM(5,0) Employee Name- EMPNAM(30,A) Employee Address-EMP ADDR(50 A)

1736


what is procedure prototype and procedure interface.

621


how does the runqry show the output?

879


What is the draw back of Procedures? why we are going to Modules?

1228






explain the difference between defining subfile and message-subfile?

1105


what is a join logical file?

754


how many files, printer files you can describe in a rpg?

628


how many files can be defined in f specs?

1394


what is join logical file?

1045


how can we run a batch job?

729


how many levels are there in a physical file?

992


what does check opcode is used?

970


WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

2035


How to reverse the string in rpg

1202