Creating and populating the eMessage system tables manually

For eMessage, you must create additional system tables in the Campaign schema and then populate the tables with initial data. The Campaign installer automatically creates and populates the eMessage system tables in the Campaign schema if you select the option to create system tables automatically. However, if you do not select the option, you must create and populate the eMessage system tables manually.

Use your database client to run the appropriate script against the Campaign database.

Note: The eMessage installation directory is a subfolder within the Campaign directory.

Scripts for creating eMessage tables

HCL® provides the ace_op_systab scripts for creating eMessage tables in your local environment.

If your Campaign system tables are configured for Unicode, find the appropriate script in the ddl/unicode directory under your eMessage installation.

If your Campaign system tables are not configured for Unicode, use the non-Unicode scripts in the ddl directory under your eMessage installation. Use the following table to see the scripts that you must use:

Table 1. Scripts for creating eMessage tables
Data source type Script name

IBM DB2®

 ace_op_systab_db2.sql

The user tablespace and system temporary tablespace where the system tables reside must each have a page size of 16K or greater.

Microsoft™ SQL Server

 ace_op_systab_sqlsvr.sql

Oracle

 ace_op_systab_ora.sql

Scripts for populating eMessage tables

HCL provides the ace_op_populate_systab scripts for populating the eMessage tables in your local environment.

The populate scripts are stored in the ddl directory of your eMessage installation. HCL provides only one version of the populate scripts because you can use them for either Unicode or non-Unicode tables.
Note: The eMessage installation directory is a subfolder within the Campaign directory.

Use the following table to see the scripts that you must use:

Table 2. Scripts for populating eMessage tables
Data source type Script name

IBM DB2

 ace_op_populate_systab_db2.sql

Microsoft SQL Server

 ace_op_populate_systab_sqlsvr.sql

Oracle

 ace_op_populate_systab_ora.sql