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

When do you use the IMAGECOPY?

4 Answers  


What is alias in db2?

0 Answers  


What are foreign keys?

1 Answers  


What is a base table?

2 Answers  


What is database alias db2?

0 Answers  






can we drop column from a table

7 Answers   INDUS,


Explain the function done by data manager?

0 Answers  


Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,


How does one remove entries from the SCT02 table?

1 Answers  


Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


why we create view.

5 Answers  


Categories