Shell Programming and Scripting

is there any other way like tht day you teach me using eval
because if some other user edit the template files there, i need they only put variable and not the command line
maybe they add ${BILL_PERIOD} in templete
so this excuteable file they just need to add
BILL_PERIOD=01
something like that
can i do like that,so if we know how to get to new line for that variable i think problem solve..

Code:

$ cat file
DB=abcserv
DB_USERID=ad
DB_PASSWORD=devfl
SYSAPPLID=NTEL
DP_FILE_SYS_ID=Cas
BILLDATEF1=010107
BILLDATEF2=01/01/07

Keep your variables in a separate file and use the following code to create sed command. Make sure that variables in rnmucdr/ednms05/withold_accts/template/FNBDPCF2 are enclosed in braces

Code:

str="sed '"
while IFS="=" read x y
do
 str=${str}"s,\${$x},${y},;"
done < file
str=${str}"' rnmucdr/ednms05/withold_accts/template/FNBDPCF2 >test"
echo ${str} | sh

Hello Everybody,

I dun't know whether you all knew it or not.....

any sqls can be called simply by putting @ once you get inside the sqlplus area. as below,

sqlplus -s $USERID/$PWD@$SCHEMA > $OUTPUTFILENAME << EOF
WHENEVER SQLERROR EXIT 1
@$SCRIPT
EOF

Of coz we knew that...