If so,how can I turn off it.
By default, SAP IQ does not auto commit transactions.
auto_commit Option
This option can only be set temporarily for the current connection. To set the option you need to use a SET OPTION statement:
SET OPTION Statement
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.