c-treeACE SQL Reference Guide

 
Copyright Notice
FairCom Typographical Conventions
SQL Language Elements
c-treeACE SQL Identifiers
Conventional Identifiers
Delimited Identifiers
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
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
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 Scaler 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)
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 Scaler 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
CREATE PROCEDURE
CREATE SEQUENCE
CREATE SYNONYM
CREATE TABLE
Column Constraints
Table Constraints
Storage Attributes
SQL - Create [if not exists] and Drop [if exists]
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 CONNECTION
SET IDENTITY_INSERT
SET TRANSACTION ISOLATION
SET SCHEMA
TRUNCATE TABLE
UPDATE
UPDATE STATISTICS
c-treeACE SQL Reserved Words
c-treeACE SQL Reserved Words
Error Messages
0, 10000 Series
11000 Series - c-treeACE SQL RDS Errors
15000 Series - c-treeACE SQL Flat-File Storage System
160xx - Main Memory Storage System
16000 Series - Latte and Polka Subsystems
c-tree FSS Errors
170xx
171xx
173xx
174xx
175xx
177xx
178xx
179xx
18000 Series
-202xx - Sequence Support
20000 Series - c-treeACE SQL
21000 Series - c-treeDB FSS DB Layer
22000 Series - c-treeDB FSS DB Layer
23000 Series - c-treeACE SQL Data Exceptions
250xx - c-treeACE SQL ODBC Integrator
251xx - c-treeACE SQL ODBC Driver
26000 Series - c-treeACE SQL JDBC Driver
30000 Series - c-treeACE SQL Network
40000 Series - c-treeACE SQL Environment Errors
50000 Series - c-treeACE SQL DHRSS Errors
System Catalog Tables
Overview
System Catalog Tables Definitions
System Limits
Maximum Values for c-treeACE SQL Attributes
Glossary
Index