Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - - 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.

SQL Advantage display only 32760 records

2 posts in Windows NT Last posting was on 2000-11-07 02:04:37.0Z
Wulin Yen Posted on 2000-10-27 16:36:06.0Z
From: "Wulin Yen" <>
Subject: SQL Advantage display only 32760 records
Date: Fri, 27 Oct 2000 08:36:06 -0800
Lines: 11
Organization: Municipality of Anchorage
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Message-ID: <>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!!
Xref: forums-1-dub sybase.public.sqlserver.nt:1547
Article PK: 1089025

Hi All,
I am running Sybase 11.9.2 on NT. The SQL Advantage is and it only
displays 32760 retrieved records while the table has 59449 records. Could
anyone tell me why and how to see the rest of the records from SQL

Thanks in advance.

Anonymous Posted on 2000-11-07 02:04:37.0Z
Date: Mon, 6 Nov 2000 21:04:37 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: SQL Advantage display only 32760 records
Message-ID: <30F0CCF71A87D9EC000B68DD85256990.00603E9E85256985@webforums>
References: <>
Lines: 2
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!!!!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1514
Article PK: 1089001

Try setting the results option to maximum in the
or "session" setting.