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: dbsqlsend
Date: Jun 9 1998 9:25PM

> -----Original Message-----
> From:	Michael Peppler []
> Sent:	Tuesday, June 09, 1998 4:54 PM
> To:	SybPerl Discussion List
> Subject:	dbsqlsend
> Wechsler, Steven M writes:
>  > It appears that dbsqlsend hasn't been implemented in sybperl.  Is
> there
>  > a reason for this?
> Nobody's asked for it...
> However, dbsqlsend() is trivial to implement, if dbsqlok() exists (I
> think it does):
Yes, it does, for text processing...

> int
> dbsqlsend(dbp)
> 	SV *	dbp
> {
>     DBPROCESS *dbproc = getDBPROC(dbp);
>     RETVAL = dbsqlsend(dbproc);
>     if(debug_level & TRACE_RESULTS)
> 	warn("%s->dbsqlsend == %d",
> 	     neatsvpv(dbp, 0), RETVAL);
> }
> plop this in to DBlib.xs just below (or above) the dbsqlok()
> definition, and rebuild.
> Should work fine...
>  > I have a need to send a command to several servers
>  > at the same time, and I'd hate to have to do it by forking several
>  > processes, since it's not really what I had in mind.  Is there a
> set of
>  > corresponding calls in ct-lib that *have* been implemented?
> No. Asynch processing is not supported at this point in CTlib. 
What exactly would dbsqlsend, as implemented above, do?  According to
the DB-Lib manual, it "Send[s] a command batch to the server and do[es]
not wait for a response. "

How would using your implementation differ from the standard C
implementation?  What's involved in getting Asynch I/O to work?  If
dbsqlsend doesn't wait for a response, isn't that pretty much what I'm
looking for (since dbsqlok is already implemented)?  Or is there more
involved that I'm missing?

I might add this sometime in teh future, but time is short...

Actually, time is infinite (or so they tell me).  *Life*, on the other
hand... :-)

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