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 |
