Was this helpful?
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.
Last modified date: 01/30/2023