Sybase Adaptive Server Anywhere - CREATE MESSAGE Statement [T-SQL]

CREATE MESSAGE statement [T-SQL]
452
CREATE MESSAGE statement [T-SQL]
Use this statement to add a user-defined message to the
SYSUSERMESSAGES system table for use by PRINT and RAISERROR
statements.
CREATE MESSAGE message-number
… AS message-text
message-number
: integer
message-text
: string
Must have RESOURCE authority
Automatic commit.
"PRINT statement" on page 581
"RAISERROR statement" on page 584
CREATE MESSAGE associates a message number with a message string.
The message number can be used in PRINT and RAISERROR statements.
To drop a message, see "DROP statement" on page 505.
message_number 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 (!), where the
integer represents the position of the argument in the argument list. "%1!" is
the first argument, "%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.
Function
Syntax
Permissions
Side effects
See also
Description
Parameters
Standards and
compatibility