Library /sys$common/syshlp/SQL$HELP72.HLB  —  INCLUDE  Arguments  FROM_DICTIONARY
    Specifies the path name for a repository record definition.
    Because SQL treats the path name as a string literal, you
    should enclose it in single quotation marks. SQL declares a host
    structure corresponding to the repository record definition and
    gives it the same name. SQL statements embedded in the program
    can then refer to the host structure.

    Typically, programs use the FROM DICTIONARY argument as a
    convenient way to declare host structures that correspond to
    table definitions stored in the repository.

    SQL stores table definitions in the repository in the following
    cases only:

    o  Both the CREATE DATABASE statement and the database
       declaration for the attach in which the table was defined
       specified the PATHNAME argument.

    o  The database definitions were copied to the repository with an
       INTEGRATE statement.

    However, programs can use the FROM DICTIONARY argument to
    declare host structures for any CDD$RECORD repository object
    type, including those repository objects defined as part of the
    database.

    Using the INCLUDE statement does more than using a comparable
    host language statement that inserts a CDD$RECORD object into
    the program. The INCLUDE FROM DICTIONARY statement lets you refer
    to the repository record in an embedded SQL statement, while the
    host language statement does not.
Close Help