In addition to the Natural DML statements, Natural also provides SQL statements for use in Natural programs so that SQL can be used directly.
The following SQL statements are available:
CALLDBPROC | COMMIT | DELETE | INSERT | 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, like FIND
or
READ
, can be used for all database systems supported by
Natural.
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 (see the above links) |
The so-called "Flexible SQL", which is a further possibility of issuing SQL statements, allows you to use arbitrary SQL syntax.