Characteristics of SQL statements

This appendix contains information on the characteristics of SQL statements pertaining to the various places where they are used.

Actions allowed on SQL statements
Indicates whether an SQL statement can be executed, prepared interactively or dynamically, and whether the statement is processed by the requester, the server, or the precompiler.
SQL statement data access classification for routines
Indicates the level of SQL data access that must be specified to use the SQL statement in a routine.
Considerations for using distributed relational database
This section contains information that may be useful in developing applications that use application servers which are not the same product as their application requesters.

Parent topic: Db2 for i SQL reference