PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

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