| S# |
Topic Name |
Description |
| 1 |
Introduction to DB2 |
Overview of DB2 and its role in database management systems. |
| 2 |
DB2 Architecture and components |
Explanation of DB2 architecture, its components, and how they interact. |
| 3 |
DB2 Objects: System and User defined objects |
Overview of the various DB2 objects, including system and user-defined objects. |
| 4 |
Intro to SPUFI and QMF tool |
Introduction to SPUFI (SQL Processing Using File Input) and QMF (Query Management Facility) tools in DB2. |
| 5 |
Executing SQL queries in SPUFI |
Steps for executing SQL queries in SPUFI tool, and how to view results. |
| 6 |
SQL Commands: CREATE, INSERT, UPDATE, GRANT and Revoke |
Overview of essential SQL commands such as CREATE, INSERT, UPDATE, GRANT, and REVOKE in DB2. |
| 7 |
PRIMARY KEY, FOREIGN KEY, and Referential integrity and On cascade |
Explanation of primary and foreign keys, referential integrity, and cascading actions in DB2 databases. |
| 8 |
SELECT Command |
Detailed explanation of the SELECT command and its use cases in DB2 (including WHERE, BETWEEN, LIKE, and IN operators). |
| 9 |
JOINS |
Explanation of different types of joins in DB2: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN. |
| 10 |
Subquery |
Explanation of subqueries in DB2, including correlated and non-correlated queries. |
| 11 |
DCLGEN |
Overview of DCLGEN (Declaration Generator) and how it is used in DB2 programs. |
| 12 |
COBOL+DB2 Programs (SELECT, INSERT, UPDATE and DELETE commands) |
Integration of COBOL with DB2 to execute SQL commands like SELECT, INSERT, UPDATE, and DELETE. |
| 13 |
Pre-compilation process, Compile, Link-edit and Bind Plan & Run jcl |
Overview of the steps involved in pre-compiling, compiling, link-editing, and binding DB2 programs. |
| 14 |
Null Handling |
Methods of handling NULL values in DB2 queries and programs. |
| 15 |
Varchar Handling |
Explanation of how VARCHAR data types are handled in DB2 and how to manage variable-length strings. |
| 16 |
Cursor handling |
Overview of how cursors are used to manage DB2 result sets and navigate through data. |
| 17 |
COBOL + PS + DB2 program(s) |
Explanation of how COBOL programs can interact with DB2 and PS files. |
| 18 |
SQL error handling (-805, -811, -204, -206, -803, -818, and more) |
Overview of common SQL errors in DB2 and methods for handling them. |