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