Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What is a library list ?

1 Answers  


what is the function of cpyf command?

1 Answers   IBM,


what is primarykey?what is difference between primary key and forign key?

1 Answers  


why is the declare cursor statement is used for?

0 Answers   IBM,


What is difference between fully procedural file and primary file?

1 Answers  


When will you use OPEN and CLOSE opcodes in RPG program?

1 Answers  


how we lock a pf???? what are the parameters used in this command.how we understand whether an object is locked or not?? using command .....we have to use *PSSR? and trough *status..how??.if we give an eg to me???pls answer me anyone..

5 Answers   CTS,


Space & Skip Are Which Level Keywords?

0 Answers   IBM,


What is the difference between externally described file and program described file?

1 Answers  


what is the use of dspatr(mdt) keyword?

1 Answers   IBM,


Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?

0 Answers  


What are the types of object authorities?

1 Answers  


Categories