Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

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