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

Last statement of any rpg program is lr?

0 Answers  


How to know the particular record in pf with out reading?

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  


If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.

2 Answers  


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  






wirte a simple program for read file in cl

2 Answers   Active Brains,


what is multiple member pf

1 Answers   Active Brains,


CRTDTA AND CRTARA should be used along with?

2 Answers  


In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.

0 Answers   Nous,


can any one tell me what is meant by PSSR? Kindly elaborate it...

1 Answers  


How many maximum record format a logical file have?

0 Answers  


Q.1 how to implement the commitment control. 2.how to control commitment control from external program.

7 Answers   IBM,


Categories