In how many ways we can create a logical file?`

Answers were Sorted based on User's Feedback



In how many ways we can create a logical file?`..

Answer / rush2hemant

1) DDS Using PFILE
2) CRTLF

Note:- OPNQRY is a temp access path and not a LF.

Is This Answer Correct ?    4 Yes 0 No

In how many ways we can create a logical file?`..

Answer / rush2hemant

1) CRTLF
2) DDS using PFILE

Note:- OPNQRY is a temp access path and not a LF.

Is This Answer Correct ?    2 Yes 0 No

In how many ways we can create a logical file?`..

Answer / karu

mr.venkat prasad sir  may i know how you create LF by using OPNQRYF

Is This Answer Correct ?    1 Yes 0 No

In how many ways we can create a logical file?`..

Answer / venkat prasad

1.CRTLF
2.OPNQRYF
3.EMBEDED SQL

Is This Answer Correct ?    2 Yes 3 No

In how many ways we can create a logical file?`..

Answer / ankush

2 way
1) simple join
2) multijoin

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More DB400 Interview Questions

How to read a PF in reverse(from last rec to first) using CL?

3 Answers   HCL,


CRTDTA AND CRTARA should be used along with?

2 Answers  


what is open data base command

1 Answers   Active Brains, Cognizant, CSC, CTS,


What is the use of member in pf?

0 Answers  


Hi, Please give the answer to this question? I have Phisical file with 100 records,there is no any duplicate records in this pf.Based on this pf one Logical file i have used.But this lf is viewing only 80 records only of that pf?What is the reason for this?Please give me answer?

4 Answers   IBM,






Can anybody tell why Journalling is compulsary before Commitment Control?

2 Answers  


what is multiple member pf

1 Answers   Active Brains,


what is exception and how many types of exception

1 Answers   Active Brains,


What is the purpose of the chain and setll and setgt?

0 Answers  


When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

0 Answers  


Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

0 Answers  


Define interactive jobs and batch jobs

6 Answers  


Categories