PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: Sybperl - Help
Date: Sep 25 1997 11:54PM

Naveen_Rajavasireddy@ACML.COM wrote:
> 
> Naveen Rajavasireddy @ ALLIANCE CAPITAL
> 09-25-97 07:32 PM
> 
> Hi,
> I get the following error message
>  < DB-Library error:  Attempt to initiate a new SQL Server operation with
> results pending >
>  in the following code.>
> 
> #!/opt/utils/perl5/bin/perl -w
> 
> use Sybase::DBlib;
> 
> $dbh = new Sybase::DBlib 'abc', 'abc' , 'ABC';
> $rc = $dbh->dbuse("tempdb");
> 
> $rc = $dbh->dbcmd("begin tran NAVIN");
> $rc = $dbh->dbsqlexec;
> $rc = $dbh->dbcmd("insert ntmp values\(\"navin\"\) insert ntmp
> values\(\"raja\")");
> $rc = $dbh->dbsqlexec;
> $rc = $dbh->dbcmd("commit tran NAVIN");
> $rc = $dbh->dbsqlexec;  < Error message occurs here ? >

You should always call dbresults at LEAST once after each call
to dbsqlexec.

Michael
-- 
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler