DB2/SQL Application Programming

This class provides the knowledge and skills needed to use DB2 and SQL in both interactive and embedded formats. It also includes information on DB2 concepts and facilities, referential integrity, locking, primary keys, foreign keys and data integrity, DB2 physical storage and programming considerations. Dynamic SQL is executed through SPUFI or QMF, and embedded SQL is executed using COBOL application programs. Click here to have a detailed outline emailed to you.

DB2 Embedded SQL Programming

This course provides training for skills needed to code DB2 embedded SQL in COBOL application programs. Topics include how to prepare DB2 programs, access DB2 databases using SQL, retrieve multiple rows of output using cursors and handle commit processing through COBOL programs. Click here to have a detailed outline emailed to you.

Advanced SQL/DB2 Performance

This course provides in-depth study of SQL especially joins and subqueries, and will strengthened these skills through extensive workshops and classroom lecture. A solid introduction to application-based DB2 performance tuning thru the use of EXPLAIN to examine the DB2 optimizer's access path decisions. Click here to have a detailed outline emailed to you.

COBOL II Programming

This class provides people with the knowledge and skills needed to code COBOL II application programs. It also covers effective use of the language for report generation using sequential file inputs. The course can easily be divided into two parts; namely a three-day basic, followed by two-day additional COBOL topics. Click here to have a detailed outline emailed to you.

COBOL II Refresher

This class provides the additional knowledge and skills needed to code COBOL II application programs for people who have basic knowledge of COBOL II. Topics include using VSAM file processing, variable length file processing, internal sort, multi-dimensional table processing, and dedugging techniques. In addition the course also presents principles of structure programming in COBOL coding and also covers effective use of the language. Click here to have a detailed outline emailed to you.

IBM COBOL II (OS 390)

This class provides the additional knowledge and skills needed to code COBOL II application programs in an IBM OS 390 environment. It is for people who have basic knowledge of COBOL II, and it provides a method for getting and manipulating a true four-digit year in a COBOL Program. Topics include COBOL Intrinsic Functions and LE Callable Functions, which are Year-2000 compliant in their handling of dates. Click here to have a detailed outline emailed to you.

TSO/ISPF

This course covers ISPF and provides an introduction to using TSO, MVS and SDSF. Students will learn the major functions of these tools in an MVS environment; such as browse, edit, and features available in the library function. They will also learn several valuable shortcuts, which will help make them more productive on the job. Click here to have a detailed outline emailed to you.

MVS JCL

This course introduces JCL and provides the knowledge and skills necessary to code and execute batch jobs. It contains information pertaining to MVS/ESA. In addition to covering the basics of the JOB, EXEC and DD statements, the course provides the basics for MVS utility programs such as IDCAMS, IEBGENER and IEBCOPY. The course can be taught as a two-day class without the utilities. Click here to have a detailed outline emailed to you.

MVS JCL UTILITIES

This course provides the basic knowledge of commonly used MVS utility programs such as IDCAMS, IEBGENER, IEBPTPCH, IEBCOMPR, IEBCOPY and SORT/MERGE. The course is an excellent review of JCL and the control statements available for each utility. Click here to have a detailed outline emailed to you.

INTRODUCTION TO VSAM

This course provides the basic concepts of VSAM file processing and the facilities, such as IDCAMS and JCL usage, which makes VSAM easier to work with. This course also will provide an understanding of how VSAM uses objects such as catalogs, control intervals, control areas, indexes, etc. In addition, participants will practice creating these objects using IDCAMS. Click here to have a detailed outline emailed to you.

VSAM PROGRAMMING

This course provides the skills needed to code COBOL and COBOL II programs that access VSAM datasets. A pre-requisite to this course is an Introduction to VSAM, which can be added to the programming topics to provide information on both VSAM concepts and programming. Click here to have a detailed outline emailed to you.

CICS COMMAND LEVEL PROGRAMMING

This class provides the skills needed to code COBOL application programs using the CICS/MVS and CICS/ESA Command Level interfaces. CICS concepts and structures as well as programming detail, such as file control, DB2 access, program control and terminal handling, are included. Other areas of CICS are also presented: queue management, program preparation, testing and debugging. Click here to have a detailed outline emailed to you.

EASYTRIEVE PLUS

The course presents an introduction to EASYTRIEVE PLUS. The seminar is directed at developers extracting information from files to create reports. The course will utilize lectures, conversations, inquiries, adhoc testing, manual and online error report references, and extensive use of hands-on labs with coding exercises. Click here to have a detailed outline emailed to you.

DOS/VSE JCL

This course introduces JCL and provides the knowledge and skills necessary to code and execute batch jobs. It contains information pertaining to DOS/VSE, POWER, and JECL. In addition to covering the basics of the JOB, EXEC and DLBL, TLBL, and EXTENDS statements, the course provides the basics for VSE utility programs such as IDCAMS, SORT, and DITTO. Click here to have a detailed outline emailed to you.