sybperl-l Archive

From: Dave Waller <dwaller at precisiondrive dot com>
Subject: alter table errors
Date: Jan 20 1999 5:32PM

I am triing to alter a table to add 6 columns.

In that ASE manual they say you can add them at the same time but both
SybPerl and isql won't let me.

Here is what I am triing to do:

$sql_stat = qq{
    alter table $table
     add k5 numeric(15,15) null,
     add d5 numeric(15,15) null,
     add k9 numeric(15,15) null,
     add d9 numeric(15,15) null,
     add k13 numeric(15,15) null,
     add d13 numeric(15,15) null,
     add k21 numeric(15,15) null,
     add d21 numeric(15,15) null
    };
$dbh->dbcmd($sql_stat);
     unless ($dbh->dbsqlexec){
  die "Cannot alter table: statment [$sql_stat] message [
$dbh->DB_ERROR()]\n"
  }
print "table altered\n";

I have only got it working if I do it one column at a time.

Dave Waller