Using Natural SQL Statements

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

Overview of Natural SQL Statements:

CALLDBPROC | COMMITDELETEINSERTMERGE | PROCESS SQL | READ RESULT SETROLLBACKSELECT | UPDATE