Is there a way to append both at header and footer of a file

currently I've a file

Insert into CD_CARD_TYPE
   (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE)
 Values
   ('024', '024', 2, sysdate);
Insert into CD_CARD_TYPE
   (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE)
 Values
   ('032', '032', 2, sysdate);
........

is it possible to add the following such that output will become as follow:

prompt loading CD_CARD_TYPE
Insert into CD_CARD_TYPE
   (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE)
 Values
   ('024', '024', 2, sysdate);
Insert into CD_CARD_TYPE
   (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE)
 Values
   ('032', '032', 2, sysdate);
........
prompt done loading

understand that we can append anything to the footer of a file by doing the following

echo "prompt done loading" > filename.txt but how about appending the header?

thanks a lot!

Try this for header.

sed '1i\
your text' file_name

If you do that, your filename.txt will be gone. Use >> for appending.
Put header in a headerfile and then cat headerfile filename.txt

Try this

sed '1i\
header
$a\
footer' filename