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