Variables

Sybase IQ supports local variables, connection-level variables, and global variables.

All global variables have names beginning with two @ signs. For example, the global variable @@version has a value that is the current version number of the database server. Users cannot define global variables.

• Local Variables
  Local variables are declared by the user, and can be used in procedures or in batches of SQL statements to hold information.
• Connection-Level Variables
  Connection-level variables are declared by the user, and can be used in procedures or in batches of SQL statements to hold information.
• Global Variables
  Global variables are system-supplied variables that provide system-supplied values.