sa_get_server_messages system procedure [deprecated]

Allows you to return constants from the database server messages window as a result set.

This system procedure is deprecated. Use sa_server_messages instead. See sa_server_messages system procedure.

Syntax
sa_get_server_messages( first_line )
Arguments
  • first_line   Use this INTEGER parameter to specify the line number from which to start displaying server messages.

Result set
Column name Data type Description
line_num INTEGER The line number of a server message.
message_text VARCHAR(255) The server message text.
message_time TIMESTAMP The time of the message.
Remarks

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.

Permissions

None

Side effects

None

Example

The following example uses the sa_get_server_messages system procedure to return a result set containing the content of the database server messages window, starting from line 16.

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