Working with the employee resume and photo scenarios

The LOB sample application extends the existing Db2 sample employee database by adding a new table for storing employee resumes and photographs as CLOB and BLOB entries.

About this task

The supporting JCL, application objects, and input data for this table are provided.

The purpose of the LOB sample application is to:

  • Provide an IVP for LOB functions.
  • Demonstrate how to:
    • Use DDL to create LOB objects.
    • Use the Db2 LOAD utility to populate LOB columns of 32K bytes or less.
    • Create an application program to populate LOB columns of greater than 32K bytes.
    • Use LOB locators and related functions to manipulate LOBs without materializing the data.

The LOB sample application consists of a batch portion and an optional online portion. The batch portion verifies that LOB objects can be created, populated, and successfully read by using locators and supporting functions. The online portion demonstrates further techniques for using and manipulating LOB data.

The batch portion of the LOB sample application consists of the following jobs: DSNTEJ7, DSNTEJ71, DSNTEJ73, DSNTEJ75, DSNTEJ76, DSNTEJ77, and DSNTEJ78.

The optional online portion of the LOB sample application adds two additional scenarios to the existing three scenarios that are provided in IVP phase 3. These scenarios include the following user activities:
  1. Invoking the Db2 sample connection manager to display the Db2 ISPF sample application menu, DSN8SSM.
  2. Selecting and viewing sample employee resumes by using option 4 of DSN8SSM.
  3. Selecting and viewing sample employee photo images by using option 5 of DSN8SSM.

Application programs for the LOB sample are written in the C and COBOL languages. The resume viewer requires ISPF. The photo viewer requires ISPF and GDDM.