Configuration Command

Set the message output string.

message [STRING] 

STRING 

A string value representing the text you want displayed as the message output string. If you do not specify a string, the message string is reset to the default ("MESSAGE: ").

Description

Note: This command does not apply to DB/2.

TRANSACT-SQL is an extended SQL implementation that contains control flow constructs and output commands (the print statement). If a print statement is executed directly, or from within a stored procedure, this application prepends the resulting output with the message string. This is so that the application can distinguish this data from other output, such as query results.

When this command is issued, the string is the rest of the command line, including white space, up to the statement terminator. This means the message string can be more than one word. To enter leading spaces or tabs, use the backslash (\) character.

Example

response to start

   start local SQL "eslsqlsy"

   send "message OUTPUT: \n" to SQL

 

response to line "OUTPUT: " from SQL

   add to OutputRegion

      insert input