SQL Reference Guide > SQL Reference Guide > Introducing the SQL Reference Guide
Was this helpful?
Introducing the SQL Reference Guide
In This Guide
The SQL Reference Guide provides the following information:
Detailed descriptions of all SQL statements
Examples of the correct use of SQL statements and features
Detailed discussion on performing transactions and handling errors
Detailed descriptions about database procedures, sessions, and events
Audience
This guide is intended for programmers and users who have an understanding of the SQL language, and a basic understanding of Ingres® and relational database systems. In addition, you must have a basic understanding of your operating system. This guide is also intended as a reference for the database administrator.
Enterprise Access Compatibility
If your installation includes one or more Enterprise Access products, check your OpenSQL documentation for information about syntax that differs from the syntax described in this guide. Areas that differ include:
Varchar data type length
Legal row size
Command usage
Name length
Table size
System-specific Text in This Guide
Generally, Ingres operates the same on all systems. When necessary, however, this guide provides information specific to your operating system. For example:
UNIX: Information is specific to the UNIX environment.
VMS: Information is specific to VMS environment.
Windows: Information is specific to the Windows environment.
When necessary for clarity, the symbol is used to indicate the end of system-specific text.
For sections that pertain to one system only, the system is indicated in the section title.
Terminology Used in This Guide
This guide uses the following terminology:
command
A command is an operation that you execute at the operating system level. An extended operation invoked by a command is often referred to as a utility.
statement
A statement is an operation that you embed within a program or execute interactively from a terminal monitor.
Note:  A statement can be written in Ingres 4GL, a host programming language (such as C), or a database query language (SQL or QUEL).
Syntax Conventions Used in This Guide
This guide uses the following conventions to describe command and statement syntax:
Convention
Usage
Monospace
Indicates keywords, symbols, or punctuation that you must enter as shown.
Italics
Represent a variable name for which you must supply a value. This convention is used in explanatory test, as well as syntax.
[ ] brackets
Indicate an optional item.
{ } braces
Indicate an optional item that you can repeat as many times as appropriate.
| (vertical bar)
Indicates a list of mutually exclusive items (that is, you can select only one item from the list).
Last modified date: 01/30/2023