Create views or materialized views for Interact

Before you create views or materialized views for Interact, verify that the language setting for the computer from where you run the lookup_create SQL script is enabled for UTF-8 encoding. Refer to the following table as a guideline to change the language setting to UTF-8:

1.	Close all open Oracle sessions.

2.	Open the Registry Editor.

3.	Navigate to HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE and open the folder for your Oracle Home, for example, KEY_OraDb10g_home1.

4.	Search for the NLS_LANG setting.

5.	Make sure the last part of the value specified is UTF8. For example: AMERICAN_AMERICA.UTF8.

1.	From the computer that is running the script and has the DB2® client installed, run a DB2® command window. Then run the following command:

2.	In the output, look for the following variable/value pair:

3.	If the DB2CODEPAGE=1208 variable is not set, run the following command:

4.	Close the session window so the change can take effect.

1.	Complete the following steps to create views or materialized views for Interact:

2.	Locate the SQL scripts that you generated and saved previously.

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

When you run a script that creates materialized views on a DB2® database, your database might display the following error:

4.	Locate the tools subdirectory in the reports package installation directory and find the lookup_create script for your database type.

5.	Run the lookup_create script on the Interact design time database. Ensure that the database tool you are using commits the changes. For example, you might need to set the auto-commit option of the database to true.