The DB2 Basic Toolkit

The DB2 Basic Toolkit provides sample programs, written in Assembler, COBOL, C, and PL/I demonstrating how to access tables using SQL embedded in programs written in these languages.

The services demonstrated in the programs relate to:

• Populating tables using INSERT statements
  
• Modifying existing rows in tables using UPDATE statements
• Removing rows from tables using DELETE statements
• Retrieving single rows from tables using SELECT ... INTO statements
• Retrieving sets of rows from tables using Cursors (DECLARE, OPEN, FETCH, and CLOSE statements)
• Updating rows via Cursors using UPDATE ... WHERE CURRENT OF ... statements
  

In addition, this Toolkit includes:

• JCL and SQL statements to define a data base and table space to hold the Toolkit tables, and establish appropriate privileges to enable table definition and use
• JCL and SQL statements to define the Toolkit tables and supporting indexes
  
• JCL to compile, link, bind (in the DB2 sense), and execute the programs mentioned above
  
• JCL to maintain the Toolkit tables (reorganizing and making backup copies)
  

For more details about the DB2 Basic Toolkit, look on this page

Note: this toolkit requires installation of a Base toolkit.

Related curriculum: DB2 courses.