ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_get_server_messages system procedure

Function 

Allows you to return the server's message window as a result set.

Syntax 

sa_get_server_messages ( integer )

Permissions 

None.

Side effects 

None.

Description 

This procedure takes an integer parameter which 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.