Interested to Buy Any Domain ? << Click Here >> for more details...
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 .....
- 0 Answers
- 2371 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
When is the skeleton cursor table created?
Explain how can you do the explain of a dynamic sql statement?
How will you delete duplicate records from a table?
Can you access the DB2 Directory table using SQL?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What are the various isolation levels possible?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is image copy?
When will you chose to run RUNSTATS?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
Is db2 a mainframe?
What DB2 Catalog column tell you when an index needs table reorganized ?
COBOL 
