Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_get_request_times system procedure Next Page

sa_get_server_messages system procedure

Allows you to return constants from the Server Messages window as a result set.


sa_get_server_messages( first_line )

Result set
Column nameData typeDescription
line_numINTEGERThe line number of a server message.
message_textVARCHAR(255)The server message text.
message_timeTIMESTAMPThe time of the message.

This procedure takes an INTEGER parameter that specifies the starting line number to display, and returns a row for that line and for all subsequent lines. If the starting line is negative, the result set starts at the first available line. The result set includes the line number, message text, and message time.



Side effects



The following example uses the sa_get_server_messages system procedure to return a result set containing the content of the Server Messages window starting on line 16.

CALL sa_get_server_messages(16);
line_num message_text...
16 Running on Windows 2000 Build 2195......
172132K of memory used for caching...