Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

CREATE MESSAGE statement [T-SQL]

Creates a message number/message string pair. The message number can be used in PRINT and RAISERROR statements.

Syntax
CREATE MESSAGE message-number AS message-text
message-number : integer
message-text : string
Parameters
  • 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.

Remarks

Adds a user-defined message to the ISYSUSERMESSAGE system table for use by PRINT and RAISERROR statements.

Privileges

You must have the CREATE MESSAGE or CREATE ANY OBJECT system privilege.

Side effects

Automatic commit.

Standards
  • ANSI/ISO SQL Standard

    Not in the standard.

  • Transact-SQL

    CREATE MESSAGE supplies the functionality provided by the sp_addmessage system procedure in Adaptive Server Enterprise.

Example

The following example creates a new message:

CREATE MESSAGE 20000 AS 'End of line reached';