Create a Database View Definition

The first step is to create a Lexicon database hierarchy, see Database View Elements and Attributes. Commands used to create, delete and navigate around the Lexicon database elements are exactly the same as those used for any other database type: refer to Introduction for Administrator Command Reference Manual for more details.

A typical Lexicon session could be as follows:

Example

/*

NEW DBVWWLD /ProjectViews

NEW DBVWGROUP /ExampleGroup

NEW DBVW /ExampleVesselDBVW

UDNA 'ExampleVesselView'

ELEL EQUI

DESC 'View that contains only Vessels'

AUTCRE TRUE

NEW ATTFIL /VesselFilter

DBATT DESC

FILTOP 'Equals'

FILTVA 'Vessel'

NEW ATTCOL

DBATT NAME

NEW ATTCOL

DBATT DESC

NEW ATTCOL

DBATT STVVAL

ATQUAL '/EquipmentStatus'

NEW CRERUL

OWNEXP '/Equipment'

TYPEXP |'EQUI'|

NEW SETATT

DBATT NAME

UPROM 'Vessel Tag'

NEW SETATT

DBATT DESC

EXPR |'Vessel'|

Note:
The above example assumes that a status definition called /EquipmentStatus already exists.