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 peppler dot org>
Subject: Re: DB-Library samples
Date: Mar 6 2001 7:07PM

Warren Pollans writes:
 > Hello,
 > 
 > The sample code (for DB-Library) mentioned in the Programmers Supplement for
 > Unix is not installed on our system.  If it's not proprietary stuff, could
 > someone please point to where it can be found on the net.  I'm actually
 > interested in sample (or real) sybperl code that is more detailed than those
 > found in sybPerl docs - I'd like to do several selects in one query and am
 > interested in the looping, testing, and ordering of calls to dbresults() and
 > dbnextrow().

You can get the sample code in the linux download
(http://linux.sybase.com) (though you'll need rpm to extract the data,
unfortunately).

The short answer, however is this:

$dbh->dbcmd( ... long SQL statement with multiple selects... );
$dbh->dbsqlexec;
while($dbh->dbresults !=- NO_MORE_ROWS) {   # loops once per result set
   while(@d = $dbh->dbnextrow) {
     ...   # once per row (duh!)
   }
}

Michael
-- 
Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org
http://www.mbay.net/~mpeppler - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com