Re: Removing constraints

[David Gibbs <david@xxxxxxxxxxxx>]

R Bruce Hoffman wrote:
>>In this case, it's an entirely SQL DDL schema.
> Ok, so after the restore, did/have you done a WRKPFCST? And are the
> constraints completely missing or pending?

Missing yes, pending no.

> And maybe I missed this... did you restore to the same library name or a
> different library name?

Same name.  The backup was done using Save menu 21 in a restricted state
(or so the customer has told me).

>>The schema is managed by the application.
> Still not exactly sure what you mean by this. Do you mean that there is
> some "install/update" program included with the application that
> creates/modifies the schema? Or is there a separate file/member of DDL
> statements that is maintained in the application but can still be
> applied through, say, Client Access or RUNSQLSTM?

Application builds & modifies the schema during install / upgrade.  It
also can modify the schema slightly ongoing.  This is a java
application, running on an Integrate Xseries Server.  No iSeries native
code is involved.

david