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
- 7787 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swadesh.yadav
Your question is not very clear but whereas i understand
if we make both fields unique, both of fields accept the
values unique i.e it will not accept duplicate value
together.For Example
Acct.no Phone no.
1111 2222(we can put this values)
1111 2222(Duplicacy not allowed)
1111 3333(we can put that)
2222 3333(we can put that)
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / gaurav
You can use File level keyword 'UNIQUE' which will accept
only unique record entry according to the key fields
defined.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
is there any way to dynamically merge other html scripts into a given html?
if &var='good++++' &var2='day' &var *cat &var2 &var1 *tcat &var2 what is output
how to declare a constant variable in the freeformat?
what is the use of data structures?
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?
what is the function of crtdupobj command?
i have two pfs it contains "Status" fields in the same name "status in both the pf's...But i used the same name in display file...when i enter a status thru disp file it willbe added to pf1...so i want to rename "Staus " field in pf2 through program...............wat will do..give coding?
Can we debug the MSGW JOBS?
is it possible to do commitment control with out journaling?
what is the disadvantage of using global variable?
How to add 99 menu (page down) option in menu creation..
What is SFLPAG
RPG400 
