Creating and populating Campaign system tables manually
By default, the Campaign installer automatically creates and populates system tables. However, if the system tables are not created and populated automatically during the installation, you must populate the system tables manually. Use your database client to run the Campaign SQL scripts against the appropriate database to create and populate the Campaign system tables.
If you selected the Campaign System Table DDL Files option on the Campaign Components page during installation, the HCL® installer installs a collection of SQL scripts that you can use to create and populate the Campaign system tables. The SQL scripts are installed in the ddl directory under your installation of the Campaign server. If your system tables are configured for Unicode, the appropriate scripts are in the ddl/unicode directory under your Campaign installation.
To use the SQL scripts, run your database client to apply the scripts to the database or schema that holds the Campaign system tables. See the documentation for your database software for instructions on running SQL scripts.
The following tables list the SQL scripts that are provided for you to use to create and populate the Campaign system tables manually:
Data source type | Script name |
---|---|
IBM DB2® | ac_systab_db2.sql |
Microsoft™ SQL Server | ac_systab_sqlsvr.sql |
Oracle | ac_systab_ora.sql |
Data source type | Script name |
---|---|
IBM DB2 | ac_populate_tables_db2.sql |
Microsoft SQL Server | ac_populate_tables_sqlsvr.sql |
Oracle | ac_populate_tables_ora.sql |
You can create tables in the Campaign schema if you want to integrate Distributed Marketing with Campaign.
The following tables list the SQL scripts that are provided for you to use to create the Campaign system tables manually:
Data source type | Script name |
---|---|
IBM DB2 | clb_systab_db2.sql |
Microsoft SQL Server | clb_systab_sqlsvr.sql |
Oracle | clb_systab_ora.sql |
To populate the rows in the system tables that are created by the clb_systab_DB_type.sql script, run the clb_populate_tables.sql script.