Select Code to Download

   ...
   WHERE asof_date = '$test_date'
   ...

   ...
   s/\$test_date/$test_date/g;
   ...

#===============================================#
$ss_source_file   = "C:/code/mla/tmp.sql";
...
   print $trancd_sql{$trcd};
}   
#====================================================#

#=====================================================#
-- tran_code 1752
...
      ... and so on, you get the idea
;      
#==================================================#

SELECT *
   FROM DEV.TRANSACTOPMS
      WHERE TRANSACTION_CD IN ('146','147')
      AND AMT < 0
      AND ASOF_DATE = '30-APR-2011'

SELECT *
   FROM $schema.TRANSACTOPMS
      WHERE TRANSACTION_CD IN ('146','147')
      AND AMT < 0
      AND ASOF_DATE = '$test_date'