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?
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
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?
any one have give AS400 study material? pls pass it to gopalsai789@gmail.com
A join logical file has how many record formats?
what is logical file?
What is difference between rename and prefix?
what is a primary file?
Why we sometimes use same file name in file and tofile in ovrdbf and sometimes different?
what do we can do with the embedded sql statements?
What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?
is it possible to create a physical file without dds?
in conjunction with which statements can orxx and andxx conditions be used ?
when should I use method get, and when should I use method post in my cgis?
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
define data structure?
how to develop some simple graphs (bar charts) using just html?