RE: Backup & Restore SQL Collection to another name?

Mike,

When you save the library and restore it to another strange things happen.

STRSQL
CREATE COLLECTION ROBBONE
CREATE TABLE ROBBONE/MC
(MYKEY INT NOT NULL AS IDENTITY,
MYDATA CHAR (5 ) NOT NULL WITH DEFAULT,
PRIMARY KEY (MYKEY))

DSPFD ROBBONE/MC
File is currently journaled . . . . . . . . : Yes
Current or last journal . . . . . . . . . . : QSQJRN
Library . . . . . . . . . . . . . . . . . : ROBBONE

SAVLIB LIB(ROBBONE) DEV(*SAVF) SAVF(ROB/ROB)
RSTLIB SAVLIB(ROBBONE) DEV(*SAVF) SAVF(ROB/ROB) RSTLIB(ROBBTWO)
21 objects restored. 2 not restored to ROBBTWO.
Cannot restore journal QSQJRN to library ROBBTWO.
JRNRCV QSQJRN0001 not restored to ROBBTWO.
DSPFD ROBBTWO/MC
File is currently journaled . . . . . . . . : Yes
Current or last journal . . . . . . . . . . : QSQJRN
Library . . . . . . . . . . . . . . . . . : ROBBONE

Now, why would I want the journal to be in the old library?

WRKOBJ OBJ(ROBBTWO/*ALL) OBJTYPE(*JRN)
(Cannot find object to match specified name.)
WRKOBJ OBJ(ROBBTWO/*ALL) OBJTYPE(*JRNRCV)
(Cannot find object to match specified name.)

In our Mimix world we journal to a different library. The library which
holds all of our journals and receivers, #MXJRN. The "#" tends to get it
restored first.

Understand?

Rob Berendt