Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX