Need to understand how Sybase 600 characters limitation works?
Posted on 2006-11-05
Can someone please tell me in layman term how the Sybase 600 characters limitation works?
We are using Sybase ASE 12.5 on one of our project and due to the type of data that we track our data varies, we have records with very little info to it and also records that have lots of info. We have run into some problems where sometimes our reports will run and sometimes we will get an error like: "Sybase 600 characters limitation reached ....". I did some quick research and found that base on settings on the server Sybase has certain limitations, i.e. 600 for 2K page, 31 columns in group by/order by clause, etc.... What I need to understand is how the Sybase engine works in the background after I ran the query? For example: if I have two records in the table:
Record Id Desc
1 50 characters
2 700 characters.
If I run a query to select all from this table does the 600 characters limitation apply because of the second record or it doesn't because the first record only has 50 characters? Also, is there a work around to this problem beside changing the page setting on the server. TIA