Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

Answer / aa

members of physical file contains actual records.. where as
logical file does not contain data, it provides a view of
the data stored in to the physical files. LF contains only
an index to the data stored into the physical files.

Is This Answer Correct ?    191 Yes 21 No

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

Answer / pankaj

PHYSICAL FILE=USED FOR THE MAIN DATA STORAGE BASE
FILE .WHERE DATA ARE STORED .
LOGICAL FILE =NO DATA.ONLY USED FOR THE VIEW THE DATA BASE
FILE.ONLY

Is This Answer Correct ?    68 Yes 14 No

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

Answer / narender

Physical file (PF) contains the data and have only one
record format. Logical file (LF) is a view of the physical
file which does not contain any data may be based on one
physical file or more then one physical file. Logical file
can have more then one record format. 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 ?    48 Yes 8 No

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

Answer / sachin bhuriya

physical file has only one record format and logical file
has one or more record formats

Is This Answer Correct ?    61 Yes 30 No

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

Answer / mallikarjuna raju.m

pf:physical file is an object of *file it contains orginal
data.

lf:logical file is an object of *file will not contain any
data but it holds the path.

Is This Answer Correct ?    27 Yes 12 No

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

Answer / sujanindian

Physical file (PF) contains the data and have only one
record format. Logical file (LF) is a view of the physical
file which does not contain any data may be based on one
physical file or more then one physical file. Logical file
can have more then one record format. Logical can be non
join or join logical file. Performance becomes better if
you use the logical file in the program. We can able to update
in nonjoin logical files.In the case of join logical files
we can't able to update..
types of nonjoin(3) - simple,mulitple physical files,
multiple record format.
types of joins(3)- inner or simple join or nature join or
missing secondaries, leftouterjoin, selfjoin...

Is This Answer Correct ?    18 Yes 7 No

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

Answer / godwin sf

Physical files hold the actual data of a database file. The data is written in arrival sequence.
Physical files are not required to have keyed fields. If a physical file has key fields, this is the order that an RPG program will read the data if the File Spec in the program indicates to read the data in keyed sequence.
Also, with a keyed field, an RPG program can CHAIN, SETLL, READE and READP.
A simple logical file is a different view of the physical file. It is actually a list of pointers to the physical file. Most of the time, a logical file is nothing more than a way of accessing the physical file with different key fields.
With the standard AS/400 supplied tools, it is hard to see the logical file. One way is to use the copy file CPYF to copy the logical file to a new physical file. Then, look at the physical file... it will be in the same order as the logical file.
The AS/400 Database is full featured. Logical files can join multiple files and select and create new fields.

Is This Answer Correct ?    12 Yes 1 No

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

Answer / 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

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

Answer / harish

Physical path: is Nothing But "Exact location"
Ex:-When ever we upload the file on that time we click
browse option and then we have to go where the file is ..
Logical path: is not a exact location
whenever we download the file on that time we have ask save
the file that is the logical path

Is This Answer Correct ?    6 Yes 1 No

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

Answer / pavan krishna

physical file is the actual data stored in the hard
disk.whereas logical file actually doesn't exist.os
asssumes everything as a file.so that the files were
introduced in to data bases.

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More IBM AS400 AllOther Interview Questions

how to insert the data in pf by using cl program

2 Answers   TCS,


PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM Can u plz tell me what the above code do exactly?

2 Answers  


what are the limitations of cl (compare to rpg) ?

1 Answers   IBM,


function of DSPPGMREF?

3 Answers  


what are the various types of device files?

1 Answers   IBM,






Pgm A is invoked through HTTP. It is in Activtion group QILE. Pgm A calls Pgm B and Pgm C. Pgm B is in activation group TEMPACTGRP. Pgm A ends in error. Pgm A is called again. But it gives an error that TEMPACTGRP still exists and files are present in QTEMP. What is the cause and how will u fix?

1 Answers  


how many printer files can be defined in f specs ?

1 Answers   IBM,


Q.How can more than two program be executed in batch mode through SBMJOB in CL PGM but the condition is that program must be executed one by one?Please wtite the senario? 2. IS it possibe more then two programs can be executed in batch mode and HOw it will be executed in CL program ,please write the senario?

6 Answers   IBM,


how can database records be read without lock ?

1 Answers   IBM,


Good morning my experts.Im kuppi.im working as a software trainee on AS/400 technology.i have also joined with ibmi5 team.im trying to convert date with cl/400 coding.I have taken 2 parameters(like date and date types). A. If suppose date type is j,Now i want to convert date to *MDY format B. if date type is M,now i want to convert date to *JUL format C. sending a Program message with the value of converted date.

1 Answers  


can we retrieve dspf source?

2 Answers  


Can be OVRDBF command mentioned after OPNQRYF command in CL?

1 Answers  


Categories