Setting limits on size of result sets

[N. Shamsundar]

Is it possible to set a per-user limit on the maximum number of rows
returned by a SELECT statement?

N. Shamsundar
University of Houston

[Mark A]

"N. Shamsundar" <sh******************@nospam.xyz> wrote in message
news:c4***********@masala.cc.uh.edu...

Is it possible to set a per-user limit on the maximum number of rows
returned by a SELECT statement?

N. Shamsundar
University of Houston

Fetch first n rows only.

You can download the SQL Reference at the IBM website.

[N. Shamsundar]

Sorry, I should have made myself more clear. I want the database to
enforce of limit of m rows. If a user asks for "fetch first n rows", and
n <= m, or the table has <= m rows, the query should return min(n,m)
rows. Otherwise, an error message would be issued. I am, perhaps,
looking for a configuration parameter that the DBA can set.

N. Shamsundar
University of Houston

Mark A wrote:

"N. Shamsundar" <sh******************@nospam.xyz> wrote in message
news:c4***********@masala.cc.uh.edu...

Is it possible to set a per-user limit on the maximum number of rows
returned by a SELECT statement?

N. Shamsundar
University of Houston

Fetch first n rows only.

You can download the SQL Reference at the IBM website.

[Blair Adamache]

You could do this using DB2 Query Patroller with its "save" result sets
function.

N. Shamsundar wrote:

Sorry, I should have made myself more clear. I want the database to
enforce of limit of m rows. If a user asks for "fetch first n rows", and
n <= m, or the table has <= m rows, the query should return min(n,m)
rows. Otherwise, an error message would be issued. I am, perhaps,
looking for a configuration parameter that the DBA can set.

N. Shamsundar
University of Houston

Mark A wrote:

"N. Shamsundar" <sh******************@nospam.xyz> wrote in message
news:c4***********@masala.cc.uh.edu...

Is it possible to set a per-user limit on the maximum number of rows
returned by a SELECT statement?

N. Shamsundar
University of Houston

Fetch first n rows only.

You can download the SQL Reference at the IBM website.

[Mark A]

> > Sorry, I should have made myself more clear. I want the database to

enforce of limit of m rows. If a user asks for "fetch first n rows", and
n <= m, or the table has <= m rows, the query should return min(n,m)
rows. Otherwise, an error message would be issued. I am, perhaps,
looking for a configuration parameter that the DBA can set.

N. Shamsundar
University of Houston

Check out the Governor Tool as described in the "Administration Guide:
Performance."