Know Db2

Structured COBOL Advanced

This hands-on workshop trains the Db2 Query User, Application Developer and DBA to code complex SQL statements in a COBOL program to achieve optimum performance.

Duration: 3 Day Hands of Instructor led hands - on Labs.

Labs: Db2 and COBOL.

Audience: Anyone who will be coding SQL queries and is concerned with optimun performance using Db2 SQL in COBOL programs, including end-users, programmers, application designers and database administrators.

Prerequisites: Basic COBOL experience, background using an editor, job submission and looking at the output, basic TSO/ISPF skills.

COBOL Application Programming Class Outline:

COBOL program compile, link-edit
and execute on the Mainframe

  • A general procedure for developing
      a COBOL program on a mainframe
  • Libraries and JCL sturcture for running
     a compile and link-edit
  • How to create a source program using ISPF
  • Using ISPF to setup our JCL
      for compile and program execution
  • Lab: Working with ISPF libraries
  •  

Review of basic skills for working with ISPF

  • How to create apartitioned data set
  • How to workd in the edit data display
  • How to use line commands and primary commands
  • How to terminate an edit session
  • How to compile, link-edit, and excute a program
  • Introduction to jobs and Job Control Language
  • Lab: Using ISPF to setup our COBOL program
  • Review
  •  

The cataloged procedures for
COBOL program development

  • How to use the compile-link-and-go procedure
  • How to execute an existing program
  • How to create a sequential data set
  • How to use SDSF to work with jobs and job output
  • Basic skills for working with SDSF
  • Lab: Creating a sequential data set, using link and go
  •  

How to work with jobs using files

  • File organization concepts
  • Sequential file organization
  • Indexed file organization
  • Indexed file organization with alternate indexes
  • Relative file organization
  • VSAM file organization
  • Lab: Working with files
  •  

z/OS File Organization Concepts

  • Sequential file organization
  • Indexed file organization
  • Indexed file organization with alternate indexes
  • Relative file organization
  • VSAM file organization
  • Lab: Working and allocating files
  •  

Programs that work with disk files

  • Interactive programs
  • Batch programs
  • Concepts and terms for working with disk files,
      disk concepts and terms
  • How data is stored on a disk drive
  • How the data in a sector is read or written to disk
  • Blocked versus unblocked records
  • Fixed-length versus variable-length records
  • File organization concepts
  • Lab: Working with fixed length
      and variable length records
  •  

Sequential file organization

  • Indexed file organization
  • Indexed file organization with alternate indexes
  • Relative file organization
  • VSAM file organization
  • Lab: Working with sequential files
  •  

Typical programs that work with disk files

  • Interactive programs verses Batch programs
  • How to work with sequential files COBOL
      for fixed-length records
  • Coding Select and FD statements
  • Coding Procedure Division statements
  • How to work with file status codes
  • Lab: Writing COBOL program
      to work with file status codes
  •  

Writing a sequential update program

  • The program specifications
  • The test data and matching record logic
  • Writing COBOL code
  • Working with a sequential maintenance program
  • Lab: Using matchin record logic
  •  
  •  

Special consideration for sequential update
and maintenance programs

  • Error processing for I/O operations
  • Testing and debugging
  • Lab: Using matching record logic
  •  

Design alternatives

  • How to write to a file that contains record types
      with different lenghts
  • How to process a file that contains record types
      with different lenghts
  • How to write records
      with a varying number of segments
  • How to process records
      with varying number of segments
  • How to work with indexed files COBOL for indexed files
  • How to code Select statements
  • Lab: Using indexed files
  •  

File Status codes

  • How to code the Open, Close, Read, Write
      and Rewrite statements
  • How to code the Start statement
  • How to code the Delete statement
  • A sequential file creation program
  • The program specifications
  • The structure chart
  • The COBOL code
  • Lab: Working with file status codes
  •  

Maintenance Programming

  • The program specifications
  • The structure chart
  • The COBOL code
  • How to work with alternate indexes
  • How to code Select statements
  • How to code Start and Read statements
  • How to process an alternate index sequentially
  • How to process an alternate index randomly
  • Lab: Working with alternate indexes
  •  

Other Processing Techniques

  • How to use dynamic processing
  • How to use the skip-sequential processing
  • How to work with relative file COBOL for relative files
  • How to code Select statements
  • How to code I/O statements
  • How to process relative files
  • Sequential processing
  • Random processing
  • Lab: Skip-sequential processing
  •  

How to use Db2 for z/OS
and develop COBOL programs

  • Relational database organization
  • How the tables in a relational database are related
  • How to use SQL to work with a Db2 Database
  • Lab: Using SPUFI and SQL
  •  

COBOL
and Structured Query Language Review

  • How to retrieve data from a single table
  • How to join data from two or more tables
  • How to create and work with
      result tables using embedded SQL
  • Lab: Working with joining data in a COBOL program
  •  

Writing, Compiling and Executing
a Db2 COBOL Program

  • DCLGEN output
  • How we compile, link-edit, BIND
      and Execute a COBOL Db2 program
  • Lab: Building our DCLGEN and using it in a program
  •  

The Structure of a Db2 COBOL Program

  • The COBOL listing
  • Writing a COBOL program that accesses Db2 Data
  • Lab: Compiling and Executing our COBOL Db2 program
  • Code Review
  • Class Summary
  •  

 

 

  • © Computer Business International, Inc.

 

Would you like to schedule or customize this class?
Please call our toll free number 1.866.224.4968 or email us at info@cbi4you.com.