Host name change for e-mail template

If you have defined e-mail templates in WebSphere Commerce Version 5.6.1 or Version 6 and if you have changed your host name during the migration, you must manually modify the EMLMSG.JSPPATH column in the migrated database to reflect the newly defined host name.

Assume that the previous host name is oldhostname.mycompany.com, and the new host name is newhostname.mycompany.com. To reflect the new host name, modify the EMLMSG.JSPPATH column from:
http://oldhostname.mycompany.com/webapp/wcs/stores/servlet/
  EmailTemplateFFSpecialsDisplayView
to:
http://newhostname.mycompany.com/webapp/wcs/stores/servlet/
  EmailTemplateFFSpecialsDisplayView
The following example SQL makes this update:
update EMLMSG 
  set JSPPATH = 'http://newhostname.mycompany.com/webapp/wcs/stores
                 /servlet/EmailTemplateFFSpecialsDisplayView'
 where JSPPATH = 'http://oldhostname.mycompany.com/webapp/wcs/stores
                 /servlet/EmailTemplateFFSpecialsDisplayView'