Version 6.3.8 for Windows
 —  Statements  —

SQL Statements

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 | COMMITDELETEINSERT | PROCESS SQL | READ RESULT SETROLLBACKSELECT | 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, such as FIND or READ, can be used for all database systems supported by Natural.

This part covers the following topics:

../graphics/gr_b_sm.gif Common Set and Extended Set
../graphics/gr_b_sm.gif Basic Syntactical Items
../graphics/gr_b_sm.gif Natural View Concept
../graphics/gr_b_sm.gif Scalar Expressions
../graphics/gr_b_sm.gif Search Conditions
../graphics/gr_b_sm.gif Select Expressions
../graphics/gr_b_sm.gif Flexible SQL
../graphics/gr_b_sm.gif SQL Statements in Alphabetical Order (see the above links)

The so-called "Flexible SQL", which is a further possibility of issuing SQL statements, enables you to use arbitrary SQL syntax.

Top of page