Step: Load the templates for the Reports SQL Generator
The reports packages for IBM® EMM applications that have reporting schemas contain a SQL script that loads template SQL select statements into the uar_common_sql table. The Reports SQL Generator uses these templates when generating the SQL scripts for creating the reporting views or tables. In this task, you run the script that loads the templates.
1.
Navigate to the schema directory under your report pack installation and locate the templates_sql_load.sql script.
2.
Run the templates_sql_load.sql script in the Plataforma de Marketing database.
Copyright IBM Corporation 2012. All Rights Reserved.