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.