D.7 HS_FDS_ARRAY_EXEC

HS_FDS_ARRAY_EXEC initialization parameter for Oracle Database Gateway for SQL Server.

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

If set to TRUE, the gateway will use array operations for insert, update, delete statements containing binds against the remote data source. The array size is determined by the value of the HS_FDS_FETCH_ROWS init parameter.

If set to FALSE, the gateway will not use array operations for insert, update, and delete statements. Instead, a single statement will be issued for every value.