CREATE VARIABLE statement

Defines a variable within the scope of the module and, optionally, initializes the variable to a value.

Syntax

CREATE VARIABLE data_type name [= value] ;

Components
data_type	The CCL data type of the variable.
name	The name of the variable.
value	A literal of the specified type. If omitted, the initial value is Null.

Usage

Another version of this statement is part of the Sybase CEP Function Language, for use is creating user-defined functions. For more information, see Create Variable Statement.

Restrictions

A variable name must be unique to the query module and has scope only within the module.
Variables of a data type that does not permit literal constants cannot be initialized with the Create Variable statement.

Example

CREATE VARIABLE INTEGER message_count = 0;

CREATE VARIABLE statement

Syntax

Usage

Restrictions

See Also

Example