Skip to main content

ReturnResultsets (Method Keyword)

Specifies whether this method returns result sets (so that ODBC and JDBC clients can retrieve them).

Usage

To specify that the method returns at least one result set, use the following syntax:

ClassMethod name(formal_spec) As returnclass [ ReturnResultsets, SqlName = CustomSets, SqlProc ]  
{    //implementation }

Otherwise, omit this keyword or place the word Not immediately before the keyword.

Details

This keyword specifies that the method returns at least one result set. Set this keyword to true if the method might return one or more result sets. If you do not, then the result sets cannot be retrieved by database drivers, such as JDBC.

For a stored function, either specify Not ReturnResultsets or do not specify this keyword.

Default

If you omit this keyword, result sets cannot be retrieved by database drivers.

See Also

FeedbackOpens in a new tab