I expected to see: msg 3631 (from 12.5.1) Total actual I/O cost for this command: %ld. output somewhere from following code - but it wasn't Any hint on how to get it out? 
#!/usr/bin/perl
    use Sybase::DBlib;
    dbmsghandle(\&showplan_handler);

   # $dbh = DBI->connect(DBI:Sybase:v6_dba_test_nj2x, 'user', 'pw');
    $dbh = new Sybase::DBlib 'user','password';

    $dbh->dbsetopt(DBSHOWPLAN);
    $dbh->dbsetopt(DBSTAT, "IO");
    $dbh->dbsetopt(DBSTAT, "TIME");

    $dbh->dbcmd('use myDB');
    $dbh->dbsqlexec;
    $dbh->dbcmd('set statistics io,time,subquerycache on');
    $dbh->dbsqlexec;
    $dbh->dbcmd('sp_who sa');
    $dbh->dbsqlexec;
    while($dbh->dbresults != NO_MORE_RESULTS) {
        while(@dat = $dbh->dbnextrow) {
            print "@dat\n";
        }
    }
    # Message number 3612-3631 are statistics time / statistics io
    # message. Showplan messages are numbered 6201-6225.
    # (I hope I haven't forgotten any...)
    @sh_msgs = (3612 .. 4043, 6201 .. 6225);
    @showplan_msg{@sh_msgs} = (1) x scalar(@sh_msgs);

    sub showplan_handler {
        my ($db, $message, $state, $severity, $text,
            $server, $procedure, $line) = @_;

        # Don't display 'informational' messages:
        if ($severity > 0) {
            print STDERR ("Sybase message ", $message, ",
               Severity ", $severity, ", state ", $state);
            print STDERR ("\nServer `", $server, "'") if defined ($ser
+ver);
            print STDERR ("\nProcedure `", $procedure, "'")
                  if defined ($procedure);
            print STDERR ("\nLine ", $line) if defined ($line);
            print STDERR ("\n    ", $text, "\n\n");
        }
        elsif($showplan_msg{$message}) {
        # This is a SHOWPLAN or STATISTICS message, so print it out:
            print STDERR ($text, "\n");
        }
        elsif ($message == 0) {
            print STDERR ($text, "\n");
        }

        0;
    }

[download]

In reply to DBI Issue with Sybase 15.5 by hiyall

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.