Very Computer

I have couple of shell scripts that contain the following line

db2 connect to ${DBNAME}

I need to replace this line with a block of code ( this code is in
another file )

I know I need to do it with sed. But the sed interprets the ${DBNAME}
as an environ variable and looks out for substitution)

Help out!

Thanks.
Arun

sqlplus -s <<EOF 2>&1 > $<filename>.txt

$uid/$pwd

SET SERVEROUTPUT ON

SET HEAD OFF

SET FEEDBACK OFF

WHENEVER SQLERROR EXIT.SQLCODE

BEGIN

   DBMS_OUTPUT.ENABLE(30000)

   COMMIT;

EXCEPTION

  WHEN OTHERS THEN

    DBMS_OUTPUT.PUT_LINE('Change the error message');

    DBMS_OUTPUT.PUT_LINE(SQLCODE||'-'||SQLERRM);

    ROLLBACK;

    RAISE;

END;

/

EXIT;

EOF

plsqlerror=$?

if [ $plsqlerror -ne 0 ]

then

   echo "change the error message"

   TITLE="${HOST}==>ABEND==> Change the error message "

   print "${ENVR}==>${PROG_NAME}==> Change the error message " >>
${LOG_FILE}

   print "ABEND ==>${TITLE}" >> ${LOG_FILE}

   Mail -s "${TITLE}" ${<Give appropriate mailing list>} < ${LOG_FILE}

   Mail -s "${TITLE}" ${<Give appropriate mailing list>} < ${LOG_FILE}

   exit 1

fi

sed -e '/^db2 connect to ${DBNAME}/r file-with-code' \
-e '/^db2 connect to ${DBNAME}/d' inputfile > outputfile

mv outputfile inputfile

If you have a sedscript in a bash script, and you have to use "
instead of ' because there's a variable in the sedscript that you
want sed to read the contents of, you need to escape any $ that
are not referring to the variable like so \$.

sed "\$s/.*/{var}/" ...

Meaning: Go to the last line and switch it for the contents
of $var.

AC