Hi Everyone...
Under the Logical files, when am working on multiple rec
format logical file,

I have joined two pf's using the multiple record format
logical file concept, but when i run queried the LF only the
first mentioned pf records are reflecting and I am not able
to see any of the field records specified under the second pf.
Kindly let me know whats the reason behind this.

Below is the str of LF.,

R rec PFILE(LOGICAA)
CUSTNO
CUSTNAME
BILL
K CUSTNO
R rec1 PFILE(LOGICAA1)
CUSTNO
ADD
K CUSTNO .....


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What does runstats do in db2?

0 Answers  


how to unload different table data into different gdg files/ vsam files.

3 Answers  


What are the contents of a DCLGEN?

4 Answers   MetLife,


What is a bind in db2?

0 Answers  


What db2 400?

0 Answers  






Can we able to find all the Table names under a Particular Plan?

1 Answers   CTS,


Where could you look if you had a question about whether a column has been defined as an index?

2 Answers  


what is a trigger and types of triggers

3 Answers   HSBC,


quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  


What is dbrm? What it contains?

0 Answers  


What is Skeleton cursor table (SKCT)?

2 Answers  


What are the three DB2 date and time data types and their associated functions?

1 Answers  


Categories