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.
$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