Processing Results to a Database Table

Instead of retrieving data to the Results section, you can instruct Interactive Reporting 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.

  To process results to a database table:

  1. Select Query, then Process Results To Table.

    The Process Results to Database Table dialog box is displayed.

  2. Specify the information requested.

    • Table Name— Name of the new table to be created 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—Appends Request items as new columns in an table.

    • Grant Access To—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.

  3. Click OK.

    The table is created or modified under the specified database and owner name.

  To verify that the query was processed and the results saved as a database table:

  1. Select DataModel, then Table Catalog.

    The Table Catalog expands in the Catalog pane.

  2. Select Refresh on the shortcut menu.

    The table is displayed in the list of database tables.

    Interactive Reporting tracks tables under your database user name and stores a list of these tables in the bqtbls5.ini file.

  To delete tables you created using the Process To Database Table feature:

  1. Select Query, then Process Results To Table.

    The Process Results to Database Table dialog box is displayed. Tables created under your user ID are displayed in the Tables Created By list.

  2. Select a table from the list and click Delete.