Re: Removing constraints

On Sun, 2005-04-03 at 09:03, David Gibbs wrote:
> R Bruce Hoffman wrote:
> > No matter. What I was getting at was is this a mixed DDS and SQL DDL
> > schema/library or completely SQL DDL schema?
> 
> In this case, it's an entirely SQL DDL schema.
> 

Ouch!

I'm sorry to be thick here... but now I'm really curious/concerned.

Ok, so after the restore, did/have you done a WRKPFCST? And are the
constraints completely missing or pending?

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

> > And in the case of the completely SQL DDL schema... is it managed by a
> > tool or at least by a member/file of DDL statements?
> 
> 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?



> david
-- 
"Bigamy is having one wife too many. Monogamy is the same."
-- Oscar Wilde