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