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 ? | 10 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 |
what is multiple member pf
If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.
how to restrict upon adding the data for field reference file in DB400
how to add a new field to a file without compiling it?
what is dynslt and why we use that command when do we use command
what is open data base command
1 Answers Active Brains, Cognizant, CSC, CTS,
How to add a field to a PF and compile it without loss of data?
wirte a simple program for read file in cl
How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?
what is exception and how many types of exception
What is open data path? And what is the difference between access path and open data path?
How to update physical file using logical file with example?