DB2 UDB for iSeries distributed relational database support

 

The IBM^® DB2^® Query Manager and SQL Development Kit for iSeries™ licensed program supports interactive access to distributed databases.

The DB2 Query Manager and SQL Development Kit for iSeries licensed program 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

 

Parent topic:

Distributed relational database function and SQL

 

Related tasks

Preparing and running a program with SQL statements

 

Related reference

DB2 UDB for iSeries CL command descriptions
CONNECT (Type 1)
CONNECT (Type 2)
DISCONNECT
DROP
GRANT (Package Privileges)
REVOKE (Package Privileges)
RELEASE (Connection)
SET CONNECTION