Find out the dataserver’s page size without using global variables like @@pagesize or @@maxpagesize.
When you work with heterogeneous versions of Sybase Ase (12.0.x and 12.5.x or 15.x), this query can help you while coding your dba stored procedures…
declare @page_size int select @page_size = low /1024 from master.dbo.spt_values where type = 'E' and number = 1 go
It will produce the result in Kb. This works with Sybase ASE from version 11.x to 15.x.