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
|
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.