Hello all, I've read the DB reference document and see "The AUTOCOMMIT mode is activated (Loader default value)." and "The Loader terminates each sql statement implicitly with a COMMIT."
Now I need to do some sql inside a transaction, commit or rollback together in the end of this transaction. Shall I first use "autocommit off" (because the default is on) before my "subtrans begin" , write all my sql commands till end , commit/rollback , then set "autocommit on" again? Is this the right way to handle autocommit and transaction(subtransaction)? Thanks in advance Tracy Chen
