Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Posts
    11

    Unanswered: Executing DB2 Runstats from perl using DBD

    Is it possible to execute DB2 runstats using perl DBD.?
    I am using Perl DBD module from Activestate on windows NT.

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120

    Re: Executing DB2 Runstats from perl using DBD

    Is it possible to execute DB2 runstats using perl DBD.?
    I am using Perl DBD module from Activestate on windows NT.


    Sure. Use the do method.
    E.g.:

    $dbh->do('runstats on schema.table');

  3. #3
    Join Date
    Jan 2002
    Posts
    11

    Re: Executing DB2 Runstats from perl using DBD

    Originally posted by Bernd Dulfer
    Is it possible to execute DB2 runstats using perl DBD.?
    I am using Perl DBD module from Activestate on windows NT.


    Sure. Use the do method.
    E.g.:

    $dbh->do('runstats on schema.table');
    I tried using the do method
    $dbh->do('runstats on table cidstage.DIM_DATE');
    Got the following error
    DBD:B2::db do failed: [IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token
    "END-OF-STATEMENT" was found following "le cidstage.DIM_DATE". Expected tokens
    may include: "JOIN <joined_table>". SQLSTATE=42601

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •