Sybase 12.5.1, User Manual

Page: 59 / 210

CHAPTER 4 Command Reference
User’s Guide
45
If a parameter value contains embedded spaces (such as those in data
items, statistic types, and date-time specifications), you must surround the
value with quotes. Matched pairs of single-quote or double-quotes are
valid delimiters.
If the parameter value contains an embedded quote that is the same as the
character used to delimit the entire value, supply a pair of the quotes within
the parameter value. Historical Server compresses the pair of quotes to a
single character.
The word null within quotes is not a keyword.
You can enter Historical Server commands on multiple lines.
Command status and errors
All Historical Server commands return a status value of either zero or one.
• Zero indicates a successful execution.
• One indicates an error condition. If a status of one ( “1”) is returned,
an error message and its appropriate error code, severity level, and
state are returned to the client.
Historical Server is an Open Server application that uses Client-Library™
to communicate with one or more pairs of Adaptive Server and Monitor
Server. Any of these components may detect and report error conditions.
Historical Server also detects and reports error conditions, which it logs or
reports or both to clients. Historical Server error codes are all five-digit
numbers from 30000 through 30999. Open Server error codes are in the
range between 16000 and 20000. For error codes in either of these ranges,
the Historical Server assigns one of the following severity levels:
Table 4-2: Severity levels in command errors
Severity Description
1 Informational message
2 Warning message
3 Fatal server error
4 Fatal process error
5 Operating system error