Enovia Database

 -- To query a bus with all attributes 
select bt.mxname, bo.lxname, at.mxname, str.lxval
  from mxbustype bt, lxbo_985079cc bo, mxdrvinfo di, mxattrtype at, lxstring_985079cc str
 where bt.mxoid = bo.lxtype
   and bt.mxoid = di.mxtype
   and di.mxobj = at.mxoid
   and str.lxtype = at.mxoid
   and str.lxoid = bo.lxoid
   and bt.mxname = '%MXNAME%'
   and bo.lxname = '%LXNAME%'

 

-- To query a relationship from type and to type
select rt.mxname, di.mxkind, bt.mxname from mxreltype rt, mxdrvinfo di, mxbustype bt
 where rt.mxoid = di.mxtype
   and bt.mxoid = di.mxobj
   and rt.mxname = '%RELNAME%'

 

-- To query all commands of a menu
select cm.mxname
  from mxmenu cm, mxdrvinfo di
 where di.mxobj = cm.mxoid
   and di.mxtype =
       (select mxmenu.mxoid from mxmenu where mxmenu.mxname = '%MENUNAME%')

 

--To query all fields of a form
select * from mxfield fd, mxform fm
 where fd.mxparent = fm.mxoid
   and fm.mxname = '%FORMNAME%

 

--To query all Policies related to a Format
select po.mxname from mxpolinfo pi, mxformat fm, mxpolicy po
 where fm.oid = pi.mxobj
   and po.mxoid = pi.mxpolicy
   and fm.name = 'XML'

 

--To query the range of an attribute
select rl.mxlowval from mxrangelist rl, mxattrtype at
 where rl.mxattr = at.mxoid
   and at.mxname = '%ATTRNAME%'

 

MXADMIN

MXADMINREL

MXAPPLICATION

MXASSIGN

MXATTRTYPE

MXBUSTYPE

MXCHAIN

MXCHAINATTRIBUTE

MXCHANNEL

MXCUE

MXDEFINT

MXDEFREAL

MXDESC

MXDIMENSION

MXDRVINFO

MXEXPRESSION

MXFIELD

MXFORM

MXFORMAT

MXFRAME

MXFUNCTION

MXIADMIN

MXICON

MXINDEX

MXINTERFACE

MXLATTICE

MXLICENSE

MXLINK

MXLINKTYPE

MXLIST

MXLOCATION

MXMAIL

MXMAILRCP

MXMENU

MXNAMEDLONG

MXOID

MXOTHERADMIN

MXPOLICY

MXPOLINFO

MXPORTAL

MXPROGRAM

MXPROPERTY

MXQUERY

MXRANGELIST

MXRELTYPE

MXREPORT

MXREPORTFIELD

MXSCHEMA

MXSERVER

MXSET

MXSETOBJ

MXSIGREQ

MXSRVLAT

MXSTATEREQ

MXSTATEREQUSR

MXSTORE

MXTEMPOID

MXTTABLE

MXUNIT

MXUSER

MXVER6

MXWALLET

MXWEBREPEXT

MXWEBREPORT

MXWEBREPSUM

MXWRGR