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?
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 |
define a output queue?
How do you set the keywords SFLSIZ and SFLPAG if you want the subfile to dynamically expand?
is it possible to create a join logical file using two join logical files ? give exact reason for your answer
What are the system objects required for journalling?
what are two types of record are used in subfile?
hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.
what is the syntax for plist?
explain the purpose of keep and assume keywords?
Good morning my experts.Im kuppi.im working as a software trainee on AS/400 technology.i have also joined with ibmi5 team.im trying to convert date with cl/400 coding.I have taken 2 parameters(like date and date types). A. If suppose date type is j,Now i want to convert date to *MDY format B. if date type is M,now i want to convert date to *JUL format C. sending a Program message with the value of converted date.
What are the two types of read performed on data queues?
What is the difference between crtdupobj and copyf?
difference between view and index ?