optimize_updates

Default: False
Range: True or False

The optimize_updates parameter specifies whether the define or redefine command should set the DSOPT_Use_bi_ai bit (value 1) (in the ds_options column of the DATASETS table) for data sets that have items with OCCURS clauses that are not flattened. The program uses this bit, which you can modify using user scripts, to determine if it should request the DBEngine to send all updates for the data set as BI/AI pairs. The DATABridge Client then compares the before and after images to determine if an update has any effect, and suppresses all redundant updates. Depending on the data, this can greatly increase performance when you do not flatten OCCURS clauses. See the parameter enable_optimized_sql, which allows the user to disable this option without having to run a redefine command.