SQL Reference Guide

SQL Language Elements FairCom DB SQL Identifiers Conventional Identifiers Delimited Identifiers Users, Schemas and Roles Creating and Modifying Users and Groups Database Names and Filesystem Names Data Types Character Data Types Exact Numeric Data Types Approximate Numeric Data Types Date-Time Data Types Bit String Data Types Search Conditions Logical Operators: OR, AND, NOT Relational Operators Basic Predicate Quantified Predicate BETWEEN Predicate NULL Predicate LIKE Predicate CONTAINS Predicate EXISTS Predicate IN Predicate Outer Join Predicate Full Text Predicate Expressions Concatenated Character Expressions Numeric Arithmetic Expressions Date Arithmetic Expressions Conditional Expressions Scalar Sub-query Expressions Escape field name matching reserved words in c-tree expressions Literals Numeric Literals Character String Literals Date-Time Literals Date Literals Time Literals Timestamp Literals Query Expressions Cross Database Query Common Table Expressions (CTE) and Recursive Queries Table Valued Functions Inner Joins Outer Joins Date-Time Format Strings Date Format Strings Time Format Strings Functions Aggregate Functions AVG COUNT COUNT_BIG MAX MIN SUM Scalar Functions ABS function (ODBC compatible) ACOS function (ODBC compatible) ADD_MONTHS function (extension) ASCII function (ODBC compatible) ASIN function (ODBC compatible) ATAN function (ODBC compatible) ATAN2 function (ODBC compatible) CASE (SQL-92 Compatible) CAST function (SQL-92 compatible) CEILING function (ODBC compatible) CHAR function (ODBC compatible) CHARTOROWID (extension) CHR function (extension) COALESCE (SQL-92 compatible) CONCAT function (ODBC compatible) CONVERT function (extension) CONVERT function (ODBC compatible) COS function (ODBC compatible) COT SQL Scalar Function CURDATE function (ODBC compatible) CURRENT_DATE SQL function CURRENT_TIMESTAMP function CURRENT_USER SQL Function CURTIME function (ODBC compatible) DATABASE (ODBC compatible) DATALENGTH function DATEADD function DATEDIFF function DAYNAME function (ODBC compatible) DAYOFMONTH function (ODBC compatible) DAYOFWEEK function (ODBC compatible) DAYOFYEAR function (ODBC compatible) DB_NAME (extension) DECODE function (extension) DEGREES function (ODBC compatible) DIFFERENCE function (ODBC compatible) EXP function (ODBC compatible) EXTRACT SQL Function FLOOR function (ODBC compatible) GETDATE function (ODBC compatible) GREATEST function (extension) HOUR function (ODBC compatible) IFNULL function (ODBC compatible) INITCAP function (extension) INSERT function (ODBC compatible) INSTR function (extension) ISNULL function ISNUMERIC function LAST_DAY function (extension) LAST_IDENT function (extension) LAST_ROWID function LCASE function (ODBC compatible) LEAST function (extension) LEFT function (ODBC compatible) LEN function (ODBC compatible) LENGTH function (ODBC compatible) LOCATE function (ODBC compatible) LOCALTIME SQL Function LOCALTIMESTAMP SQL Function LOG SQL Scalar Function LOG10 function (ODBC compatible) LOWER function (SQL-92 compatible) LPAD function (extension) LTRIM function (ODBC compatible) MINUTE function (ODBC compatible) MOD function (ODBC compatible) MONTHNAME function (ODBC compatible) MONTH function (ODBC compatible) MONTHS_BETWEEN function (extension) NEXT_DAY function (extension) NOW function (ODBC compatible) NULLIF (SQL-92 compatible) NVL function (extension) OBJECT_ID function (extension) OCTET_LENGTH SQL Function OVERLAY SQL Function PI function (ODBC compatible) POSITION SQL Function POWER function (ODBC compatible) PREFIX function (extension) QUARTER function (ODBC compatible) RADIANS function (ODBC compatible) RAND function (ODBC compatible) REPEAT function (ODBC compatible) REPLACE function (ODBC compatible) RIGHT function (ODBC compatible) ROUND function ROWID (extension) ROWIDTOCHAR (extension) RPAD function (extension) RTRIM function (ODBC compatible) SECOND function (ODBC compatible) SESSION_USER SQL Function SIGN function (ODBC compatible) SIN function (ODBC compatible) SOUNDEX function (ODBC compatible) SPACE function (ODBC compatible) SQRT function (ODBC compatible) SUBSTR function (extension) SUBSTRING SQL Function (SQL-99 compatible) SUBSTRING function (ODBC compatible) SUFFIX function (extension) SUSER_NAME function (extension) SYSDATE function (extension) SYSTIME function (extension) SYSTIMESTAMP function (extension) TAN function (ODBC compatible) TIMESTAMPADD function (ODBC compatible) TIMESTAMPDIFF function (ODBC compatible) TO_CHAR function (extension) TO_DATE function (extension) TO_NUMBER function (extension) TO_TIME function (extension) TO_TIMESTAMP function (extension) TRANSLATE function (extension) TRIM SQL Function TRUNCATE function UCASE function (ODBC compatible) UPPER function (SQL-92 compatible) USER function (ODBC compatible) USER_NAME function (extension) WEEK function (ODBC compatible) YEAR function (ODBC compatible) SQL Statements Syntax Conventions ALTER INDEX ALTER SEQUENCE ALTER TABLE ALTER VIEW CALL COMMIT WORK CONNECT CREATE FUNCTION CREATE INDEX SQL full-text search examples using PORTER English stemming tokenizer SQL full-text search examples using SIMPLE tokenizer CREATE SEQUENCE Sequence Values CREATE PROCEDURE CREATE SYNONYM CREATE TABLE Column Constraints Table Constraints Storage Attributes SQL - Create [if not exists] and Drop [if exists] Assign Values to Auto-Increment Fields in INSERT CREATE TRIGGER CREATE VIEW DELETE DISCONNECT DROP FUNCTION DROP INDEX DROP PROCEDURE DROP SEQUENCE DROP SYNONYM DROP TABLE DROP TRIGGER DROP VIEW EXPLAIN PLAN GET DIAGNOSTICS GRANT INSERT LOCK TABLE ORDER BY RENAME REVOKE ROLLBACK WORK SELECT SET IDENTITY_INSERT SET TRANSACTION ISOLATION SET SCHEMA TRUNCATE TABLE UPDATE UPDATE STATISTICS FairCom DB SQL Built-in Stored Procedures fc_add_db( ) fc_check_file_tran_state( ) fc_create_db( ) fc_create_user( ) fc_get_cachestats() fc_get_connstats() fc_get_dblist( ) fc_get_fcproclist( ) fc_get_filestats() fc_get_hosttablename() fc_get_iostats() fc_get_isamstats() fc_get_lockstats() fc_get_memstats() fc_get_min_card( ) fc_get_priority( ) fc_get_partbounds() fc_get_replstats() fc_get_selectivity( ) fc_get_server_version( ) fc_get_sqlstats() fc_get_sysconfig() fc_get_taskid( ) fc_get_transtats() fc_get_userlist( ) fc_ptadmin_num() fc_purge_db() fc_set_blockinglock( ) fc_set_debug( ) fc_set_file_tran_state( ) fc_set_impersonation( ) fc_set_min_card( ) fc_set_nodename( ) fc_set_priority( ) fc_set_rowid_visible() fc_set_selectivity( ) fc_set_sysconfig() FairCom DB SQL Reserved Words SQL Error Messages System Catalog Tables System Catalog Tables Definitions System Limits Glossary FairCom Typographical Conventions Copyright Notice Index