Was this helpful?
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.
Last modified date: 08/29/2024