Navigation:  Advantage SQL > SQL Functionality >

IOTA Table

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

The Advantage SQL engine has a virtual system table named IOTA. The IOTA is a table with one logical (SQL_BIT) column named "iota" and it has a single row in the table with NULL value in the "iota" column. The main purpose of the IOTA table is to provide an efficient method for evaluating an SQL expression on the server. Some sample uses of the IOTA table (note the use of the dot notation to reference the IOTA table in the System catalog):

To get the current date and time on the server:

SELECT Now() FROM System.IOTA

To test how LCASE scalar function transforms a string:

SELECT LCase( 'Sample String' ) FROM System.IOTA

To initialize the random number generator on the server with a new seed value for current user:

SELECT Rand( 2 ) FROM System.IOTA