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: "Klein, Shoshana R" <Shoshana dot Klein at gs dot com>
Subject: executing a stored procedure with 2 sql statements and returning the final resultset
Date: Oct 25 2000 12:13AM

Is there a way of executing a stored procedure with 2 sql statements and
only returning the final resultset to my perl script.
For instance, if I want to select * into temp-tbl from sysusers where name
like xyz and then
                                    select  * from temp-tbl where x=myprof
So far I've only been successful with 1 sql statement returning 1 resultset.