Up Prev Next
From: "Ravipudi, Murali" <Murali dot Ravipudi at gs dot com>
Subject: RE: DBlib bcp in/out sample
Date: Aug 25 1999 2:22PM
You mean even thought the bcp is a different session, ( called with back
ticks ), I will get this error?
I thought if it was in the same session, and I didnt clear the previous
result sets, it makes sense to throw an error....
> -----Original Message-----
> From: Michael Peppler [SMTP:email@example.com]
> Sent: Wednesday, August 25, 1999 10:20 AM
> To: SybPerl Discussion List
> Subject: RE: DBlib bcp in/out sample
> Ravipudi, Murali writes:
> > Yes, I am already using it that way.
> > My code is like :
> > dblib : create temp table
> > dblib : call stored proc ( which fills this temp table)
> > system : bcp the data out from the temp table
> > dblib : clear the temptable ( not necessary, but in future there will
> > more actions added after this. )
> > and I wanted to do the bcp also using dblib, rather than using the back
> > ticks.
> > In the above sequence, I am getting a "Sybase error: Attempt to
> initiate a
> > new SQL Server operation with results pending." when the bcp is called.
> > that is why !! ?? !! ??
> Because you are not flushing all the results (calling dbresults() in a
> loop as you should, until it returns NO_MORE_RESULTS)
> Michael Peppler -||- Data Migrations Inc.
> firstname.lastname@example.org -||- http://www.mbay.net/~mpeppler
> Int. Sybase User Group -||- http://www.isug.com
> Sybase on Linux mailing list: email@example.com