1.
|
Verify that the language setting of the client from which you will run the lookup_create SQL script is UTF-8.
|
2.
|
4.
|
Locate the tools subdirectory in the reports package installation directory and find the lookup_create script for your database type. For example, the script for SQL is named uari_lookup_create_MSSQL.sql, and so on.
|
5.
|
Locate the db/calendar subdirectory in the Marketing Platform installation directory and find the ReportsCalendarPopulate script appropriate for the database type. This script creates two more tables: UA_Calendar and UA_Time.
|
6.
|
|
Either run the script from the command line using the command db2 -td@ -vf ReportsCalendarPopulate_DB2.sql
|
|
Or, if you use the DB2® client interface, change the termination character to the @ character in the Statement termination character field.
|
Copyright IBM Corporation 2012. All Rights Reserved.
|