VMS Help  —  SQL72  System Tables, RDB$ROUTINES
    The RDB$ROUTINES system table describes each routine that is part
    of a stored module or a standalone external routine. An external
    routine can either be part of a module or standalone (outside the
    context of a module). The following table provides information on
    the columns of the RDB$ROUTINES system table.

                                Data
    Column Name                 Type      Summary Description

    RDB$ROUTINE_NAME            char(31)  Name of the routine.
    RDB$GENERIC_ROUTINE_NAME    char(31)  Reserved for future use.
    RDB$MODULE_ID               integer   The identifier of the
                                          module that contains this
                                          routine. If routine is
                                          standalone, value is 0.
    RDB$ROUTINE_ID              integer   Unique identifier assigned
                                          to this routine.
    RDB$ROUTINE_VERSION         char(16)  Routine version and
                                          checksum. Allows runtime
                                          validation of the routine
                                          with respect to the
                                          database.
    RDB$PARAMETER_COUNT         integer   The number of parameters
                                          for this routine.
    RDB$MIN_PARAMETER_COUNT     integer   Minimum number of
                                          parameters for this
                                          routine.
    RDB$ROUTINE_BLR             list      The BLR for this routine.
                                of byte   If the routine is external,
                                varying   this column is set to NULL.
    RDB$ROUTINE_SOURCE          list      Source of the routine as
                                of byte   provided by the definer.
                                varying
    RDB$FLAGS                   integer   Flags.
    RDB$SOURCE_LANGUAGE         integer   The RDB$SOURCE_LANGUAGE
                                          section lists the values
                                          for this column.
    RDB$DESCRIPTION             list      Description of the routine.
                                of byte
                                varying
    RDB$ACCESS_CONTROL          list      The access control list
                                of byte   (ACL) to control access to
                                varying   the routine. This value can
                                          be NULL.
    RDB$SECURITY_CLASS          char(20)  Reserved for future use.
    RDB$EXTENSION_PARAMETERS    list      Stores interface
                                of byte   information about the
                                varying   routine. This includes
                                          parameter mappings, the
                                          shareable image name, and
                                          entry point name.
    RDB$TYPE_ID                 integer   Reserved for future use.
    RDB$ROUTINE_OWNER           char(31)  Owner of the routine. This
                                          column is only used when
                                          the routine is standalone
                                          (when RDB$MODULE_ID is
                                          0) otherwise the value is
                                          NULL.
    RDB$CREATED                 date vms  Set when the routine is
                                          created (the same as the
                                          parent module's creation
                                          timestamp).
    RDB$LAST_ALTERED            date vms  Set when the routine is
                                          modified by the ALTER,
                                          RENAME, GRANT, and REVOKE
                                          statements.
    RDB$ROUTINE_CREATOR         char(31)  Creator of this routine.
                                          Differentiates between
                                          AUTHORIZATION and OWNER.
Additional Information: explode extract
RDB$FLAGS RDB$SOURCE_LANGUAGE
Close Help