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

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,


How does DB2 determine what lock-size to use?

2 Answers  


Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,


What is a db2 table?

0 Answers  


what is static sql? what is dynamic sql? Give me details

3 Answers  






which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,


What is blu acceleration in db2?

0 Answers  


What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,


What is a collection?

3 Answers  


What does sqlcabc has?

0 Answers  


How to execute stored procedure in db2 command editor?

0 Answers  


How will you return the number of records in table?

0 Answers  


Categories