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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the various types of device files?

991


is there any way to dynamically merge other html scripts into a given html?

600


In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project.

8523


what is the difference between sflclr and sflinz?

1033


can a indexed file be accessed in arrival sequence in rpg program?

936






1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?

405


when are the unique constraints executed?

682


To Add A File To The 'file Selection' Option Of A Query, The Function Key To Be Pressed Is?

792


an access path may be in which sequence?

633


How to avoid using indicators in ile ?

765


what does defn do?

612


what are different record spacing keywords in rlu ?

1207


how can you detect overflow for a print program that prints multiple lines per cycle?

960


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

664


what is overlay?

678