Adaptive Server version 15.7 SP100 introduces batch insert optimization when the insert statement is dynamically prepared and executed as a batch via Open Database Connectivity (ODBC).
Batch insert optimization avoids extra back and forth messages from the client to Adaptive Server when insert...values statements uses dynamic parameters.
ins_by_bulk optimization further enhances batch insert performance by inserting rows in bulk mode internally.
The syntax is:
insert into table values (param_1, param_2, param_3)
Batch inserts also uses data-load optimization when ins_by_bulk is enabled.
For information about how to batch insert, see the Adaptive Server Enterprise ODBC Driver 15.7 Users Guide.