auto commit

[Raju Pillai]

Hi everybody ! I am a db2 guy , now trying to learn Mysql. I just installed 4.1 version and was trying to run one of my perl application (currently running against db2) against Mysql 4.1 . I explicitly issue a COMMIT on my insert program, which mysql seems to hate. I throws a warning, that auto commit is turned on. I have another program which does 2 phase commit, I don't want auto commit turned on.
Is there any way I can turn off auto commit globally or atleast for the application ?
I tired to do
my $sth0 = $dbh->prepare("SET AUTOCOMMIT = 0")|| die "cannot prepare autocommit sql";
$sth0->execute() || die "cannot set autocommit off";

It doesn't seem to do anything.

Any help is appreciated.

TIA