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

when would you prefer logical file than opnqryf?

1 Answers   IBM,


What are the types of data structure in as400?

0 Answers  


How to write a password mask program in as400? like the password which i type should be displayed as '*****' r ###### which the user wishes to dispaly if u could help me with url r the solution in written code this will help me

21 Answers   Accenture, SNS,


In which specification can a report layout be defined ?

1 Answers  


What is the purpose of OPNQRYF (Open Query File)?

1 Answers  


i have recently moved to hyd. i would like to know which is the best institue to learn AS400. are there any in ameerpet? thanks.

4 Answers  


What are the different definition levels in Data Description Specifications?

1 Answers  


define the purpose of the iter operation?

1 Answers   IBM,


what does exfmt does?

1 Answers   IBM,


How many Printer Files can Declare in a CL Program?

4 Answers  


how do handle file exception/error?

0 Answers   IBM,


how you will find an error which is not in the first page of the subfile without using rolldown key?

0 Answers   IBM,


Categories