Product Documentation

SQL Reference Guide

Next Topic

SQL Language Elements

Reference Guide

SQL Reference Guide




SQL configuration, data types, built-in stored procedures, reserved words


© Copyright 2024, FairCom Corporation. All rights reserved. For full information, see the FairCom Copyright Notice.


This chapter describes language elements that are common to many FairCom DB SQL statements. Syntax diagrams in other chapters often refer to these language elements without detailed explanation. The major syntax elements described in the following sections are:

Identifiers - User-supplied names for elements such as tables, views, cursors, and columns. FairCom DB SQL statements use those names to refer to the elements.

Data types - Control how FairCom DB SQL stores column values.

Query expressions - Retrieve values from tables. Query expressions form the basis of other FairCom DB SQL statements and syntax elements.

Search conditions - Specify a condition that is true or false about a given row or group of rows. Query expressions and UPDATE statements specify search conditions to restrict the number of rows in the result table.

Expressions - A symbol or string of symbols used to represent or calculate a single value in a FairCom DB SQL statement. When FairCom DB SQL encounters an expression, it retrieves or calculates the value represented by the expression and uses that value when it executes the statement.

Literals - A type of FairCom DB SQL expression that specify a constant value. Some SQL constructs allow literals but prohibit other forms of expressions.

Date-time format strings - Control the output of date and time values. FairCom DB SQL interprets format strings and replaces them with formatted values.

Functions - A type of FairCom DB SQL expression that returns a value based on the argument supplied. Aggregate functions calculate a single value for a collection of rows in a result table. Scalar functions calculate a value based on another single value.

In This Chapter

FairCom DB SQL Identifiers

Users, Schemas and Roles

Data Types

Search Conditions



Query Expressions

Inner Joins

Outer Joins

Date-Time Format Strings