ppm install SQLDBA-ParseSQL did not work. My bad luck. I will try installing Strawberry perl and see if it will have it. Thanks for the command.
| [reply] |
Strawberryperl won't have it either since it is not distributed on CPAN
| [reply] |
The book says => To verify the installation is correct, do the following :
cmd> perl -e "use File::Copy;"
cmd> perl -e "use Data::Dumper;"
cmd> perl -e "use Win32::ODBC;"
cmd> perl -e "use Getopt::Std;"
All these commands return blank line which means the
installation is correct. They look for Copy.pm in File
subdirectory , Dumper.pm in Data subdirectory etc and the
directory and the perl module (pm) files are indeed
present.
However looking for SQLDBA::ParseSQL gives the following error
cmd> perl -e "use SQLDBA::ParseSQL;"
Can't locate SQLDBA/ParsSQL.pm in @INC
(@INC containts: C:/Perl/site/lib C:/Perl64/lib .) at -e line 1.
BEGIN failed--compilation aborted at -e line 1.
But i am not seeing SQLDBA subdirectory under either
C:\PERL64\lib or C:\PERL64\site\lib; So i created SQLDBA
subdirectory under both the above directories and tried
cmd> ppm install SQLDBA-ParseSQL
It ends up giving me the following message:
Downloading ActiveState Package Repository packlist...done
Updating ActiveState Package Repository database...done
Syncing site PPM database with .packlists...done
ppm instail failed: Can't find any package that provides
SQLDBA-ParseSQL.
Also , i would like to know where to find and edit the
@INC entry. I am working in Windoz and the path should
have backslash (\) and not forward slash (/).
Any suggestions would be welcome.
| [reply] |
Ok. The author mentions the following are the functions exported by the SQLDBA::Utility
dbaReadINI()
dbaReadConfig()
dbaInSet()
dbaSetCommon()
dbaSetDiff()
dbaSetSame()
dbaRemoveDuplicates()
dbaTime2str()
dbaStr2time()
dbaTimeDiff()
dbaStringDiff()
dbaSaveRef()
dbaReadSaveRef()
dbaRunQueryADO()
dbaRunOsql()
dbaGetTree()
I am seeing the code for the functions. How do i arrive at
the .pm file? Do i just concatenate them together or is
there any import module? If so how do i do that?
Thanks
| [reply] |
Ok. I found the solution. The .pm files were present in a
separate folder as part of the download. It took me a while
to figure this one out. Don't understand why it was kept
separately.
Thanks for those who came to my help.
| [reply] |