Re: Removing constraints

[David Gibbs <david@xxxxxxxxxxxx>]

R Bruce Hoffman wrote:
> It sounds like either you don't have a source member that created this
> schema or you have lost control of the source that was used to create
> the schema, or... most likely on the iSeries, you didn't have one to
> begin with. Someone just kept adding things on with command line
> options.

Actually, no.  We're in complete control of the schema ... the problem
is, the schema that we created isn't the one that's currently in place.
 And we can't figure out what changed it.  In fact, the current schema
that we're finding isn't even logical.  There are foreign key
constraints on files that should have a primary key constraint, but the
primary key constraint isn't there.

My suspicion is that the constraints were somehow damaged when we
restored the library.

david