A result handler is used to convert a result set contents into an object.
The result set from FETCH (3) is ordered by the ID column and joined using a merge join with index I1 for T1 to get final result set.
Specify a stored procedure that returns a result set after executing.
Group members without Named users queries for members of a group, but removes a set of users from the result set.
It takes a query as input, prepares the query and then describes each column in the output result set.
This no longer works if you use arbitrary tables and fields to specify the from clause or the result clause dynamically, though, because the result set types cannot be determined at programming time.
These last two parameters refer to the date range of event start times to be included in the result set of events.
By entering different customer names and clicking Submit, you can see (Figure 10) that the result set for the Typeahead changes according to which customer the filter is currently set to.
Calling a remote stored procedure with no result set means that the overhead added by federation is limited to name and type mapping between local and remote names and input parameters.
DB2 returns a three-row result set for this query.
When the current position is at a row of the result set, the values of columns in the result set can be obtained by methods that get values.
While all rows in a result set share the same number of columns and column types, different result sets can have different column layouts.
What character set should the server translate to before shipping result sets or error messages back to the client?
If a result set is truncated as a result of applying this limit, or if a result set is truncated because the search would otherwise exceed an operator-specific limit, the result will include the truncated attribute with a value of true.
These result sets are not BIRT data sets, but contain the bound columns from the data container, which are usually retrieved from a data set.
If multiple name values are passed, the match occurs on a logical OR basis within any names supplied (e.g. any match on name/language pairs will cause a registered service to be included in the final result set).
After inequality 7, the result set shrinks.
Selecting one of these links re-sorts the result set by the specified field and direction.
For queries that return a set of user IDs, a union of the results of all queries is created, and builds the result set of user IDs.
criteria: Conditions you specify to limit which records are included in the result set of a query or filter.
In the second set of stored procedures, strings were used in place of arrays, and cursors were heavily used to fetch rows from multi-row result sets.
That's not all you can do, though; YQL also makes it possible to limit the number of records in a result set with both local and remote paging limits.
Thus the estimation for final the result set is one row only (NLJOIN (2)), which matches the real result.
The foreach statement, instead of setting domain attribute values from a SQL result set, stuffs the string TODO: set from SQL result into each element of the array of field values.
This sort is applied prior to any truncation of result sets. Only applicable on queries that return a name element in the topmost detail level of the result set.
This is, of course, impossible in many cases, but there are times where the result set is finite, and in other cases the beginning of the infinite stream of solutions is all you need.
If no arguments are passed, a zero-match result set will be returned.
The caller only receives the rows of the potential result set, for which she has an appropriate work item.
This feature is useful when looking for a particular set of rows, and is much faster and simpler than finding the desired rows by scrolling through the entire result set.
Row or column specified is outside the range of the specified query result set.
This is due to the semantics of SQL: without a WHERE clause, SQL queries do not filter out any rows from the table in the returned result set.
A result set is an array consisting of 0 or more rows that match a database query; a result set identifier is simply a value that you pass to other functions to work with the rows in the result set.
Note that the result set manipulation method works on a 1-based index, unlike the 0-base index of EcmaScript arrays.
Then DB2 opens the cursor returns from the procedure and processes the locator allocation to the result set.
Since these are scalars functions, for each line of the result set, a result of the XML data type is created.
In general, do not write code that relies on the number of result rows from a query because drivers must fetch all rows in a result set to know how many rows the query will return.
Specified result set is outside the range of result sets returned by this query.
Query users can often wait for minutes or even hours, depending upon how much data must be searched in order to produce the result set requested by the user.
