RE: Constraints, anyone?

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> I've just been asked to look into adding constraints to a database (as
> an alternative to triggers on the database, and exit programs on the
> application).

Let's start with information about the types of constraints.  What is the
business need?  There are some constraints you're probably used to already
(though they go by a different name), such as UNIQUEness of a key.  There
can be constraints that ensure that data is not orphaned (such as an order
record without a matching customer record) and so on.  What type are we
talking about here?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"The problem with being punctual is that nobody's there to appreciate it."
        -- Franklin P. Jones