Limiting Report Rows, SQL Size, and SQL Time-Out: Governing

The table below summarizes the Governing VLDB properties. Additional details about each property, including examples where necessary, are available by clicking on the links in the table.

Property	Description	Possible Values	Default Value
Autocommit	Determines whether a commit statement is automatically issued after each SQL statement for a database connection.	ON OFF	ON
Intermediate Row Limit	The maximum number of rows returned to the server for each intermediate pass. (0 = unlimited number of rows; -1 = use value from higher level.)	User-defined	-1 (Use value from higher level)
Maximum SQL/MDX Size	Maximum size of SQL string accepted by ODBC driver (bytes).	User-defined	65536
Results Set Row Limit	The maximum number of rows returned to the Server for the final result set. (0 = unlimited number of rows; -1 = use value from higher level.)	User-defined	-1 (Use value from higher level)
Limiting Report Rows, SQL Size, and SQL Time-Out: Governing	Single SQL pass time-out in seconds. (0 = time limit not enforced by this governing setting)	User-defined	0 (Time limit not enforced by this governing setting)