LEVEL2_VIEWRES
Records restrictions for DB level 2.
Column name
|
Data type
|
Description
|
VTABID
|
INT(10)
|
View table identifier. |
SEQNO
|
INT(3)
|
Restriction order number. |
LOGOP
|
CHAR(3)
|
Logical operator ("AND", "OR"). |
BTABID
|
INT(10)
|
Base table identifier. |
BCOLNO
|
INT(3)
|
Base table column number. |
RELOP
|
CHAR(2)
|
Relational operator ("EQ", ...). |
LENGTH
|
INT(5)
|
Length of the value. |
RESVALUE
|
CHAR(64)
|
Restriction value. |
Primary key: VTABID, SEQNO