RE: DBD::Sybase::db do failed: Server message number=2762

From: James Anderson (Jim.Anderson_at_morganstanley.com)
Date: 12/23/04 

Date: Thu, 23 Dec 2004 13:13:43 -0500
To: "Terence J. Young, D.C." <terry.young@mhcdc.org>, <dbi-users@perl.org>

Thanks! That seems to have solved it.

-----Original Message-----
From: Terence J. Young, D.C. [mailto:terry.young@mhcdc.org]
Sent: Thursday, December 23, 2004 1:09 PM
To: Anderson, James (Company IT); dbi-users@perl.org
Subject: Re: DBD::Sybase::db do failed: Server message number=2762

try turning autocommit to 1 (ktrue).

Create Table cannot be done within an implied transaction. I believe
you will alos have to have chained transactions turned off also.

terry

Anderson, James (Company IT) wrote:

>I googled and found a reference to this, but the link was dead :-(
>There no longer appears to be anything in the mail archive.
>
>DBD::Sybase::db do failed: Server message number=2762 severity=16
>state=3 line=1 server=NYTIBA8 text=The 'CREATE TABLE' command is not
>allowed within a multi-statement transaction in the ...
>
>The code is trivial:
>
>-----------------------------------------------------------------------
>-
>------------------------------------
>#!/usr/local/bin/perl5.6
>
>use strict;
>use warnings;
>
>use DBI;
>
>my %create = ( test1 => <<EOD,
>create table test1 (
> user_id numeric(10,0) identity,
> last_name varchar(30) not null,
> first_name varchar(30) not null
>)
>EOD
>);
>
>my %drop = ( test1 => 1 );
>
>my $dbh = DBI->connect( "dbi:Sybase:server=MY_SERVER",
> "user", "password",
> { RaiseError => 1, AutoCommit => 0 } );
>$dbh->do("use my_database");
>
>for (keys %create) {
> print "-------------------\n$create{$_}-------------------\n";
> $dbh->do( $create{$_} );
> $dbh->commit;
> print "created table $_\n";
>}
>
>$dbh->disconnect;
>-----------------------------------------------------------------------
>-
>------------------------------------
>
>Any help appreciated,
>
>jim
>--------------------------------------------------------
>
>NOTICE: If received in error, please destroy and notify sender. Sender
does not waive confidentiality or privilege, and use is prohibited.
>
>
>
>
--------------------------------------------------------
 
NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited.
 

Relevant Pages