Version 6.3.12 for OpenVMS SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT
 —  Statements  —

Natural SQL Statements

In addition to the Natural Data Manipulation Language (DML) statements, Natural provides "Natural SQL statements" for use in Natural programs so that SQL can be used directly.

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

CALLDBPROC | COMMIT | DELETE | INSERT | 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, such as FIND or READ, can be used for all database systems supported by Natural.

Top of page

 www.softwareag.com  Copyright © 1984-2012 Software AG, Darmstadt, Germany.   SEARCH   CONTENTS   |   PDF BOOKS   |   HOME   UP   PREV   NEXT