(B)0[m[4mGET[m qwqqqqqqqqq>qqqqqqqqqwqqqqwqqqqqqqq>qqqqqqwqqqk
mq> handle-options qj mq> on-error qqj x
lqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqj
mqwq> get-item qqwqq> [4mEND_GET[m qq>
mqqqqq ; <qqqqqqj
1 – More
If you list a field for which the value is null, and there is
a MISSING_VALUE clause for that field, Oracle Rdb supplies the
missing value. If there is no MISSING_VALUE clause, and nulls are
allowed, then Oracle Rdb supplies zeros for numeric fields, blanks
for text fields, and the OpenVMS base date and time (17-NOV-1858
00:00:00.00) for date fields.
2 – handle-options
(B)0[mhandle-options =
qq> ( qwq> [4mREQUEST_HANDLE[m qqq> var qqqqqqqqqqqqqqqqqqqqqqqqqqqwq> ) qq>
tq> [4mTRANSACTION_HANDLE[m qqq> var qqqqqqqqqqqqqqqqqqqqqqqu
mq> [4mREQUEST_HANDLE[m q> var , [4mTRANSACTION_HANDLE[m q> var qj
2.1 – REQUEST_HANDLE
A keyword followed by a host language variable. A request handle
points to the location of a compiled Oracle Rdb request. If you
do not supply a request handle explicitly, Oracle Rdb associates a
default request handle with the compiled request. Your must use
a request handle when you want to make an identical query to two
different databases.
In Callable RDO, use !VAL as a marker for host language
variables.
You can put parentheses around the host language variable name.
2.2 – TRANSACTION_HANDLE
A keyword followed by a host language variable. A transaction
handle identifies each instance of a transaction. If you do not
declare the transaction handle explicitly, Oracle Rdb attaches an
internal identifier to the transaction.
In Callable RDO, use !VAL as a marker for host language
variables.
You can put parentheses around the host language variable name.
Normally, you do not need to use this argument. The ability to
declare a transaction handle is provided for compatibility with
other database products and future releases of Oracle Rdb.
3 – on-error
(B)0[m[4mON[m [4mERROR[m qwq> statement qwq> [4mEND_ERROR[m
mqqqqqqqq<qqqqqj
on-error
The ON ERROR clause. This clause specifies the action to be taken
if an Oracle Rdb error occurs during the GET operation. Request HELP
for ON_ERROR for more information.
4 – get-item
(B)0[mget-item =
qqqqqqwq> host-variable = value-expr qqqqqqqqqqqqqqqqwqqq>
tq> host-variable = statistical-expr qqqqqqqqqqu
mq> record-descr = context-var . * qqqqqqqqqqqj
Includes an assignment statement specifying a host language
variable and a database value. The value is assigned to the
host language variable from the Oracle Rdb value expression or
statistical expression.
4.1 – host-variable
A valid variable name declared in the host language program. Ask
for HELP on Value_expr for more information.
4.2 – statistical-expr
A statistical expression. A statistical expression calculates
values based on a value expression for every record in a record
stream. Ask for HELP on Value_expr for more information.
4.3 – value-expr
A valid Oracle Rdb value expression. Ask for HELP on Value_expr for
more information.