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
- 7505 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 |
Q. Soppose one job is running in a batch mode for long time now i want to kill(end)this batch job.How you will achive this?
What is the default access path of a file?
can a indexed file be accessed in arrival sequence in rpg program?
How do you combine two record formats in RLU ?
Hi.can any body give me the code for this quesiton please.Because i dont have to try to enter the code in to the AS/400 server.Please can anybody give the answer for this question with complete code? A smple RPLE pgm which accepts the starting number and ending number as parameter.It then has to count all the odd numbers b/w the accepted range of numbers and display the results/ Ex:if the input parameters are 11 and 30 the result should be 10(11,13,15,17,19,21,23,25,27,29) Please explain and give me the complete code?
What is class of service ?
how many maximum spaces could be given in o specs?
What is the use of Data Queues?
what is a query can be run in which mode?
I/o error detected,Record Out of sequence,Permanent I/o error occured....I mean give one eg for these errors...i understand only,update/delete operation without prior read oprn..give details of remaining
which are control break logic indicators?
Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please..
RPG400 
