Creating list tables
You must create list tables in your customer database to enable lists in your application. The data in the system tables populates various lists in the Distributed Marketing. Make sure that you store list tables in the same folder as customer tables.
About this task
Create the following tables in your customer database:
- uacc_lists - a list of contacts generated as a List.
- uacc_ondemand_lists - a list of contacts generated by On-demand Campaigns.
- uacc_corporate_lists - a list of contacts generated by a flowchart in a Corporate Campaign.
- uacc_permanent - a list of contacts to be permanently added to or deleted from Lists.
- uacc_ondemand_permanent - a list of contacts to be permanently added to or deleted from On-demand Campaigns.
- uacc_corporate_permanent - a list of contacts to be permanently added to or deleted from Corporate Campaigns.
Important: These tables store the selected contacts
ID of the list and must be created in the same database as the customer
tables.
If you are using DB2 10.5 BLU, you must run the list tables in the user database (enabled with BLU) with the clause Organize by ROW.
Complete the following steps to create list tables: