RDOHELP72.HLB  —  Logical Names, RDMS$BIND_QG_TIMEOUT
    The RDMS$BIND_QG_TIMEOUT logical name is used to set the query
    optimizer elapsed time limit. The elapsed time that the query
    optimizer spends compiling a query can now be limited by defining
    the logical name RDMS$BIND_QG_TIMEOUT and specifying a value
    in seconds. A timer is established which will cause the query
    compilation to be aborted if too much elapsed time has passed.
    This logical name is translated at attach time and supersedes all
    options specified in the application.

    The following DCL command is used to define the RDMS$BIND_QG_
    TIMEOUT logical name and set a value of 120 seconds.

    $ DEFINE RDMS$BIND_QG_TIMEOUT 120

    In this example, the query optimizer will abort the query
    compilation after 120 seconds have elapsed.

    See the RDMS$BIND_QG_REC_LIMIT help topic at this level for
    information on how to limit the number of records delivered
    during query processing.
Close Help