|
View previous topic :: View next topic
|
| Author |
Message |
Mahsa Rouzkhatouni
New User
Joined: 27 Feb 2021
Posts: 32
Location: Germany
|
|
|
|
Hi all,
Is there any difference between VALIDPROC and CHECK CONSTRAINT in DB2 except for that VALIDPROC effects on an entire row and CHECK CONS. assesses a column?
Is there any advantage to use one instead of another one?
Thanks in advance,
Mahsa Rouzkhatouni |
|
| Back to top |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
| Did you look at the DB2 Manuals yet ,since that has all the detailed information that you need? |
|
| Back to top |
|
|
Mahsa Rouzkhatouni
New User
Joined: 27 Feb 2021
Posts: 32
Location: Germany
|
|
|
|
| Rohit Umarjikar wrote: |
| Did you look at the DB2 Manuals yet ,since that has all the detailed information that you need? |
Well yeah, I've read both sections about constraints and Edit/Validprocs but I couldn't understand their priority of use except for Row/Column control. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA
|
|
|
|
Everything is in the manual. What is your requirement?
CHECK is used to control specific values during INSERT or IPDATE for that column/s.
VALIDATIONs do more than that and you can read here further.
Validation routines |
|
| Back to top |
|
|
|
|
