The DB2 Basic Toolkit - details

The DB2 Basic Toolkit provides sample programs that demonstrate application programs that use embedded SELECT, INSERT, UPDATE, DELETE, and DECLARE SQL statements.

Here are the functions demonstrated in each language for this Toolkit:

• Embedding SQL statements within a program
  
• Defining DB2 tables within a program
  
• Handling error situations resulting from SQL statements
  
• Structuring programs to reflect transaction-driven processing of DB2 tables
  
• Structuring programs to reflect cursor-driven processing of DB2 tables, including:
  
  • Basic cursors
    
  • Insensitive scrollable cursors
    
  • Sensitive static scrollable cursors
    
  • Sensitive dynamic scrollable cursors
    
  • Cursors that use WITH HOLD
    
  • Cursors that use rowset access
    

Here are the libraries used by the DB2 Basic Toolkit:

• LIBRARY - the central repository, intended to be updated only when you have system changes
• ASM - Assembler source library
• C - C source library
• CNTL - JCL library
• COBOL - COBOL source library
• DBRMLIB - DBRM library
• EXEC - for REXX execs
• LOAD - load module library for the Toolkit owner
• LOADLIB - supplied executables
• PLI - PLI source library
• SQL - SQL source library

The above represent the low level qualifiers of the supplied datasets

Here is information about customization

Here is information about shipping

Related curriculum: DB2 courses.