-- 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