SQL$HELP72.HLB  —  SET_QUERY, Arguments  EXECUTION_LIMIT
    This option imposes elapsed and CPU time limits on executing
    queries. This command affects all subsequent queries executed
    within the Rdb server process. You must be attached to a database
    to execute this statement. This statement affects all attaches
    for the current process, not just the current connection.

    o  CPU TIME time_value [ SECONDS | MINUTES ]

    o  ELAPSED TIME time_value [ SECONDS | MINUTES ]

    You can restrict the amount of elapsed time or CPU time used to
    execute a query. If the query is not complete before the elapsed
    or CPU time limit is reached, an error message is returned.

    The default is unlimited time for the query execution. If you
    omit the SECONDS and MINUTES keyword then SECONDS is the default.
    Dynamic SQL options are inherited from the compilation qualifier
    for the module.

                                   NOTE

       Specifying a query time limit can cause application failure
       in certain circumstances. For instance, an application that
       runs successfully during off-peak hours may fail when run
       during peak hours due to the load on the database.

    Use a positive integer for the number of seconds or minutes;
    negative integers are invalid and zero means no limits. If an
    established limit is exceeded, the query is canceled and an error
    message is displayed. When you set a CPU time limit, elapsed time
    limit and a row limit (using SET QUERY LIMIT), whichever value is
    reached first stops the query.

    Database administraors and application developers can use
    this feature to prevent users from overloading the system by
    executing long running, and probably unproductive queries. The
    database administrator can manage system performance and reduce
    unnecessary resource usage by setting option limits.
Close Help