SQL specific to distributed relational database and SQL CALL
During the precompile process of a distributed DB2 Universal Database™ for iSeries™ application, the i5/OS® licensed program might build SQL packages to be run on an application server (AS).
After the application is compiled, a distributed SQL program and package must be compatible with the systems that are being used as application receivers and application servers. The Preparing distributed relational database programs topic gives you more information about the changes to the precompile process and the addition of SQL packages.
These topics give an overview of the SQL statements that are used with distributed relational database support and some things for you to consider about coexistence with other systems.
- Distributed relational database statements
The statements included with the SQL language specifically support a distributed relational database.
- SQL CALL statement (stored procedures)
The SQL CALL statement is not actually specific to distributed relational databases, but a discussion of it is included here because its main value is in distributing application logic and processing.
- DB2 Universal Database for iSeries coexistence
When you write and maintain programs for a distributed relational database using the SQL language, consider the other systems in the distributed relational database network.
Parent topic:
Programming considerations for a distributed relational database application
Related concepts
Preparing distributed relational database programs
SQL programming
Related reference
SQL reference