cat file with variable substitution

Shell Programming and Scripting
1

MyFile contains:

ALTER TABLE $DBN.$TBN
ADD $COL $TYP COMPRESS ($VAL);

I need to cat the file and have it substitute all of the variables with their contents. cat MyFile does not work. The following works for the first line, but errors on the second line because of the paren:

$ while read L;do eval echo "$L";done<MyFile
ALTER TABLE MyDatabase.MyTable
ksh: syntax error: `(' unexpected

Any suggestions?
No, I cannot remove the parens as they are part of the SQL syntax.
:wall:

2

Make the file this:

cat <<EOF
ALTER TABLE $DBN.$TBN
ADD $COL $TYP COMPRESS ($VAL);
EOF

And then you can get the result you want by

. templatefile
3

OMG! So simple. THANKS!:b: