Query Editor
Example is a new option added to the Edit menu of the Query Editor. This option is active when a table is selected in the graphical table display. An example type may be one of three choices:
• Self: (Default) The table is an example of a runtime table of the same name. This may include a schema.
• Temporary: the table is an example of a global temporary table. Reporter will automatically refer to the table as session.<tablename>. These tables may be created at runtime by the caller in the same session that the report will be run or may be created as part of Report/Setup using the OpenROAD syntax for declare global temporary table.
To drop a temporary table explicitly, use drop 'session.<tablename>'.
• Parameter: When a table is specified as a parameter you will be prompted to create a variable through the Variable List frame. Variables that are associated with tables are always of type varchar and are report parameters.
Notes:
– A temporary table may be a parameter. In this case define the example type as Parameter and pass the table name as session.<tablename>.
– Parameter tables may not have a schema attached within the Query Editor. If required, pass the schema as part of the tablename.
– In the graphical display area of the Query Editor, tables that are examples of temporary tables are prefixed with (T), and parameter examples with (P).
– Quotes ('') are required around the table name for the drop statement.
– When the example type is parameter, this option is available to view or edit the associated parameter variable.