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
- 7564 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 |
what is cab?
What is the purpose of STRCMTCTL command?
what is the maximum number of parameters allowed in rpg?
How to debug a batch job when it is in messagewait(mswg) status. I know the steps for batch ebugging, but im confusing with when we submit any job for batch debug we put in held state. So here also do same thing or any other way?
load all subfile logic in sqlrpgle and when updating particular record it must be lock form other jobs (not a file)?
What is LEVEL CHECK?
how to write *pssr ?
Which command we can use to update a physical file using c.l pgm?
how to toggle between single line and multi - line display of a particular record in a subfile?
How to create a user defined (general) data area?
Hi friends i have i question please reply me asap. what would be coding in DDS and programing part for this condition suppose that i have three fields in the display file(subfile)which has 7 record format. Condition is ''The supplier LOT, ISSUED TO PROD and LINE GRP fields in display file(Subfile) will not be shown if their respective fields are blank/zero in the record formats WIM311FM and Record format WIM311FM. I want coding part in DDS and Programing. Please reply me as soon as posible.
Hi,while writing a program, what is the mandatory specification using rpg/400 (in7 specification)?And please tell me what is the difference between SCAN AND CHECK opcodes?can any body tell me in real time senario?with example?
RPG400 
