How we can't update join logical files?

Answers were Sorted based on User's Feedback



How we can't update join logical files?..

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

How we can't update join logical files?..

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

How we can't update join logical files?..

Answer / sonu

No. We cannot update using Join Logical files.

Is This Answer Correct ?    10 Yes 4 No

How we can't update join logical files?..

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

How we can't update join logical files?..

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

How we can't update join logical files?..

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

How we can't update join logical files?..

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

How we can't update join logical files?..

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

How we can't update join logical files?..

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

How we can't update join logical files?..

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

Post New Answer

More DB400 Interview Questions

I have physical file with 100 records,there is no any duplicate records in this pf.based on this pf one logical file I have used.but this lf is viewing only 80 records only of that pf?what is the reason for this?

0 Answers  


what is exception and how many types of exception

1 Answers   Active Brains,


How to read a pf in reverse(from last record to first) using cl?

0 Answers  


When we use any keyword like FIFO,LIFO, at file level but whenever we check by runqry we couldn't find answer in FIFO,LIFO,FCFO etc so how we check the answer.

2 Answers  


how to update physical file using logucal file with example

1 Answers   Wipro,






what is multiple member pf

1 Answers   Active Brains,


A pf containing 100 records... my query is how to display from 11th record in the pf?

3 Answers  


what is error handling concepts in cl

3 Answers   Active Brains,


When u create a PF and did not fill up Maint parameter, then by default which access path will the system take & why

2 Answers   HCL,


In how many ways we can create a logical file?`

5 Answers  


Is it possible to create a logical file whose Physical file is not in same library?

6 Answers  


There is one string as A B C and wanted to display string as Shri A Shri B Shri C, how we can do this in sql? If we have around 100 values in string like this, each value should be displayed with initials as Shri.

0 Answers  


Categories