Re: Restore SQL collection to a different name?

[rob@xxxxxxxxx]

David,

I just restored the DAVEMID sample I did to a library called DAVEMID2. 
None of the journals or journal receivers restored.
However, the constraints were all fine.  I used primary key constraints 
and foreign key constraints.  I do not use cascade.  Cascade's cool, but I 
would think many people would think it to be so efficient as to be scary.

I tried deleting a record from the parent that I knew to be used in the 
child and it wouldn't let me.  It let me create a new parent.
I know that journalling is required for certain constraint features, like 
cascading deletes and changes.

Updates to the files in library DAVEMID2 are still being journalled to the 
receivers in DAVEMID.  From DSPJRN:


                           Display Journal Entries 
 
Journal  . . . . . . :   QSQJRN          Library  . . . . . . :   DAVEMID 
Largest sequence number on this screen  . . . . . . : 00000000000000000066
Opt    Sequence  Code  Type  Object      Library     Job         Time
             65   R     PT   B           DAVEMID2    ROBS2       13:29:04
             66   R     PT   B           DAVEMID2    ROBS2       13:40:04




Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com