<font size=2 face="sans-serif">I later discovered (for windows)</font>
<br>
<br><font size=1 face="Andale Mono">SET ING_SET=SET LOCKMODE SESSION WHERE
READLOCK=NOLOCK </font>
<br><font size=1 face="Andale Mono">and </font>
<br><font size=1 face="Andale Mono">SET ING_SET_node1::db_allan =SET LOCKMODE
SESSION WHERE READLOCK=NOLOCK </font>
<br>
<br><font size=1 face="Andale Mono">I was just surprised that "::"
is OK in the environment variable </font>
<br><font size=1 face="Andale Mono">Is there a way of checking that the
lockmode has been set in the ingres_net database? </font>
<br>
<br><font size=1 face="Andale Mono">Thanks</font>
<br><font size=1 face="Andale Mono">Allan</font>
<br>
<br>
<br>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Allan Biggs <Allan.Biggs@GBR.dupont.com></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">"info-ingres@lists.planetingres.org"
<info-ingres@lists.planetingres.org></font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">24/02/2016 12:12</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">[Info-ingres]
ing_set on linux and windows</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by:
</font><font size=1 face="sans-serif">info-ingres-bounces@lists.planetingres.org</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=2 face="sans-serif">I want to do some testing on a live
IngresNet database from both a Linux box and W7 enterprise PC</font><font size=3>
<br>
<br>
</font><font size=2 face="sans-serif"><br>
I want to "set lockmode session where readlock = nolock" </font><font size=3><br>
</font><font size=2 face="sans-serif"><br>
so that I don't lock any tables/rows in a live database.</font><font size=3>
</font><font size=2 face="sans-serif"><br>
I really want to do it for an individual database or a node is it possible
to do this on both platforms </font><font size=3><br>
</font><font size=2 face="sans-serif"><br>
I found this in the documentation </font><font size=3><br>
</font><font size=1 face="Andale Mono"><br>
setenv ING_SET_DBNAME 'set-statement {; set-statement}' </font><font size=2 face="sans-serif"> </font><font size=3>
<br>
</font><font size=2 face="sans-serif"><br>
but how do you specify the DBNAME if the database is defined by NETUTIL
e.g. as node1::db_allan</font><font size=3> <br>
<br>
</font><font size=2 face="sans-serif"><br>
thanks</font><font size=3> </font><font size=2 face="sans-serif"><br>
Allan</font>
<p><font size=3><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail
does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</font>
<p><font size=3>Francais Deutsch Italiano Espanol Portugues
Japanese Chinese Korean</font>
<p><font size=3> </font><a href=http://www.dupont.com/corp/email_disclaimer.html><font size=3>http://www.DuPont.com/corp/email_disclaimer.html</font></a><tt><font size=2>_______________________________________________<br>
Info-ingres mailing list<br>
Info-ingres@lists.planetingres.org<br>
</font></tt><a href="http://lists.planetingres.org/mailman/listinfo/info-ingres"><tt><font size=2>http://lists.planetingres.org/mailman/listinfo/info-ingres</font></tt></a><tt><font size=2><br>
</font></tt>
<p><p><br>
This communication is for use by the intended recipient and contains<br>
information that may be Privileged, confidential or copyrighted under<br>
applicable law. If you are not the intended recipient, you are hereby<br>
formally notified that any use, copying or distribution of this e-mail,<br>
in whole or in part, is strictly prohibited. Please notify the sender by<br>
return e-mail and delete this e-mail from your system. Unless explicitly<br>
and conspicuously designated as "E-Contract Intended", this e-mail does<br>
not constitute a contract offer, a contract amendment, or an acceptance<br>
of a contract offer. This e-mail does not constitute a consent to the<br>
use of sender's contact information for direct marketing purposes or for<br>
transfers of data to third parties.</p>
<p>Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean</p>
<p> http://www.DuPont.com/corp/email_disclaimer.html</p>