[Info-ingres] Fw: error trying to use ing_set on Linux

[Allan Biggs]

I want to set "ing_set" on a Linux box just for the current job (I will 
unset it after the job has run). 

Presumably the error here mean that only the Ingres installation account 
can use ingsetenv and set it globally?

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. 

My Linux/bash experience is almost non-existent :-) 

thanks
Allan 


> ingsetenv ing_set "set lockmode session where readlock = nolock"
ingsetenv: unable to set variable "ing_set"
        E_CL1405_NM_STOPN       NM[sg]tIngAt: Unable to open symbol table
        only the Ingres super-user can use ingsetenv
Mon Mar 07 at 14:32:19





From:   Karl Schendel <schendel at kbcomputer.com>
To:     "info-ingres at lists.planetingres.org" 
<info-ingres at lists.planetingres.org>
Date:   24/02/2016 15:10
Subject:        Re: [Info-ingres] ing_set on linux and windows
Sent by:        info-ingres-bounces at lists.planetingres.org




> On Feb 24, 2016, at 7:12 AM, Allan Biggs <Allan.Biggs at GBR.dupont.com> 
wrote:
> 
> I want to do some testing on a live IngresNet database from both a Linux 
box and W7 enterprise PC 
> I want to "set lockmode session where readlock = nolock" 
> 
> so that I don't lock any tables/rows in a live database. 
> I really want to do it for an individual database or a node is it 
possible to do this on both platforms 
> 
> I found this in the documentation 
> 
> setenv ING_SET_DBNAME 'set-statement {; set-statement}' 
> 
> but how do you specify the DBNAME if the database is defined by NETUTIL 
e.g.  as node1::db_allan 

I would assume that you just take the dbname, so ING_SET_db_allan  (or 
perhaps
ING_SET_DB_ALLAN, I don't know if it uppercases it or takes the name 
literally.)

Karl

_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres


This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano  Espanol  Portugues  Japanese  Chinese  Korean

          http://www.DuPont.com/corp/email_disclaimer.html
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20160307/9cb71532/attachment.html>