Re: Restore SQL collection to a different name?

[David Gibbs <david@xxxxxxxxxxxx>]

Mike Wills wrote:
> In that case you create a new collection, create the empty tables, then CPYF 
> all of the files from the old lib to the new one.

But I have to create the entire sql structure over again before I can
copy the data ... and if there are constraints in place, I have to
figure out what order the files must be copied in (in order to satisfy
the constraints).

Sorry, this should be part of the basic functionality of OS400 ... I can
restore a library of PF's & LF's to a different name and the system will
deal with the differences without any problem.  I should be able to do
the same thing with a sql collection too.

JMHO, of course.

FWIW: I just created a new sql collection and did a CPYLIB on the
original collection ... all the constraint information was actually
copied over fine ... but the journal's were not attached to the files
that were copied.

david

-- 
David Gibbs
david@xxxxxxxxxxxx

Receipt of this message does not grant you permission to send me
Unsolicited Commercial Email