Course Description

Course name

COBOL Stored Procedures

Course code

COBSTOR

Audience

Programmers who have coded SQL and need to create simple COBOL Stored Procedures

Prerequisites

Attending the DB2SQL class and familiarity with TSO and COBOL.

Objectives

Upon successful completion, the participant will be able to:

  • review the coding of basic SQL to solve simple business problems.
  • code embedded SQL within COBOL.
  • discuss the steps in getting COBOL with embedded SQL to run in an MVS environment.
  • discuss the insides of the Stored Procedure process, specifically WLM – Workload Manager and Distributed Data Base Architecture or DRDA.
  • discuss some tips for setting up using Stored Procedures at the Aetna.
  • create DB2 COBOL Stored Procedures.
  • create DB2 COBOL Stored Procedures that return a result set.
  • discuss the Company specifics.

Duration

2 Days