ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-76
Resource Governing Statements
GOV_ATTRIBUTE gov-attribute
specifies one of the following aspects of query execution to apply to gov-action:
LIMIT_VALUE limit-value
specifies an INT(8) number greater than or equal to -1 that specifies the maximum
resource amount to use for a particular query. -1 indicates there is no limit.
ELAPSED_TIME Maximum number of seconds in wall-clock time to wait
for an SQL statement to complete, measured as follows:
•
For an EXECUTE IMMEDIATE statement, the
elapsed time begins when the statement executes
and ends when the statement completes execution.
•
For PREPARE and EXECUTE statements, the
elapsed time begins when the PREPARE statement
executes and ends when the statement completes
execution; it includes the time required for any
DESCRIBE, OPEN, or FETCH statements.
Valid with CONTINUE, COMMIT, ROLLBACK, and
PRIORITY [ ++ | -- ] n governing actions.
ESTIMATED_COST Maximum estimated cost that is acceptable for a query.
Valid with STOP and PRIORITY [ ++ | -- ] n governing
actions.
ROWS_ACCESSED Maximum number of rows to access during a SELECT
statement.
Valid with CONTINUE, COMMIT, ROLLBACK, and
PRIORITY [ ++ | -- ] n governing actions.
ROWS_USED Maximum number of rows to return for a SELECT
statement.
Valid with CONTINUE, COMMIT, ROLLBACK, and
PRIORITY [ ++ | -- ] n governing actions.
EXECUTION_TIME Maximum number of seconds in CPU time to wait for an
SQL statement to complete, measured from the time the
statement is executed.
Valid with CONTINUE, COMMIT, ROLLBACK, and
PRIORITY [ ++ | -- ] n governing actions.