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