Can anyone answer me when we will go for LF without key fields

Answers were Sorted based on User's Feedback



Can anyone answer me when we will go for LF without key fields..

Answer / bharat

If we want to specify OMIT/SELECT criteria. In that case we may need to create Logical. Not necessary to define key fields in that case.

Is This Answer Correct ?    4 Yes 1 No

Can anyone answer me when we will go for LF without key fields..

Answer / jjj

DYSLT keyword case no need to specify keyed field

Is This Answer Correct ?    3 Yes 0 No

Can anyone answer me when we will go for LF without key fields..

Answer / el banco cumbia

Whenever all the fields in a physical file are not needed. Ex.

A physical file with 100 fields where you need only, let's say, 10 fields.

Create a logical file with the 10 fields from the physical file.

Is This Answer Correct ?    2 Yes 0 No

Can anyone answer me when we will go for LF without key fields..

Answer / surya siram

No, there is no logical file without having the key.

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More IBM AS400 AllOther Interview Questions

Suppose you have 3 members in a database file. How to read records from all the members Without using CL (OVRDBF) i.e. it should be handled exclusively in an RPG program?

6 Answers   IBM,


What is the difference between physical file and logical file?

0 Answers  


during input operation which indicator position is seton if there is a record lock?

1 Answers   IBM,


when would you prefer logical file than opnqryf?

1 Answers   IBM,


which are the string manipulation opcodes?

0 Answers   IBM,






how will you search an array?

0 Answers   IBM,


Which is better LF or OPNQRYF ? When should we use LF and when should we use OPNQRYF ?

5 Answers   HCL,


which indicator is used for read?

0 Answers   IBM,


How to retrieve data from data area?

1 Answers  


write a pgm to read p.f using cl pgm?

2 Answers   Ocwen, SLK, TCS,


how do you know that records are locked?

1 Answers   IBM,


What is the default access path of a file?

0 Answers  


Categories