| 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. |
|
| Covered Topics: |
- Retrieve from and update DB2 tables using SQL data manipulation verbs.
- Identify the differences between a standard COBOL program and one that accesses DB2 tables.
- Embed SQL code in COBOL programs as well as code the related application structures needed for accessing DB2 tables from an application program.
- Prepare, execute and test batch programs that access and update DB2 data efficiently and maintain integrity.
- Employ CURSOR processing in application programs.
- Describe and use commit-point processing and identify when and how to use commit points effectively.
|
| Prerequisites: |
- Experience with or training in Relational Database and SQL Programming is needed for this class.
- Some experience with COBOL is also preferred.
|
| Audience: |
| This course is designed for people who will be coding and/or maintaining application programs using DB2, primarily application developers who code COBOL programs. |
|
| |
| Course Benefits: |
| Students who complete this course will be able to code SQL statements to access DB2 objects. Also, the student will learn how to establish the appropriate execution environment for programs that reference DB2 Data Bases. |
| Materials Furnished: |
- Student Manual
- This course includes a combination of lecture, discussion and numerous computer labs. Students will receive an extensive reference manual, which will be helpful on the job as well as in class. There is an optional textbook available for future reference
|
| Recommended Follow-On Course: |
| |
|
|
|
|
|
