Re: Is is possible to create a check constraint across the tables.

You can create a table check constriant for this.

Check this link for more details:

http://www.ibm.com/developerworks/db...nyk/index.html

elza wrote:

> You can create a table check constriant for this.

"table check constraint" is not a very good name. Those things are
rather "row check constraints". You can only refer to constants and the
values in a single row in the constraint - no other table or other rows of
the same table.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany