SQL Statement

Function

specifies any SQL statement.

Format

<sql statement> ::=

<create schema statement>

| <create table statement>

| <create view statement>

| <grant statement>

| <insert statement>

| <update statement>

| <delete statement>

| <query statement>

| <open cursor statement>

| <fetch statement>

| <close statement>

| <single select statement>

| <connect statement>

| <commit statement>

| <rollback statement>

| <release statement>

Syntax Rules

none

General Rules

1. The SQL statements of the 1st block are described in the chapter'Data Definition'.

2. The SQL statements of the 2nd block are described in the chapter 'Authorization'.

3. The SQL statements of the 3rd block are described in the chapter 'Data Manipulation'.

4. The SQL statements of the 4th block are described in the chapter 'Data Retrieval'.

5. The SQL statements of the 5th block are described in the chapter 'Transactions'.

6. All SQL statements can be embedded in programming languages. For a detailed description, refer to the manuals on the precompilers.