MESSAGE¶
Valid in: DBProc
The MESSAGE statement returns message text and a message number from a database procedure to an application program. The message statement can only be issued from a database procedure.
The MESSAGE statement has the following format:
- message_text
-
Specifies a string literal or a non-null host string variable.
-
Limits: The maximum length is 1500 bytes.
- message_number
-
Specifies an integer literal or a non-null host integer variable.
-
Neither message_text nor message_number can be expressions. The values for these parameters do not correspond to Actian Data Platform error codes or messages; the message statement simply returns the specified values to the receiving application. If the message_number parameter is omitted, Actian Data Platform returns a value of 0.
- WITH DESTINATION
-
Changes the default destination of the message, which is a window at the bottom of the screen. Alternate destinations are as follows:
- ERROR_LOG
-
Directs the output of the message statement to the error log.
-
The message number and text is written to errlog.log with message identifier E_QE0300.
- SESSION
-
Restores the default behavior.
-
To both log and return messages to the application, specify WITH DESTINATION = (SESSION, ERROR_LOG).
To specify an action to be performed when an application receives a message from a database procedure, use the WHENEVER SQLMESSAGE statement. For more information, see WHENEVER.
Permissions¶
This statement is available to all users.