Library /sys$common/syshlp/RDOHELP72.HLB  —  STORE  Format  store-items
  (B)0store-items =

  qwqwq> context-var . field-name qqq> = qqq> value-expr qqwqqqwqqqk
   x mqqqqqqqqqqqqqqqqqqqqqqqq ; <qqqqqqqqqqqqqqqqqqqqqqqqqj   x   x
   mqqq> context-var . * qqqqqqqqqq> = qq> record-descr qqqqqqqj   x
  lqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqj
  mwqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwq>
   tq> GET  qq> host-var q> = qq> context-var qq> . qq> RDB$DB_KEY qu
   mq> PRINT qqqqqqqqqqqqqqqqqqq> context-var qq> . qq> RDB$DB_KEY qj

1  –  field-name

    The name of the field in the relation where the value is stored.

2  –  value-expr

    A valid Oracle Rdb value expression that specifies the value to be
    stored. For more information, request HELP on Value_expr.

3  –  record-descr

    A valid data dictionary record descriptor matching all the fields
    of the relation.

4  –  GET...RDB$DB_KEY

    In an RDBPRE program (BASIC, COBOL, FORTRAN), you can use
    GET...RDB$DB_KEY to retrieve the database key of the record
    about to be stored by the STORE statement into a host language
    variable. Example:

    &RDB&   STORE E IN EMPLOYEES USING E.EMPLOYEE_ID = 15231;
    &RDB&                              E.LAST_NAME = "Smith";
    &RDB&           GET MY_DB_KEY = E.RDB$DB_KEY;
    &RDB&           END_GET
    &RDB&   END_STORE

    (MY_DB_KEY is a user-defined host language variable.)

    (The optional GET...RDB$DB_KEY is available only in programs
    preprocessed by the RDBPRE preprocessor. The optional
    PRINT...RDB$DB_KEY can be used in RDO only.)

5  –  PRINT...RDB$DB_KEY

    In RDO only, you can use PRINT...RDB$DB_KEY to display the
    database key of the record about to be stored by the STORE
    statement. Example:

    RDO> STORE E IN EMPLOYEES USING
    cont>  E.EMPLOYEE_ID = "15231";
    cont>  E.LAST_NAME = "Smith";
    cont>   PRINT E.RDB$DB_KEY
    cont> END_STORE
                RDB$DB_KEY
                  21:339:0
Close Help