Up Prev Next
From: "Alan Olsen" <olsena at odscompanies dot com>
Subject: Database handle question in Sybperl
Date: Nov 1 2005 5:49PM
I am using the latest version of Sybase::CTlib.
I have a piece of code that will have a database handle passed to it.
I want to be able to check the status of the handle. I need to know if
it is connected, has any pending requests, is dead or deadlocked and
anything else of use before I try to feed new requests to it.
So far, there seems to be little in the documentation on how to get the
status of a database handle. In the debugger, the handle seems to point
to Sybase::CTlib with points to an empty hash. (I am not certain if
this is a tied handle or what.
Any hints on how to determine the status of a handle?
I would use the DBD::Sybase code, but it requires rebuilding Perl and
all associated modules on my current machine. (I have an AIX box with a
Perl built with 64-bit ints. DBI does not like that, due to a pointer