This chapter describes the purpose, syntax, and use of each SQL statement. SQL statements that pertain only to distributed databases are not included.
This chapter describes the release of SQL indicated by the following values in the iidbcapabilities catalog:
CAP_CAPABILITY |
CAP_VALUE |
|---|---|
INGRES/SQL_LEVEL |
00850 |
|
|
|
For each statement description in this chapter, the following notation is used:
SQL Indicates the statement can be used in an interactive session.
ESQL Indicates the statement can be used in embedded programs.
DBProc Indicates the statement can be used in a database procedure.
For example:
Valid in: SQL, ESQL
|
|
|
The following statements, which pertain solely to distributed databases, are described in the Ingres Star User Guide:
Certain statements in this guide have additional considerations when used in a distributed environment, which is noted in the statement description.