RE: ODBC Security

We handle backup and restore issuse created by having logicals in separate
libraries by having a CL that destroys the logicals and another that
recreates them.  The idea of the separate library is to keep the user out of
the library where the physical file is actually located.

Regards,
Rick Warren
Database Developer
Burlington Chemical Co., Inc.

-----Original Message-----
From: D.BALE@handleman.com [mailto:D.BALE@handleman.com]
Sent: Friday, November 10, 2000 9:34 AM
To: MIDRANGE-L@midrange.com
Subject: RE: ODBC Security


I would recommend you keep the logicals in the same library as the physical
files.  Otherwise you'll have backup and restore issues to deal with.

Dan Bale
IT - AS/400
Handleman Company
248-362-4400  Ext. 4952

-------------------------- Original Message --------------------------
I love the idea of the logicals. I also appreciate everyone's input on this.
It makes sense to create these logicals, and perhaps segment them in a
separate library so that the ODBC connection only has to search one library
list.

Thanks to all!

Patrick
+---
| 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
+---
+---
| 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
+---