Report-Writer System Catalogs

The Report-Writer requires the following extended system catalogs:

ii_rcommands
ii_reports

ii_rcommands Catalog

The ii_rcommands catalog contains the formatting, sorting, break, and query commands for each report, broken down into individual commands.

The ii_rcommands catalog is structured as compressed btree unique, keyed on the object_id, rcotype, and rcosequence columns:

Column Name	Data Type	Description
object_id	integer	Unique identifier (object ID) for identifying the report this command belongs to in the ii_objects catalog. Other information about the report (such as name, owner and object class) is stored in the ii_objects catalog.
rcotype	char(2)	Report command type. Valid values are: TA—Table for a .data command. SQ—Piece of SQL query for the .query command. QU—Piece of QUEL query for the query command. SO—Sort column for a .sort command. AC—Report formatting or action command. OU—Output file name, if specified. BR—break command information. DE—declare statement information.
rcosequence	smallint	The sequence number for this row, in the rcotype.
rcosection	varchar(12)	The section of the report, such as header or footer, to which the commands refer if rcotype is AC. If rcotype is QU or SQ, this refers to the part of the query described. For other values of rcotype, this field is unused.
rcoattid	varchar(32)	If rcotype is AC, this indicates either the column name associated with the footer/header section or contains the value PAGE or REPORT or DETAIL. If SO, this is the name of the sort column. If QU, the range variable names are put in this column. If BR, the name of the break column is put in this column. If DE, the name of the declared variable is put in this column.
rcocommand	varchar(12)	Primarily used for the names of the formatting commands when rcotype is AC. Also used by SO rcotype to indicate that the sort column is also a break column.
rcotext	varchar(100)	If the rcotype is AC, this contains the text of the formatting command. If type OU, this contains the name of the output file. If QU or SQ, this contains query text. If TA, this contains the table name. If SO, this contains the sort order. If DE, this contains the text of the declaration. If BR, this is unused.

ii_reports Catalog

The ii_reports catalog contains information about reports. There is one row for every report in the database. Both reports created through RBF and reports created through sreport contain entries in ii_reports. For an example of a query that selects information about reports, see Sample Queries for the Extended System Catalogs for SQL.

The ii_reports table is structured as btree unique on the object_id column:

Column Name	Data Type	Description
object_id	integer	Unique identifier (object ID) for identifying this report in the ii_objects catalog. Other information about the report (such as name, owner, and object class) is stored in the ii_objects catalog.
reptype	char(1)	The method used to create the report; S if the report was created by sreport, and F if the report was created by RBF.
replevel	integer	The release level of the report, shown on the copyrep header (not present in earlier releases). Used internally by Report tools. 0 for earlier releases 1 for the current release The default is 0.
repacount	smallint	The number of rows in the ii_rcommands catalog with an rcotype of AC. This is used for internal consistency.
repscount	smallint	The number of rows in the ii_rcommands catalog with an rcotype of SO. This is used for internal consistency.
repqcount	smallint	The number of rows in the ii_rcommands catalog with an rcotype of QU. This is used for internal consistency.
repbcount	smallint	The number of rows in the ii_rcommands catalog with an rcotype of BR. This is used for internal consistency.