<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><span>Thanks, Bob: Over a month, eh? Well, don't be s stranger I think I said before!</span></div><div><span></span> </div><div><span>It's OpenVMS Rdb - old version 7.1 to be sure, PH 7.10... so not the really old VMS RDBMS certainly.</span></div><div><span></span> </div><div><span>Well, my thoughts are that it don't matter as they say in the vernacular, seeing as all Rdb access is done under the sheets.</span></div><div> </div><div>But I have also gotten a couple of 'hey, old school, re-compile' posts. I'll let you all know how it turns out and again, Thanks! to all who responded.</div><div> </div><div><b><div><span><b><font face="arial, helvetica, sans-serif">John M Penney</font></b></span><b><font face="arial, helvetica, sans-serif"><span style="color: black; font-family: Arial; font-size: 10pt;"
class="ms__id3033"><br>1532 Fern Street SW</span><span style="color: black; font-family: Arial; font-size: 10pt;" class="ms__id3034"><br>Olympia</span><span style="color: black; font-family: Arial; font-size: 10pt;" class="ms__id3035">, WA 98502</span><span style="color: black; font-family: Arial; font-size: 10pt;" class="ms__id3036"></span></font></b><span><b><font face="arial, helvetica, sans-serif"><br>(360)789-8159</font></b></span><span><br> <div style="margin: 0in 0in 0pt;" class="MsoNormal"></div></span></div></b></div><div><br></div> <div style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <div style="margin: 5px 0px; padding: 0px; border: 1px solid rgb(204, 204, 204); height: 0px; line-height: 0; font-size: 0px;" class="hr" contentEditable="false" readonly="true"></div> <font size="2" face="Arial"> <b><span
style="font-weight: bold;">From:</span></b> Robert Deskin <bob.deskin@me.com><br> <b><span style="font-weight: bold;">To:</span></b> "Penney, John" <resolutebay@yahoo.com> <br><b><span style="font-weight: bold;">Cc:</span></b> power-l <powerh-l@lists.sowder.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Sunday, August 25, 2013 5:43 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: Oracle Rdb and recompile requirements<br> </font> </div> <div class="y_msg_container"><br><div id="yiv4728670035"><div><div>It may matter how you declared the database in the dictionary. Are you using the native interface or the SQL interface. </div><div><br></div><div>If you used RDB, then it's the SQL interface and I wouldn't expect it to matter. That's because PowerHouse generates SQL based on the structure at the time, but it's the database that decides which indices to use. In other words, there's no PowerHouse use
of relational database indexes at execution time.</div><div><br></div><div>On the other hand, if you used RDB/VMS, I really don't know. It's quite possible that the routines used at execution time are based on the structure known at compile time. </div><div><br></div><div>That's my recollection. Remember I've been away from this stuff for over a month.</div><div><br></div><div>Cheers</div><div><br></div><div>Bob</div><div><br><div><div>On 2013-08-20, at 4:10 PM, "Penney, John" <<a href="mailto:resolutebay@yahoo.com" rel="nofollow" target="_blank" ymailto="mailto:resolutebay@yahoo.com">resolutebay@yahoo.com</a>> wrote:</div><br class="yiv4728670035Apple-interchange-newline"><blockquote type="cite"><div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; background-color: rgb(255, 255, 255);"><div><span>Good Afternoon, PH Listers:</span></div><div><span></span> </div><div><span>We've made a change to a table, removing a
repeating key and the question was raised "Do we have to recompile all the programs that access that table?". My opinion and several others was "No...". We've had an enqueue and quota anomaly and I'm questioning whether our previous recompile asssumption was in fact correct?</span></div><div><span></span> </div><div><span>Can anyone please share?</span></div><div><span></span> </div><div><span>env: <font size="2" face="r_ansi"><font size="2" face="r_ansi">QDESIGN710G VT320</font></font></span></div><div><span></span> </div><div><span><font size="2" face="r_ansi"><font size="2" face="r_ansi">Rdb: <font size="2" face="r_ansi"><font size="2" face="r_ansi">Rdb/Dispatch V7.0-65
(OpenVMS AXP)</font></font></font></font></span></div><div><font size="2" face="r_ansi"> </font></div><div><font size="2" face="r_ansi"><font size="2" face="r_ansi"><font size="2" face="r_ansi">and some kind of big HP Alpha (AKA DEC/VAX) server....</font></font>openvms ver: <font size="2" face="r_ansi"><font size="2" face="r_ansi">OpenVMS V7.1-2 </font></font></font></div><div><font size="2" face="r_ansi"> </font></div><div><font size="2" face="r_ansi">Yes, i realize some of this stuff is neanderthal...</font></div><div><font size="2" face="r_ansi"> </font></div><div><font size="2" face="r_ansi">Thanks a bunch!</font><b><span><b><font face="arial, helvetica, sans-serif">John M Penney</font></b></span><b><font face="arial, helvetica, sans-serif"><span style="font-family: Arial; font-size: 10pt;" class="yiv4728670035ms__id3120"><br></span></font></b><span> </span></b></div><div style="margin: 0in 0in 0pt;"
class="yiv4728670035MsoNormal"></div></div></div>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com" rel="nofollow" target="_blank" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" rel="nofollow" target="_blank" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" rel="nofollow" target="_blank" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" rel="nofollow" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><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></div><br></div></div></div><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><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.<br><br></div> </div> </div> </div></body></html>