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: "Wechsler, Steven M" <WechslerSM at bernstein dot com>
Subject: RE: Sybperl 2.09_05
Date: Jun 18 1998 2:23PM

> -----Original Message-----
> From:	Michael Peppler 
> Sent:	Saturday, June 13, 1998 1:47 PM
> To:	SybPerl Discussion List
> Subject:	Sybperl 2.09_05
> I've just added dbsqlsend() and dbpoll() to Sybase::DBlib, and applied
> W. Phillip Moore's patch to Sybase::DBlib::nsql().
> With dbsqlsend(), dbsqlok() and dbpoll() it is now possible to execute
> queries asynchronously. For example you could do this if you needed to
> run queries on multiple servers at the same time:
I've tested this, and it appears to work OK, both in blocking and
non-blocking mode (thanks, Michael).

However, I have a question: the original DBlib C implementation provided
a mechanism whereby you could poll for a specific DB process, rather
than all the connections you've currently got open.  Is there any way to
do this here?

For example, if I open up connections to 10 DB processes, the only way I
can determine which one dbpoll() is referring to is to compare the
returned dbhandle to all the handles I've currently got open.  That
seems to be kind of a kludgy way of doing it, especially if I get a
return for a handle I'm not yet interested in.

Steven Wechsler/Sybase DBA/Sanford C. Bernstein & Co., Inc. 
"Never underestimate the power of human stupidity" - Lazarus Long
Support the Anti-SPAM amendment: