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

Answers were Sorted based on User's Feedback



How to know the perticular record in pf with out reading?..

Answer / elia

USING SETLL AND INDICATOR

KEY SETLL RECFMT 51(EQ)

Is This Answer Correct ?    9 Yes 1 No

How to know the perticular record in pf with out reading?..

Answer / svankipu

Elia's answer is correct, but in that you'll come to know
whether the record is found. that's all.
but not what(value) is in the record.

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More DB400 Interview Questions

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

5 Answers  


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

7 Answers   IBM,


What is the batch job?

0 Answers  


I have a PF with out any data but the dependent LF is having data?

1 Answers   HCL,


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  






what is multiple member pf

1 Answers   Active Brains,


WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?

5 Answers   Accenture,


What is the interactive job?

0 Answers  


I had created one physical file tell me command to enter data in to?

1 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  


How many max. Record format a logical file have?

13 Answers   Systime,


1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?

2 Answers   IBM,


Categories