You can call stored procedure just like any other statement. Here's a
snipplet:
$sth = $dbh->prepare( 'call myproc(?)' );
$sth->execute( 'parm1' );
while( @row = $sth->fetchrow_array )
{
# do something
}
Regards,
Michael
David Shrewsbury <[EMAIL PROTECTED]> on 01/11/2002 03:52:44 PM
To: [EMAIL PROTECTED]
cc:
Subject: DB2 stored procedures and result sets
Hello gang,
Being rather new to stored procedures, can someone tell
me if it is possible to call a DB2 procedure that
generates a result set and then after the procedure call,
somehow retrieve the rows of the result one at a time via
the DBI interface? Can someone provide some sample DBI code
to show me the basics (if this is even possible)?
TIA,
-Dave