eXtremeSQL Implementation Details

The eXtremeSQL syntax and detailed information for the following topics are provided in separate pages. Please use the links below to view the individual topics:

Changing the schema	Alter table and other methods for modifying the database schema
Autoid References	Using autoid fields for highly efficient object references
User_Defined_Functions	Implementing eXtremeSQL User-Defined Functions (UDF)
Dynamic Memory Allocation	Managing memory allocation for query execution
Full Outer Joins	Implementing right outer and full outer joins with eXtremeSQL
Asof Joins	Joining tables according to date/time column ranges
Numeric Fields	Considerations for fields if type numeric
DateTime FIelds	Managing date, time and datetime fields
SQL Statements	SQL statement string length limitations
Bitwise Operations	Using AND,OR and NOT to perform bitwise operations
Views	Implementing read-only views
Virtual Tables	Using temporary "virtual" tables for data of a non-permanent nature
RSQL and Security Measures	Remote SQL application implementation, password protection and OpenSSL
Two-Phase Commit	Using the eXtremeSQL Two-Phase Commit