In addition to the native Natural DML statements, Natural provides Natural SQL statements for use in Natural programs that maintain data contained in an SQL or SQL-compliant database.
This document describes the special syntax rules and conventions that apply when using Natural SQL statements.
| Common Set and Extended Set |
| Basic Syntactical Items |
| Natural View Concept |
| Scalar Expressions |
| Search Conditions |
| Select Expressions |
| Flexible SQL |
CALLDBPROC | COMMIT | DELETE | INSERT
| MERGE |
PROCESS
SQL | READ
RESULT SET | ROLLBACK | SELECT | UPDATE