Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 7777 Views
- I also Faced
- E-Mail Answers
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
what does opcode post do ?
what is maximum number of arrays allowed in rpg?
can error messages as a result of a comp, range or values keyword be overridden?
what does the ovrdbf command do?
how many maximum spaces could be given in o specs?
how may a cgi control duplicate inputs?
what is the function of cpyf command?
how many printer files can be defined in f specs ?
How can we update a specific field in RPG?
which are the member types which seu supports?
how will you display a particular page in subfile ?
what does defn do?
any one have give AS400 study material? pls pass it to gopalsai789@gmail.com
what is the function of cpysplf command?
what is the use of unique keyword and what level it is defined?
