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

Hello friends, i am new to AS/400. Can any one help me in AS/400 i meant say can you send me some FAQS and interview questions.

7 Answers   HanceInc, IBM,


What is file access opcodes?

0 Answers   IBM,


how many triggers can be associated with a file?

1 Answers   IBM,


write a pgm to read p.f using cl pgm?

2 Answers   Ocwen, SLK, TCS,


What is the Select and Omit criteria in logical file?

1 Answers  


What does SDA stands for ?

1 Answers  


is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?

0 Answers   IBM,


how can you check for a records existence without causing and i/o (chain/read)?

1 Answers   IBM,


A join logical file has how many record formats?

0 Answers   IBM,


how can you execute a command from within an rpg program without calling a clp program?

1 Answers   IBM,


how can I start a page in a new window?

0 Answers   IBM,


in conjunction with which statements can orxx and andxx conditions be used ?

1 Answers   IBM,


Categories