Example: Return the Value of Query Row Limit for Current Session
Assuming the Query_row_limit permission for the current session is 50, the following query returns the value “50” in x:
select x = dbmsinfo('query_row_limit') as x;
Note: The dbmsinfo function allows other request_name values relating to other aspects of the current session. For details, see the chapter “Transactions and Error Handling” in the SQL Reference Guide.