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: Brad Collins <bradc at micromuse dot com>
Subject: Re: A cgi ?
Date: Aug 13 1998 4:56PM


On Thu, 13 Aug 1998, Brad Collins wrote:

> I'm just full of tedious questions this week aren't I? :)
> 
> Anyhow, I've built a handy "History" tool on the web.  It works
> flawlessly
> from one database, it's actually right nifty if I do say so my self :) I
> 
> digress.
> 
> We've created a new database, and I'm trying to run the same reports
> across it to no avail.  I get this:
> 
> Server message:
> Message number: 416, Severity 16, State 1, Line 1
> Message String: Create of work table failed because row size would be
> 2106.  This exceeds the maximum allowable size of a row in a table,
> 2014.
> 
> The difference between the old database and new database (on the same
> dataserver) is one column has increased from a numeric(8) to a
> numeric(24)

s/numeric/char/g :)

> and we have added about 12 columns.
> 
> I wrote another sybperl script that sucks all the data out of the old
> database and builds a huge insert file in the new order.  All the old
> data
> has been successfully populated into the new Database.
> 
> If I do this exact same query sybperl is trying to do from isql it works
> 
> fine, however when I run the script I get the error message above.
> 
> I'll be glad to provide source if its needed!
> 
> Thanks for your help!
> Brad
> Micromuse.
> 
>