Function of QryRelX
Stores overflow text for the QueryText attribute of the Query table or the TableDDL attribute of the Relation table.
There is at least one row in QryRelX for each row in Query or Relation with an Overflow flag set to T.
QryRelX Table Definition
The following CREATE TABLE request defines the QryRelX table:
CREATE TABLE QryRelX( RowType CHARACTER(1), KeyValue INTEGER NOT NULL, SeqNumber SMALLINT NOT NULL, Text VARCHAR(30000) CHARACTER SET UNICODE NOT CASESPECIFIC NOT NULL) PRIMARY INDEX(RowType, KeyValue);
Attribute Definitions for QryRelX
The following table defines the QryRelX table attributes:
| Attribute | Definition |
|---|---|
| RowType | Defines whether the row handles text overflow from the Query table or from the Relation table.
|
| KeyValue | Defines the implicit primary key for QryRelX rows.
|
| SeqNumber | Specifies whether the current row is the last row in the Overflow. Overflow QueryText or TableDDL text that does not fit into a single row is divided into multiple rows, each with a unique SeqNumber value. The value of SeqNumber begins at 1 and is incremented by 1 for each new text row required. |
| Text | The overflow QueryText or TableDDL text. The upper bound for this text is 30,000 characters per row up to a total of 1 megabyte of overflow SQL query text. |