Database Administrator Guide > Database Administrator Guide > A. System Catalogs > Report-Writer System Catalogs > ii_reports Catalog
Was this helpful?
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: 01/30/2023