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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Functions » Alphabetical list of functions

VARIANCE function [Aggregate] Next Page

VAREXISTS function [Miscellaneous]


Returns 1 if a user-defined variable has been created or declared with a given name. Returns 0 if no such variable has been created.

Syntax

VAREXISTS( variable-name-string )

Parameters

variable-name-string    The variable name to be tested, as a string.

See also
Standards and compatibility
Example

The following IF statement creates a variable with a name start_time if one is not already created or declared. The variable can then be used safely.

IF VAREXISTS( 'start_time' ) = 0 THEN
    CREATE VARIABLE start_time TIMESTAMP;
END IF;
SET start_time = current timestamp;