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
What is the difference between oracle and db2?
Why do chiropractors use drop table?
Is db2 a mainframe?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
Can we install 2 different versions of Db2 on same mainframe?
Explain the function of data manager.
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What is a db2 package?
Compare a subselect to a join?
Explain the function done by data manager?
What are the three types of page locks that can be held?