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
For Read Stability locks are not applicable for phantoms, What is Phantoms?
How to find the number of rows in db2 tables?
What are the three types of page locks that can be held?
Normalization in DB2 – first normal form, second normal form
what is difference between Plan and Package
How do you find the maximum value in a column in db2?
Is db2 a programming language?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
Can I use LOCK TABLE on a view?
can all users have the privilage to use the sql statement select * (dml)?
What are the isolation levels possible ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?