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 |
one physical file can have how many max of logical files? what is the primary file?
how to add a new field to a file without compiling it?
How to know logical file belongs to which physical file without source?
How to index LF by relative record no (RRN)
Last statement of any rpg program is lr?
When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?
How can we handle errors in RPG?
How many libraries can be there in a library list?
Last statement of any RPG pgm is LR?
How many max. Record format a logical file have?
1. How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name? 2. How to differentiate between the types of join from a Join logical file DDS. Is it possible to have different types of Join Logical files? 3.Any performance difference between Opnqrf and Embedded SQL? When I should prefer Opnqryf and when SQL? 4. I know access path is the path chosen by the program to retrieve data. It can be of keyed access path or arrival sequence. *IMMED- *IMMED description says access path is updated each time record is added or deleted from a member. - What is updating here? *REBLD - The access path is completely rebuilt each time a file member is opened. The access path is maintained until the member is closed, then the access path is deleted. - I am not able to understand this completely. Could anyone explain these more clearly? 5.What is the purpose of using activation group. I know it is a resource allocator, but other than this any other benefits of using an activation group?
what is the purpus of the chain and setll and setgt ?