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?

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

which are the figurative constants used in rpg?

0 Answers   IBM,


Define the purpose of Factor 1 the Operation Code and *IN15 in following code HI LO EQ C *YMD Test(D) yymmddDate 15

1 Answers  


What is difference between rename and prefix?

0 Answers  


can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com

0 Answers   HCL,


difference between view and index ?

0 Answers   IBM,






how to develop some simple graphs (bar charts) using just html?

0 Answers   IBM,


How to Define a Procedure in RPG?

0 Answers  


does we use case stmt in cl

1 Answers  


what is the maximum number of record formats in dspf?

1 Answers   IBM,


How can we create subsystem in as400?

1 Answers  


How to retrieve data from data area?

1 Answers  


what does vldcmdkey means?

0 Answers   IBM,


Categories