<div>Hey, Peter:</div> <div> </div> <div>This is an old version of the product (1994 IIRC) and I bet it issues another attach in that instance you highlight. </div> <div> </div> <div>Any lister know for sure?</div> <div> </div> <div>Tks<BR><BR><B><I>Peter Bateman <peterbateman808@hotmail.com></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"> <STYLE> .hmmessage P { margin:0px; padding:0px } body.hmmessage { FONT-SIZE: 10pt; FONT-FAMILY:Tahoma } </STYLE> Hi John:<BR> <BR> With RMS an ALIAS should not cause another open unless the file options were incompatable with<BR> previous file options.<BR> <BR> i.e.
FILE XXX PRIMARY READ SHARE<BR> FILE XXX DESIGNER ALIAS XXX2 WRITE SHARE<BR> you would 2 opens of XXX<BR> Let us hope that PH7.10E6 did not use the same rule for Oracle/RDB but have not actually<BR> looked.<BR> Regards,<BR> Peter Bateman<BR><BR><BR> <BLOCKQUOTE> <HR> Date: Tue, 22 Apr 2008 10:58:10 -0700<BR>From: resolutebay@yahoo.com<BR>Subject: RE: VMS 6.2, Dec Rdb V6.1-13, Powerhouse 7.10E6 database attaches<BR>To: peterbateman808@hotmail.com<BR><BR> <DIV>Hey, Peter:</DIV> <DIV> </DIV> <DIV>What about the ALIAS syntax?</DIV> <DIV> </DIV> <DIV>Thanks, I'll add your fuel to the fire!</DIV> <DIV> </DIV> <DIV>JP<BR><BR><B><I>Peter Bateman
<peterbateman808@hotmail.com></I></B> wrote:</DIV> <BLOCKQUOTE class=EC_replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"> <STYLE> .ExternalClass .EC_hmmessage P {padding:0px;} .ExternalClass body.EC_hmmessage {font-size:10pt;font-family:Tahoma;} </STYLE> Hi John:<BR> <BR> You definitely want to get rid of the OPEN # syntax as each OPEN with a different # causes<BR> another attach.<BR> <BR> Try running the application with DBAUDIT=FULL this will show when there is a new attach.<BR> <BR> If you do use GO or $QUICK from QDESIGN then the signon user will still have the attaches that<BR> QDESIGN
opened. I believe SET DICT before the GO will cause QDESIGN to detach.<BR> <BR> Regards,<BR> Peter Bateman<BR> <BR> <BR><BR><BR> <BLOCKQUOTE> <HR> Date: Tue, 22 Apr 2008 08:48:42 -0700<BR>From: resolutebay@yahoo.com<BR>Subject: RE: VMS 6.2, Dec Rdb V6.1-13, Powerhouse 7.10E6 database attaches<BR>To: powerh-l@lists.sowder.com<BR><BR> <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> <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" target=_blank>Try it now.</A></BLOCKQUOTE><BR> <HR> Sign in now! Windows Live Messenger is giving you a chance to win $1000 a day until May 12th <A href="http://g.msn.ca/ca55/214" target=_blank>Check out SignInAndWIN.ca today!</A> -- <BR>= = = =
= = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This list is closed, thus to post to the list you must be a subscriber.<BR>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.</BLOCKQUOTE><BR><BR><BR> <DIV><STRONG>John M Penney, Partner</STRONG></DIV> <DIV><STRONG>The TechUnion Group</STRONG> </DIV> <DIV><STRONG>1532 Fern Street SW</STRONG></DIV> <DIV><STRONG>Olympia, WA 98502</STRONG></DIV> <DIV> </DIV> <DIV><STRONG>(360)789-8159</STRONG></DIV> <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"
target=_blank>Try it now.</A></BLOCKQUOTE><BR> <HR> Sign in now! Windows Live Messenger is giving you a chance to win $1000 a day until May 12th <A href="http://g.msn.ca/ca55/214" target=_new>Check out SignInAndWIN.ca today!</A> </BLOCKQUOTE><BR><BR><BR><DIV><STRONG>John M Penney, Partner</STRONG></DIV> <DIV><STRONG>The TechUnion Group</STRONG> </DIV> <DIV><STRONG>1532 Fern Street SW</STRONG></DIV> <DIV><STRONG>Olympia, WA 98502</STRONG></DIV> <DIV> </DIV> <DIV><STRONG>(360)789-8159</STRONG></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>