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

Describe about Query/400?

1 Answers  


What do you mean by ODP?

1 Answers  


What Is The Difference Between Goto & Exsr?

0 Answers   IBM,


List the steps/commands necessary to accomplish the following: a. Copy data from the file ORDHDR into file ORDHIST b. The file ORDHIST may or may not exist c. If the file ORDHDR does exist, it may or may not contain data d. The file ORDHIST may or may not contain data, if the file does contain data the old data should be erased

1 Answers  


What is FCFO, FIFO, LIFO in Database environment ?

1 Answers  






all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

0 Answers  


CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?

4 Answers  


Define what the operation will do, the purpose of the result field and the purpose of *IN66? HI LO EQ C CALL 'CVTDAT' DTPRM 66

1 Answers  


is there any way to dynamically merge other html scripts into a given html?

0 Answers   IBM,


What is logical file in as400? What are the types of logical file?

1 Answers  


How many primary files allowed in a program?

1 Answers  


what is the difference between udate and the system date?

1 Answers   IBM,


Categories