Re: SQL files and Restore

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

-----Original Message-----
From: Jim Knight <jknight@rei.com>
To: 'Midrange Users list' <MIDRANGE-L@midrange.com>
Date: Wednesday, June 28, 2000 12:03 PM
Subject: SQL files and Restore


>We are beginning to use SQL to build our database files
>and a question has arisen......
>
>  With using R/I and foreign keys, will a RSTLIB restore
>  the objects in the proper order to maintain the FK constraints
>  or do we need to restore them in a specified order?
>


If the files are saved together and restored together, no, the sequence does
not matter.  If the files are at the same level, then the RI is restored.
If they are at different levels, it will be marked "check pending" and you
will need to clean this up after the restore.  This usually occurs when a
parent file changes during a save.  Use save while active or quiesce the
system.

If your RI includes rules other than restrict, then you will probably be
using journals and any check pending issues can usually be resolved through
the application of the journal entries.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"If all you have is RPG, then everything looks like a 400!"


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---