Host name change for email template

If you defined email templates in WebSphere Commerce Version 7.0 and changed your host name during the migration, 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'