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: Karsten Spakowski <spacki at pol dot de>
Subject: Re: NUMBER of affected rows
Date: May 10 2001 8:13PM

Thank you for help

Michael Stather wrote:

> Karsten
> A result set may have a number of rows, a cursor may have a number of rows,
> and/or you can specify the number of rows returned in your result set.
> If you really wish to pre-determine the number of rows(programmatically) then
> send the query as a select statement with a count in it (counting the rows), and
> then send the real query...
> Although not efficient and depending on how what your environment is like (OLTP
> vs DSS) you may not always get the exact same results i.e. you do the initial
> select then someone has an update committed prior to your actual query running.
> There are other ways around it too, like evil temp tables, or local/client
> processing, cursors, batches, transactions... It just gets ugly other than the
> local processing.
> There are trade offs every which way you look at it.
> J. Michael Stather
> Michael Peppler wrote:
> > Karsten Spakowski writes:
> >  > Hi folks,
> >  >
> >  > I work with the DBI and DBD Module on a Sybase Server 11.9.
> >  >
> >  > After the execution of an select statement,  I will check the number of
> >  > affected row,
> >  > but I get always the -1.
> >
> > Please read the DBI manual, and also the Sybase OpenClient manual.
> >
> > There is no way for Sybase to know how many rows a select will return
> > without counting them (i.e. without fetching all the rows). So there
> > is no way for DBD::Sybase to tell you how many rows a select query
> > will return - it can only tell you how many rows *were* returned after
> > the query data was completely processed.
> >
> > The number of rows affected will only be significant for
> > insert/update/delete queries.
> >
> > Michael
> > --
> > Michael Peppler - Data Migrations Inc. -
> > -
> > International Sybase User Group -
> > Sybase on Linux mailing list: