<div>Hello again, fellow PH listers:</div> <div> </div> <div>I've been asked to determine how many PH attaches Quick makes to Rdb. Our DBA (in Denver) says he sees between 2 and 5 per user. He's concerned about exceeding the 2,032 attach limit and having to upgrade because of same. i.e. RDB, PH, VMS O/S</div> <div> </div> <div>I conclude we have one d/b attach for each file statement referencing a unique database. So if we have 3 databases we get 3 attaches?</div> <div> </div> <div>What about ALIASes? </div> <div> </div> <div>What effect (if any) is there in using a CLOSE command but FWIW, I believe that only works for flat or indexed files, not relational databases?</div> <div> </div> <div>I don't know off the top, Google wasn't that much help, how we can minimize the attaches which is the focus of the questions. I recall DISCONNECT DEFAULT works in SQL, but......</div> <div> </div> <div>TIA</div> <div> </div>
<div>Best and thanks to all who responded to my earlier....</div> <div> </div> <div>JP</div><p> 
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a>