(B)0[m[4mDEFINE[m [4mVIEW[m qqq> name qqqqqk
lqqqqqqqqqqq<qqqqqqqqqj
mqqqwqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqwqqqqqk
mqq> [4mDESCRIPTION[m IS /* text */ qqqj x
lqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqj
mqq> [4mOF[m qqq> rse qqqq> . qqqqqqqk
lqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqj
mqwqwqqqqqqqqqqqqqqqqqqqwqqqqq> name-clause qqq> . qwqk
x mqq> /* text */ qqqqj x x
mqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqq> [4mEND[m qqqqwqqqqq>qqqqqqwqqq> VIEW qqqq> .
mqq> name qqqj
1 – name
Name of the view definition you want to create. When choosing a
name, follow these rules:
o Use a name that is unique among all view and relation names in
the database.
o Use any valid OpenVMS name. However, the name cannot end in a
dollar sign ($) or underscore (_).
o Do not use any Oracle Rdb reserved words.
2 – rse
A record selection expression that defines which rows of which
relations Oracle Rdb includes in the view. Ask for HELP on RSE for a
complete description of record selection expressions.
3 – name-clause
Specifies a field that you want to include in the view.
(B)0[mname-clause =
qqwqqq> context-var . field-name qqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqwqk
tqqq> local-field-name qq> [4mFROM[m qq> context-var . field-name qqu x
mqqq> local-field-name qq> [4mCOMPUTED[m [4mBY[m qqqq> value-expr qqqqqqqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqqwqqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqqqqq>
mwq> dtr-clause qqqqwqj
mqqqqqqq<qqqqqqqqqqj