B.22 HS_FDS_RESULTSET_SUPPORT

HS_FDS_RESULTSET_SUPPORT initialization parameter for Oracle Database Gateway for DRDA.

Property	Description
Default Value	FALSE
Range of values	TRUE | FALSE
Syntax	HS_FDS_RESULTSET_SUPPORT = { TRUE | FALSE }

Enables result sets to be returned from stored procedures. By default, all stored procedures do not return a result set to the user.

Note:

If you set this initialization parameter, you must do the following:

• Change the syntax of the procedure execute statement for all existing stored procedures, to handle result sets.
• Work in the sequential mode of Heterogeneous Services.