database constraints
Date: 14 Jun 1994 23:10:42 GMT
Message-ID: <2tlddi$db2_at_camelot.qdot.qld.gov.au>
We have an application that needs more than a foreign key ,
the ability to restrict codes to those marked current in
another table.
This requires a constraint along the lines of
CONSTRAINT check_current
So the table being defined has a constraint that column
dept_code must be a current division code (not retired)
Can someone advise when integrity constraints will be extended
in this direction ?
Stephen Gerard
CHECK dept_code EXISTS IN ( select d.dept_code
from division d
where retired_ind is null )
Analyst Programmer
QCOM Systems and Software
Brisbane Qld 4000
++61 7 8393544
sjg_at_avalon.qdot.qld.gov.au
<<< My thoughts and opinions only, ... etc >>>
re Received on Wed Jun 15 1994 - 01:10:42 CEST