in reply to Re: SQL Server parser
in thread SQL Server parser

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. 


Replies are listed 'Best First'.
Re^3: SQL Server parser
by adhocusage (Initiate) on Nov 30, 2010 at 01:31 UTC
    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
    
      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.