IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Difference between VALIDPROC and CHECK CONSTRAINT


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Mahsa Rouzkhatouni

New User


Joined: 27 Feb 2021
Posts: 22
Location: Germany

PostPosted: Mon May 03, 2021 10:56 am
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2639
Location: NYC,USA

PostPosted: Tue May 04, 2021 6:40 pm
Reply with quote

Did you look at the DB2 Manuals yet ,since that has all the detailed information that you need?
Back to top
View user's profile Send private message
Mahsa Rouzkhatouni

New User


Joined: 27 Feb 2021
Posts: 22
Location: Germany

PostPosted: Wed May 05, 2021 2:11 pm
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2639
Location: NYC,USA

PostPosted: Mon May 10, 2021 10:05 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Control M features to check string in... Compuware & Other Tools 1
No new posts Numeric check w/SyncSort. SYNCSORT 1
No new posts Difference between CEE3250C and CEE3204S COBOL Programming 2
No new posts Want to check if trailer count is 0 a... JCL & VSAM 10
No new posts Difference between sysexec and sysproc CLIST & REXX 6
Search our Forums:

Back to Top