Db2 for i distributed relational database support
The IBM® Db2® Query Manager and SQL Development Kit for i licensed program supports interactive access to distributed databases.
Db2 Query Manager and SQL Development Kit for IBM i provides distributed relational database support through the following SQL statements:
- CONNECT
- SET CONNECTION
- DISCONNECT
- RELEASE
- DROP PACKAGE
- GRANT PACKAGE
- REVOKE PACKAGE
Additional support is provided by the development kit through parameters on the SQL precompiler commands:
- Create SQL ILE C Object (CRTSQLCI) command
- Create SQL ILE C++ Object (CRTSQLCPPI) command
- Create SQL COBOL Program (CRTSQLCBL) command
- Create SQL ILE COBOL Object (CRTSQLCBLI) command
- Create SQL PL/I Program (CRTSQLPLI) command
- Create SQL RPG Program (CRTSQLRPG) command
- Create SQL ILE RPG Object (CRTSQLRPGI) command