Create views or materialized views for Interagir

1.	Verify that the language setting of the client from which you will run the lookup_create SQL script is UTF-8.

For examples of how to do this for Oracle and DB2®, see Setting the language in Oracle and DB2.

2.	Locate the SQL scripts that you generated and saved previously. Refer to Scripts SQL por Origem de Dados if necessary.

3.	Use your database administration tools to run the appropriate script against the appropriate application database(s) for the report package you are configuring.

When you run a script that creates materialized views on a DB2® database, your database may return the error "SQL20059W The materialized query table-name may not be used to optimize the processing of queries." However, the materialized view is successfully created.

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.

Run this script on the the Interagir design time database. Ensure that the database tool you are using commits the changes. For example, you may need to set the database's auto-commit option to true.

5.	Locate the db/calendar subdirectory in the Plataforma de Marketing installation directory and find the ReportsCalendarPopulate script appropriate for the database type. This script creates two more tables: UA_Calendar and UA_Time.

6.	Run this script on the Interagir run time database (InteractRTDS).

For DB2® only, do one of the following:

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.