Thanks! It works.
Nina
------------- Begin Forwarded Message -------------
X-Unix-From: [EMAIL PROTECTED] Tue Jan 4 11:41:08 2005
Importance: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: RE: set lockmode session
Date: Tue, 4 Jan 2005 09:42:06 -0700
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
Thread-Topic: set lockmode session
Thread-Index: AcTyfBfh5nxBHEeHT/S8R3sR/FDczQAACFpg
From: "Reidy, Ron" <[EMAIL PROTECTED]>
To: "Nina Markova" <[EMAIL PROTECTED]>, <dbi-users@perl.org>
X-OriginalArrivalTime: 04 Jan 2005 16:39:42.0234 (UTC)
FILETIME=[FD924FA0:01C4F27B]
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by mail.seismo.nrcan.gc.ca
id j04Gf7N6016261
I'm no Ingres guy, but how about ...
$dbh->do("set lockmode session where readlock = nolock") || die $DBI::errstr;
-----------------
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: Nina Markova [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 9:39 AM
To: dbi-users@perl.org
Cc: [EMAIL PROTECTED]
Subject: set lockmode session
Hi,
I'm using perl with Ingres driver. My question is how to set readlock=nolock
via
perl dbi. Normally via eSQL I use
EXEC SQL SET LOCKMODE SESSION WHERE READLOCK = NOLOCK;
Is there any similar command in perl dbi? And if so, should it be method of db
handler ($dbh) or of a statement?
$dbh = DBI->connect("DBI:Ingres:$dbserver::$dbname") or
die("Couldn't connect to database: $!\n");
Thanks,
Nina
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
------------- End Forwarded Message -------------
-----'\/\/\/`v^v^v^v^v^v^v------------------------------------------
Nina Markova,
Database Analyst / Analyst de base de données
(613) 992-3753 facsimile / télécopieur (613) 992-8836
[EMAIL PROTECTED]
Geological Survey of Canada / Commission géologique du Canada
Natural Resources Canada / Ressources naturelles Canada
Government of Canada / Gouvernement du Canada
-----'\/\/\/`v^v^v^v^v^v^v----------------------------------
