Shell Programming and Scripting

sql_file.sql

SELECT *
FROM  DATABASE.TABLE
WHERE EVENT_DT < ${TD_EFFECTIVE_DATE}

#!/bin/ksh

SQL_FILE=$1


#testing

TD_EFFECTIVE_DATE="20130524"

test_var="WHERE EVENT_DT <= ${TD_EFFECTIVE_DATE}"

eval echo "\${test_var}"

#doesn't quite work?

cat ${SQL_FILE} | while read SQL_LINE
do
        if [[ -n `echo ${SQL_LINE} | grep '${'` ]]
then
                eval echo "\${SQL_LINE}"
        fi
done

Output:

WHERE EVENT_DT <= 20130524
WHERE EVENT_DT <= ${TD_EFFECTIVE_DATE}

SELECT *
FROM  DATABASE.TABLE
WHERE EVENT_DT <  #~#

cat <<EOF

SELECT *
FROM  DATABASE.TABLE
WHERE EVENT_DT < ${TD_EFFECTIVE_DATE}

EOF

#!/bin/ksh

TD_EFFECTIVE_DATE="20130524"

while read SQL_LINE
do
       echo "$SQL_LINE"
done << _EOT
SELECT *
FROM  DATABASE.TABLE
WHERE EVENT_DT < ${TD_EFFECTIVE_DATE}
_EOT

sqlcommand << _EOT
...
_EOT