Process Results to Database Table

Use the Process Results to Database Table dialog box to create a table in the database to store your results set. Items on the Request line become the column headings of the new table, and you can append new columns to the table and query it as needed.

Note:

TheInteractive Reporting database connection file and database to which you are connected determine whether you can use this feature. You must have Create and Insert privileges on the database to process results to a database table.

Table 22. Process Results to Database Table

Option	Description
Table Name	The name of the new table you want to create or the name of an existing table to which you want to append columns. You can create tables under your own owner name or under different databases or owners. If you do not have the correct privileges or do not specify an alternate location, the table is created under your own owner name. Use the format DATABASE.OWNER.TABLENAME to specify alternate names.
Create Table	Creates a new table in which Request items form columns.
Append to Table	Append Requests items as new columns in a table.
Grant Access to Table	Enables either everyone or specific users to access the new tables. Type PUBLIC or specific user IDs (separated by commas) for each user who should have access to the table. If not selected, access to the table is filtered to your own user ID.
Tables Created by	Lists tables created by Interactive Reporting under your user account.
Delete Table	Deletes a selected table.