RE: Need 2 cents on multiple libraries

["David Morris" <dmorris@xxxxxxxxxxxxx>]

Bill,

You can certainly handle one member at a time using overrides, you can't 
override to *ALL.  Another 
alternative is to use an SQL ALIAS, same limitation. Multiple libraries/members 
are not the way to go 
unless there is some distinct advantage.  Library list overflow, unique key 
problems, SQL limitations, 
all make it much more difficult to handle multiple libraries.  The only 
advantage I can think of is backup 
window in multiple time zones.

David Morris

>>> breger@levitz.com 03/17/00 10:37AM >>>
SQL will handle multiple-member files by issuing an OVRDBF before the SQL
operation.

William K. Reger
Senior Project Manager
Levitz Furniture Corporation
Phone:  (561) 994-5114
E-mail:  breger@levitz.com <mailto:breger@levitz.com> 
                
                Multi-member files are a no-no though.  SQL (?? someone
confirm) can't
                handle multi-member files.  Maybe others, too?

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