sybperl-l Archive

From: "Damodharan, Venkat (VDamodharan)" <Venkat dot Damodharan at dresdnerrcm dot com>
Subject: RE: DBlib bcp in/out sample
Date: Aug 23 1999 10:30PM

This is because you have cleared your result set.  The result sets are in
the output buffer.  Either you have get all the results by fetching them or
cancel the result before going for the next execution.

Rgds

Venkat

-----Original Message-----
From: Ravipudi, Murali [mailto:Murali.Ravipudi@gs.com]
Sent: Monday, August 23, 1999 11:50 AM
To: SybPerl Discussion List
Subject: RE: DBlib bcp in/out sample



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 be
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 !! ?? !! ?? 

Murali


> -----Original Message-----
> From:	Charles Zhao [SMTP:charles.zhao-next@attws.com]
> Sent:	Monday, August 23, 1999 1:28 PM
> To:	SybPerl Discussion List
> Subject:	Re: DBlib bcp in/out sample
> 
> I would not suggest using DBLib bcp calls if your data is huge.  If you
> are  
> handling large data set, using direct sybase bcp calls is more efficient.
> An  
> example (bcp in) is:
> 
> $bcpCommand = "$ENV{SYBASE}/bin/bcp $db..$Table in $inFile -f $fmtFile -U
> 
> $user -P $psw -S $DBSERVER -b $batchSize -m $maxNumOfErrors -e $errFile";
> @output = `$bcpCommand`;
> 
> REF:  Sybase utilities manual.
> 
> Points to Know:
> 1.  Failover roll back;
> 2.  If you have bcp v.11, go back use v10. as v11 has a bug.
> 
> Charles Zhao