The skip-tuples parameter specifies the number of query-result-set tuples from the beginning of the query result set that are to be ignored and not to be returned to the caller.
Use this parameter with the threshold parameter to implement paging in a client application, for example, to retrieve the first 20 items, then the next 20 items, and so on. If you specify an order-by clause, a threshold parameter, and a skip-tuples parameter, the tuples that are returned depend on your database system. For example, some database systems apply the sort criteria to all of the records and then return the requested number of tuples. Other database systems first take the requested number of tuples and then apply the sort criteria.
If this parameter is set to null and the threshold parameter is not set, all of the qualifying tuples are returned.
Example of a skip-tuples parameter
Specifies that the first five qualifying tuples are not to be returned.
Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)