anchor.diff:  if not exist %tc_target% (
       call:printLog "Transitive Closure File generation is in progress."
       call:printf "\nTransitive Closure File generation is in progress.\n\tPlease wait until this completes.\n\tYou will then need to enter your MySQL password to allow the process to continue."
  -    "!perlpath!" "!loaderFolder!\lib\transitiveClosureRf2SnapMulti.pl" "!tc_source!" "!tc_target!"
  +    "!perlPath!" "!loaderFolder!\lib\transitiveClosureRf2SnapMulti.pl" "!tc_source!" "!tc_target!"
       call:printLog "Transitive Closure File generation completed."
       call:printf "\nTransitive Closure File generation completed."
   )
  
positive.code: set "phReldate=$RELDATE"
  
  :: Establish the location of Perl executables
  call:printf "\nChecking for required software Perl and MySQL Server"
  call:printLog "Checking for required software Perl and MySQL Server"
  set perlpath=""
  call:getFilePath perl.exe perlpath
  :: Report error is no perl.exe is found.
  if "!perlpath!"=="NOT FOUND" (
      call:printLog "Unable to find perl.exe"
      call:printf "\nUnable to find perl.exe - Cannot build transitive closure table file.\n\tPlease install Strawberry Perl (http://strawberryperl.com/) and then retry"
      exit /b 1
  )
  call:printf "\nPERL Processor Found !perlpath!"
  call:printLog "PERL Processor Found !perlpath!"
  :: Establish the location of MySQL Sever executables
  set mysqlPath=""
  call:getFilePath mysql.exe Server mysqlPath
  if "!mysqlPath!"=="NOT FOUND" (
      call:printLog "Unable to find mysql.exe"
      call:printf "\nUnable to find mysql.exe - Cannot import the data.\n\tPlease install MySQL Community Server and Workbench\n\t(https://dev.mysql.com/downloads/mysql/).\n\tThen configure in line with SnomedRfsMySql recommendations\n\tbefore retrying this import process".
      exit /b 1
  )
  call:printf "\nMySQL Path: !mysqlPath!"
  call:printLog "MySQL Path: !mysqlPath!"
  
  :: Get Release Path
  call:printf "\nEnter the full path to the SNOMED CT Release Package folder or zip archive"
  set /P thisRelease="Release folder or zip archive path? "
  
negative.code: ::     %xxxx%   variable hold the replacement text collected from user input
  
  set sedPattern="s/\$DBNAME/%dbname%/g;s/\$RELDATE/%thisReldate%/g;s#\$RELPATH#%thisReleaseSql%#g"
  type %sql_file% | %perlPath% -pe %sedPattern% >"%sql_tmp%"
  
  :: End of MySQL Script generation from template
  
  