Front page | perl.dbi.users |
Postings from February 2012
On 02/02/12 21:40, Melillo, Joseph wrote: > Hi, > > I've looked at every resource I can find to try and find this out for > myself, but I couldn't. Therefore, I apologize if this is too simple > a question. If it is, I'd appreciate a pointer to the appropriate > documentation where I can read further. > > Anyway, in Sybase, one can write a store procedure with more than one > select statement in it. As a result, the stored procedure returns > more than one result set (i.e. one per select statement). I'm trying > to handle this in my script (Perl 5.8.8), but the loop terminates > when all the rows of the first result set have been fetched, > indicating that a call needs to be made to go to the next result > set. In ODBC, you'd call the SQLMoreResults API at this point and it would tell you if there was another result-set and you can restart your fetch if there is. > There was a way to handle this in Sybase::DBlib ($dbh->dbresults). > Also, using $dbh->nsql() returned all the result sets in an array of > hashrefs, with the keys of the hashref representing the different > fields of the different result sets, thus eliminating the need to > switch from result set to result set. Even if $sth->fetchall_hashref > in DBI performs similarly to $dbh->nsql() in Sybase::DBlib, I'd > rather fetch my rows one at a time. > > Is there an equivalent of $dbh->dbresults in DBI? Not in DBI itself but there is in some DBDs. DBD::ODBC has odbc_more_results method and DBD::Sybase does it by adding an empty row at the end of the result-set and setting syb_more_results. If you are using DBD::Sybase search for "Handling Multiple Result Sets" in the pod. You haven't said which DBD you are using so it is difficult to say. > Thanks in advance for any help you can give me! > > -Joe Melillo joseph.melillo@moodys.com Martin -- Martin J. Evans Easysoft Limited http://www.easysoft.comThread Previous | Thread Next