in reply to DBI Issue with Sybase 15.5

It's more than a dozen years ago since I last used Sybase, so my remark may be way off, but why are you expecting anything from your showplan_handler? You aren't doing any query, so there's no query plan to be made.

What happens if you add a 

    $dbh->dbcmd("SELECT * FROM SOME_TABLE");
    $dbh->dbsqlexec;

[download]
to your program?

Replies are listed 'Best First'.
Re^2: DBI Issue with Sybase 15.5
by hiyall (Acolyte) on Feb 13, 2012 at 23:38 UTC
    The showplan handler also handles the statistics msgs re: msg 3631 which is the line reporting actual i/o. However, the other statistics msgs are output, just not the one that I want msg 3631. I do execute sql via the program Note the statement: $dbh->dbcmd('sp_who sa'); This is a stored procedure call which contains multiple sql statements. Each sql within the stored procedure will result in a statistics report output due to the "set statistics ..." statement executed earlier in the program. I have tried a different approach which seems to work now ... after I posted this. I will post the rewritten code as a reply. I am still curious why this approach fails to output the msg 3631 text and values.
[reply]
      Are you sure it's a Perl or DBI issue? If you write the equivalent program in C, do you then get the expected callback?
[reply]

In Section Seekers of Perl Wisdom