Progress
SQL-92
Guide and Reference


SQL-92 Language Elements

The SQL-92 language has an easy to read, intuitive syntax. A language statement is a complete instruction. A statement can contain one of the following language elements found in Table 1–2.

Table 1–2: Language Elements
Element
Description
Statement
A statement is one complete instruction to Progress.
Identifiers
An identifier is a user-supplied name for a table, view, cursor, or column.
Data types
Data types control how SQL stores information.
Expressions
An expression is a constant, column name, variable name, function or any combination of these and an operator.
Operator
An operator is an element used to manipulate, compare, or test values in an expression.
Query Expressions
Query Expressions retrieve values from tables.
Search Conditions
Search Conditions specify a condition about a given row or group of rows that is true or false.
Literals
Literals are expressions that represent a constant value.
Date-time format strings
Date-time formation strings control the output of date and time values.
Functions
A function performs a discrete task within an expression or statement, usually, returning a value.

Refer to the following chapters for more detail on this information:


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095