November 24, 2010 at 6:16 pm
<pre>
I am following the book "Real World SQL Server
Administration with Perl" by Linchi Shea. He has used
5.6.1 from ActiveState.com; Current / latest version
available is
ActivePerl-5.12.2.1202-MSWin32-x64-293621.msi for 64 bit
and i installed it. perl -v showed the verion correctly.
Many of the simple scripts run but when i try to run one of
the scripts it is giving error regarding ParserSQL.pm; I
invoked ppm and installed all the packages and a search
after installing does not show any P*SQL.pm;
The error i am getting is:
Can't locate SQLDBA/PerseSQL.pm in @INC (@INC contains
C:/Perl64/site/lib C:/Perl64/site/lib C:/Perl64/lib .)
at .\reviewSP.pl line 5.
BEGIN failed--compilation aborted at .\reviewSP.pl line 5.
The first few lines of reviewSP.pl are as follows:
</pre>
<code>
# See the embedded POD or the HTML documentation
use strict;
use Data::Dumper;
use SQLDBA::ParseSQL qw( dbaNormalizeSQL dbaSplitBatch );
Main: {
my $dir = shift or die "***Err: $0 expects a directory name.";
(-d $dir) or die "***Err: directory $dir does not exist.";
# read the file names in the directory
opendir(DIR, $dir) or die "could not open $dir.";
my @fileNames = map { "$dir\\$_" } grep {!/^\.\.?/} readdir(DIR);
closedir(DIR);
my $counterRef;
</code>
I did a search on the harddrive / C:\PERL64 but could not come up with any such pm.
I am newbie to PERL and any help would be appreciated.
Thanks in Advance.
November 24, 2010 at 8:08 pm
Try searching for the SQLDBA::ParseSQL module in the Perl Package Manager
Regards,
Barkha.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply