Version 4.2.6 for Mainframes
 —  Database Management System Interfaces  —

Natural SQL Statements

This section covers points you have to consider when using Natural SQL statements with DB2. These DB2-specific points partly consist in syntax enhancements which belong to the Extended Set of Natural SQL syntax. The Extended Set is provided in addition to the Common Set to support database-specific features.

This section covers the following topics:

Syntactical Items

CALLDBPROC

COMMIT

DELETE

INSERT

PROCESS SQL

READ RESULT SET

ROLLBACK

SELECT
(cursor-oriented)

SELECT SINGLE
(non-cursor-oriented)

UPDATE

Top of page