Creating an e-mail activity template

To create a new e-mail activity, do the following:

WindowsAIXSun Solaris Operating EnvironmentLinux

  1. Log on as the database user
  2. At a command prompt, navigate to the WCinstall_dir/CommerceServer55/bin/.
  3. DB2 Within that directory, at a command prompt, type the following,
    Windows createEmailTemplate.db2 db_namedb_userJSP_pathproperty_file
    template_name "template_description" storeId

    AIXSun Solaris Operating EnvironmentLinux createEmailTemplate.db2.sh db_namedb_userJSP_pathproperty_file
       template_name "template_description" storeId

    Oracle Within that directory, at a command prompt, type the following,

    Windows  createEmailTemplate.oracle db_namedb_userJSP_pathproperty_file
       Template_name "template_description" storeId

    AIXSun Solaris Operating Environment createEmailTemplate.oracle.sh db_namedb_userJSP_pathproperty_file
       template_name "template_description" storeId

    where:

    db_name
    is the name of the commerce database
    db_user
    is the database user name for the specified db_name
    JSP_path
    is the fully qualified URL of the JSP associated with the template on the commerce server
    property_file
    is the property file associated with the template. If there is no property file, specify noTemplate
    template_name
    is the name of the template
    template_description
    is a short description for the template
    storeId
    is the store ID of the target store
  4. DB2 When prompted, enter the user's database password.

iSeries Using the Operations Navigator, or some other comparable method, run the following SQL on your instance:

  1. insert into schemaname.emlmsg 
      (emlmsg_id, jsppath, propertyfile, 
      name, description, storeent_id) 
        select coalesce(max(emlmsg_id), 0) + 1, 
          'JSP_path', 'property_file', 'template_name', 'template_description',
    storeId from emlmsg ;
    

    where:

    schemaname
     is the name of your instance
    JSP_path
     is the fully qualified URL of the JSP associated with the template on the commerce server
    property_file
     is the property file associated with the template. If there is no property file, specify noTemplate
    template_name
     is the name of the template
    template_description
     is a short description for the template
    storeId
     is the store ID of the target store