A phisical file has two fields like 1) Account No(10,0)
2)Phone No(15,0)Unique on both fields?Please give me the
answer for this?
Answer Posted / amit
If you use UNIQUE on both fields then one account will
allow only one phone number. Another phone number can't be
used there similarly you can't have one phone number
associated with multiple account.
however if you give unique constraint for the key
combination then it would ensure that you have account
number and phone number combination is unique.
So you can have same account number with multiple phone
numbers and vice versa.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
maximum number of subfiles that can be active for a single file is?
What Is Ddm ?
How can we update a specific field in RPG?
how can you specify no duplicate key?
what is a program described file in rpg?
can a single screen format occupy a screen area above and below a subfile format ?
is it possible to create a physical file without dds?
what does the ovrdbf command do?
what is message subfile?
What is data structure in as400? What is the use of data structure?
What are the mandatory keywords of sub file?
what is the difference between packed decimal and zoned decimal?
what are the different types of variables available in cl?
What is the default access path of a file?
what is rpg ?