KT-1022 DB2 for the COBOL Programmer Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


DB2 for the COBOL Programmer


Description: 

This course focuses right from the start on what you need to know to access and process DB2 data in your application programs using embedded SQL.

You will learn:

  • Critical DB2 concepts that let you understand how DB2 works so you can program more easily and logically
  • Basic DB2 coding features you’ll use in every program you write
  • Use features like outer joins and the explicit syntax for inner joins that simplify your coding
  • Work with column functions, scalar functions, and subqueries to manipulate DB2 data
  • Handle the complications caused by variable-length data and null values in DB2 tables
  • Use error handling techniques and ROLLBACK to protect DB2 data
  • Why program efficiency is vital under DB2…and how to use the locking features right so you don’t tie up the whole system
  • Use SPUFI and QMF to create the test tables you need to debug your programs
  • Develop DB2 programs interactively (using DB2I, a TSO facility) or in batch

 
Click here to view the Course Outline
     
Prerequisite: 
Programmers who want to learn how to handle DB2 data in their programs. It assumes you already have some COBOL experience or at least have taken a first course in COBOL.  
   
     
Duration: 
Custom  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.



Comments on the Course

Please Note:
This course is primarily offered via private training only. If your organanization has three or more individuals interested in this course, please call us at 1-866-444-6548.