How we can't update join logical files?
Answers were Sorted based on User's Feedback
Answer / suju
we cant update join logical file because,join logical file
is actually sharing the accesspath,so updation is not
possible
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / amit
Join logical file is just a view created using multiple
files. It can't be updated as its not a view similar to
logical file but its a view that represent aggregation of
more than one record format.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kolla ravi
When you talk of Update of a Join logical file it can be
when you mean to use CHGLF and associate differrent PF
Member or modify any attributes.
If you ask about the Join Logical file Data (i.e pointed
by) held within its members then it Cannot be modified.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mithun paul
Join logical file can't be updated, because it is related
with more than one PF as multi format logiacl file.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / nagarama
For the selected fields, it can retrive multiple records
from File2 for the single matching record in File1. So
updating is not logically possible if it has to update the
values in File2 fields (this is an example). So, in the
broad sense sysetm will no allow the updating Join logical
file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sanku
record format does't match any pf file so that's why we
can't updates
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / praba
join lf means joining of files. but the record format
should be same.if v update means v it dont know where to
store the valve(file)
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / jherie
We can't update a joint logical file directly, simply
because it is a logical file. It creates an access path for
multiple physical or logical file.
But if we update the physical file in which joint LF is
pointing to, it will automatically be updated.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / avinash
We can not update the logical file. but when we do changes
in physical then if record format of logical file is same
as physical file then no need to be recreate it again. but
if if phyical file format is different with logical file
format. we have to recreate the LF.
| Is This Answer Correct ? | 1 Yes | 3 No |
how to restrict upon adding the data for field reference file in DB400
How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?
I have a pf, it contains 5 members, how to access particular member data from logical file?
How to update physical file using logical file with example?
pls anyone explain about compile time array,pre run time array run time array
In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.
What is the interactive job? What is the batch job? How to change the batch job to interactive job?
Why we create the Physical File Member?
can any one tell me what is meant by PSSR? Kindly elaborate it...
what is use of self join and which cases you will use this join
what is dynslt and why we use that command when do we use command
what is open data path? and what is the diff b/w access path and open data path?