Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase SQL Server Error

2 posts in Windows NT Last posting was on 1998-04-09 20:11:22.0Z
Sam Khopkar Posted on 1998-04-01 15:52:03.0Z
Message-ID: <352262A3.A418E94D@bcsinc.com>
Date: Wed, 01 Apr 1998 15:52:03 +0000
From: Sam Khopkar <skhopkar@bcsinc.com>
X-Mailer: Mozilla 4.04 [en] (Win95; I)
MIME-Version: 1.0
Subject: Sybase SQL Server Error
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 11
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5081
Article PK: 1092445

Does anyone know how to get around this sybase error

Database error code: 414
Database error message:
Select error. The current query would generate a key size of 456 for a
work table.
This exceeds the maximum allowable limit of 256.

It is a simple select of about 25 columns with 3 order by columns ( sum
of their size 62 )

We are running Sybase System 10 on Windows NT

Any help appreciated

Sam


Bret Halford Posted on 1998-04-09 20:11:22.0Z
Message-ID: <352D2B6A.4F10@sybase.com>
Date: Thu, 09 Apr 1998 14:11:22 -0600
From: Bret Halford <bret@sybase.com>
Organization: Customer Service & Support
X-Mailer: Mozilla 3.0 (X11; U; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Sam Khopkar <skhopkar@bcsinc.com>
Subject: Re: Sybase SQL Server Error
References: <352262A3.A418E94D@bcsinc.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5076
Article PK: 1092440


Sam Khopkar wrote:
>
> Does anyone know how to get around this sybase error
>
> Database error code: 414
> Database error message:
> Select error. The current query would generate a key size of 456 for a
> work table.
> This exceeds the maximum allowable limit of 256.
>
> It is a simple select of about 25 columns with 3 order by columns ( sum
> of their size 62 )
>
> We are running Sybase System 10 on Windows NT
>
> Any help appreciated
>

could you post the create table script for the table
and the query getting the error?

--
Bret Halford Imagine my disappointment
Sybase Technical Support in learning the true nature
3665 Discovery Drive of rec.humor.oracle...
Boulder, CO 80303