this should work: before setting $dbh do something like this:
$ENV{ING_SET} = "SET LOCKMODE SESSION WHERE READLOCK = NOLOCK";
Refer to Ingres's System Reference Guide, Appendix A.
On Tue, Jan 04, 2005 at 11:38:44AM -0500, Nina Markova wrote:
> 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
>
