On Mon, 2002-05-13 at 05:24, Ho, Tony wrote: > Hi guys > I was wondering if you could help me. > I am currently using DBI against a Sybase Database. > Is it possible to execute multiple SQL statements in a given statement > handle ?
Assuming you use DBD::Sybase - then the answer is "yes".
For example (stupid example, but you get the idea):
my $sth = $dbh->prepare("
select * from sysusers
select * from master..syslogins
");
$sth->execute;
do {
while(my $d = $sth->fetch) {
....
}
} while($sth->{syb_more_results});
See perldoc DBD::Sybase for details.
Michael
--
Michael Peppler Data Migrations, Inc.
[EMAIL PROTECTED] *or* [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler
International Sybase User Group: http://www.isug.com
signature.asc
Description: This is a digitally signed message part
