In addition to the Natural Data Manipulation Language (DML) statements, Natural provides "Natural SQL statements" for use in Natural programs so that SQL can be used directly.

This part covers the following topics:

Common Set and Extended Set

Basic Syntactical Items

Natural View Concept

Scalar Expressions

Search Conditions

Select Expressions

Flexible SQL

SQL Statements in Alphabetical Order CALLDBPROC | COMMIT | DELETE | INSERT | MERGE | PROCESS SQL | READ RESULT SET | ROLLBACK | SELECT | UPDATE

Note:
Concerning the portability of Natural applications, please bear in mind that the Natural SQL statements can only be used for SQL-compliant database systems, whereas Natural DML statements, such as FIND or READ, can be used for all database systems supported by Natural.