<br>
<br><font size=2 face="sans-serif">I want to set "ing_set" on
a Linux box just for the current job (I will unset it after the job has
run). </font>
<br>
<br><font size=2 face="sans-serif">Presumably the error here mean that
only the Ingres installation account can use ingsetenv and set it globally?</font>
<br>
<br><font size=2 face="sans-serif">Is there a way around this on Linux?
I am trying to set up ing_set in the current bash script and then delete
it when the script exits. </font>
<br>
<br><font size=2 face="sans-serif">My Linux/bash experience is almost non-existent
:-) </font>
<br>
<br><font size=2 face="sans-serif">thanks</font>
<br><font size=2 face="sans-serif">Allan </font>
<br>
<br>
<br><font size=1 color=blue face="Courier New">> ingsetenv ing_set "set
lockmode session where readlock = nolock"</font>
<br><font size=1 color=blue face="Courier New">ingsetenv: unable to set
variable "ing_set"</font>
<br><font size=1 color=blue face="Courier New">
E_CL1405_NM_STOPN NM[sg]tIngAt: Unable to open symbol
table</font>
<br><font size=1 color=blue face="Courier New">
only the Ingres super-user can use ingsetenv</font>
<br><font size=1 color=blue face="Courier New">Mon Mar 07@14:32:19</font>
<br>
<br>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Karl Schendel <schendel@kbcomputer.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 15:10</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">Re: [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><tt><font size=2><br>
> On Feb 24, 2016, at 7:12 AM, Allan Biggs <Allan.Biggs@GBR.dupont.com>
wrote:<br>
> <br>
> I want to do some testing on a live IngresNet database from both a
Linux box and W7 enterprise PC <br>
> I want to "set lockmode session where readlock = nolock"
<br>
> <br>
> so that I don't lock any tables/rows in a live database. <br>
> I really want to do it for an individual database or a node is it
possible to do this on both platforms <br>
> <br>
> I found this in the documentation <br>
> <br>
> setenv ING_SET_DBNAME 'set-statement {; set-statement}' <br>
> <br>
> but how do you specify the DBNAME if the database is defined by NETUTIL
e.g. as node1::db_allan <br>
<br>
I would assume that you just take the dbname, so ING_SET_db_allan (or
perhaps<br>
ING_SET_DB_ALLAN, I don't know if it uppercases it or takes the name literally.)<br>
<br>
Karl<br>
<br>
_______________________________________________<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>
<br><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>