Reference Manual
CHAPTER 9. SQL Statements
To add a user-defined message to the SYSUSERMESSAGES system table for use by PRINT and RAISERROR calls.
CREATE MESSAGE message-num
... AS 'message-text'
Must have resource authority
Automatic commit.
CREATE MESSAGE is provided in Adaptive Server Anywhere as an alternative to the sp_addmessage system procedure used in Adaptive Server Enterprise.
The replaceable text in the syntax is as follows:
message_num The message number of the message to add. The message number for a user-defined message must be 20000 or greater.
message_text The text of the message to add. The maximum length is 255 bytes. PRINT and RAISERROR recognize placeholders in the message text. A single message can contain up to 20 unique placeholders in any order. These placeholders are replaced with the formatted contents of any arguments that follow the message when the text of the message is sent to the client.
The placeholders are numbered to allow reordering of the arguments when translating a message to a language with a different grammatical structure. A placeholder for an argument appears as "%nn!", a percent sign (%), followed by an integer from 1 to 20, followed by an exclamation mark (!). The integer represents the argument number in the string in the argument list. "%1!" is the first argument in the original version, "%2!" is the second argument, and so on.
There is no parameter corresponding to the language argument for sp_addmessage.
SQL/92 Vendor extension.
Sybase The functionality of CREATE MESSAGE is provided by the sp_addmessage procedure in Adaptive Server Enterprise.