Stored procedure search function

Net Search Extender provides a stored procedure search for returning predefined result tables. The result table is specified in the cache table section during create index. Use the stored procedure search when you need to return a small number of results in a specific order.

An example would be an Internet application where the first 20 rows are returned, but the rest of the results can also be returned in increments of 20 rows.

Note

The stored procedure function may be used in a distributed DB2 environment only if the user table is stored in a single-node tablespace.

You must also ensure that you connect to the correct node using the DB2NODE environment variable.