Last updated: 16 July 2008
Errata for 'The Complete Sybase ASE Quick Reference Guide' (4th edition)
 
No book is perfect...
The following typos have been found in the 4th edition of The Complete Sybase ASE Quick Reference Guide (covers ASE 12.0, 12.5.4 & 15.0.1). Errata for other editions are here.

This list can be found at http://www.sypron.nl/qr/errata_ed4.html.




page 16: pageinfo()
The second example uses the attribute 'allocated'. This attribute was renamed to 'page allocated' in ASE 15.0.1. 'allocated' is now an invalid option for pageinfo(), which will always return NULL for invalid options.

page 27: alter table...drop partition
Dropping a specific partition is supported for range- and list-partitioned tables only.

page 36: Query to disply triggers and their status
The first line of the query contains sysstat2 & 1048676. This should be sysstat2 & 1048576.

page 53: example on the last line
The example mentions 'set stored_index off'. This should be 'set store_index off'.

page 60: sp_tempdb, 'add' option', 2nd line from bottom
For sp_tempdb, the 'default' group is still the only group supported in 15.0.1.

page 94: traceflag 7703
This traceflag is supported only in 12.5.0.1 and later.

If you notice any further typos, please send an email to qr@sypron.nl.


 
 This document is located at www.sypron.nl/qr/errata_ed4.html