How to edit a script to include the current pathname and filename - part 2 of 2

I'm tasked with adding a boilerplate header to several hundred existing scripts -- so that all *.sh and *.sql scripts will go forward with its purpose, change history, etc.

Part II:  I humbly ask for the sed/awk syntax that would allow me to:
1.  find a string in the header, such as '/u60/scripts...'
2.  replace that line with the pathname and filename, for example:
     --  /u02/common/scripts/start_backups.sql