Last updated: 13 June 2013
Errata for 'The Complete Sybase ASE Quick Reference Guide' (6th edition)
No book is perfect...
The following typos have been found in the 6th edition of The Complete Sybase ASE Quick Reference Guide (covers ASE 15.0, 15.5 & 15.7 ESD#3). Errata for other editions are here.

This list can be found at

page 14: Date/time formatting for styles 117 & 118
(not an erratum but a clarification)
From ASE versions 15.0 until 15.5 GA, the formatting styles 117 and 118 resulted in a format with year/month/date included, and the 5th edition of my ASE quickref did indicate this behaviour correctly. However, it appeared later that these styles had been incorrectly implemented in 15.0, and this was corrected in 15.5 ESD#1 and later (as well as in recent versions of 15.0.3, e.g. 15.0.3 ESD#4.1). As of those versions, only the time portion is included in the format, as described in the 6th edition of the ASE quickref guide.

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

page 78: sp_password
The last line ends in (default=). This should be(default=0).

page 99: 'enable monitoring' configuration parameter
The values for enabling/disabling are interchanged. The correct values are: to enable, set to 1, to disable, set to 0 (=default).

If you notice any typos, please send an email to

 This document is located at