Not sure what you mean exactly, but you can very easily do this
programmatically having all the data in your fetch() and you can loop inside
a loop as many times as you want.
If you mean that when something is returned by a query, you want to loop
through the rows, you easily accomplish this with execute()/fetch* methods.
Sorry if I didn't understand your exact inteded question.
Ilya Sterin
-----Original Message-----
From: Keith E. Junker
To: [EMAIL PROTECTED]
Sent: 05/14/2001 10:04 AM
Subject: Multiple result sets supported in DBI?
Everyone on my project is so thrilled that we can now run Stored
Procedures in our DB2 database using Perl; however, we can't seem to
find the DBI language to pull off something like:
while (result set) {
while (row in result set) {
do something . . .
}
}
which is a usual RDBMS operation on results.
_Programming the Perl DBI_ does not mention multiple result sets. Is
this a tacit admission that such capability is not (yet) a part of DBI?
Did I miss an explicit such admission somewhere?
Keith Junker
