i have one physical file which is having two logical files. logical a have uni

i have one physical file which is having two logical files.
logical a have unique keyword and logical b doesnt have a
unique keyword. can i give duplicate values while updating
through physical file. if no why?

Question Posted / avinash

4 Answers
12559 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have one physical file which is having two logical files. logical a have unique keyword and logi..

Answer / syam

You cannot update Physical file or Logical File.
duplicate key

Is This Answer Correct ?

15 Yes

1 No

i have one physical file which is having two logical files. logical a have unique keyword and logi..

Answer / rajesh

While updating the Physical file, it looks for constraints
on all the all logicals defined over it.

Is This Answer Correct ?

14 Yes

1 No

i have one physical file which is having two logical files. logical a have unique keyword and logi..

Answer / sumit gupta

Whenever you update physical file, then it checks for all
file level keyword that specifies on logical file if any.
If no logical then simple update will perform.
In this, before updating your physical file temporary
program will get the UNIQUE specified as file level keyword
on 1 logical file.
And thus it through error, Duplicate key error in another
database member

Is This Answer Correct ?

1 Yes

0 No

i have one physical file which is having two logical files. logical a have unique keyword and logi..

Answer / ankur

no u can not give duplicate value while updating through
physical file. Because logical file based on physical file
and having accesspath that is base on physical file
accesspath.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer

More IBM AS400 AllOther Interview Questions

how many files can be defined in f specs?

2 Answers IBM,

How to see all members of a file?

1 Answers

What is an ICF file?

1 Answers

Dear All, I have one confusion related to my platform. I am working with Wipro from last two year however still I am looking for AS400 platform kindly show me the way out of it. And please share with me the hardware knowledge that how I grow myself in hardware (AS/400) also.

1 Answers Wipro,

what are the basic features of seu?

0 Answers IBM,

Describe the function of SETLL operation in RPG language?

1 Answers

How do you check object lock

0 Answers

what is jurnal?what is the use of theis?what is difference between commitment control and jurnaling?

2 Answers

what do we can do with the embedded sql statements?

0 Answers IBM,

what is the difference between *like and *namvar ?