What you'll learn:
Introduction to DB2
DB2 Objects
DB2 Components: SSAS,DBAS,DDF,SPAS,IRLM
Data types in DB2
Executing SQL commands thru QMF tool
Executing SQL commands thru SPUFI tool
Create table command,Primary key, Unique Index
INSERT,SELECT,UPDATE and Delete commands
SELECT Command: Where, Group By,Order By and Having,Like,Where , *
Joins in DB2
Subqueries in DB2
Writing COBOL,DB2 programs
Processing files in COBOL,DB2 programs
Null and Varchar handling in Application program
SQL error handling in application program
Explained about Precompilation process(Compile, Linkedit)
Explained about BIND plan and Differences between plan and package
Executing the application program
Cursor Handling and advanced cursor topics
SQLCA,SQLCODE and SQLERRD(3)
Requirements:
Mainframe knowledge
JCL, VSAM, COBOL modules knowledge and bit hands-on experience
Description:
In the comprehensive Mainframe DB2 developer curriculum, the initial segment focuses on fundamental concepts. This includes an introduction to DB2, exploration of DB2 objects and components, as well as an in-depth study of datatypes within the DB2 environment. Students will gain practical experience in executing SQL commands using both QMF and SPUFI interfaces, covering essential operations such as CREATE TABLE, INSERT, UPDATE, DELETE, SELECT commands, Join concepts, Sub queries. The subsequent course delves into the integration of DB2 functionalities within COBOL programs, providing learners with hands-on training in implementing DB2 features in COBOL applications.Topics covered:Introduction to DB2Understanding DB2 ObjectsExploring DB2 ComponentsStudying Datatypes in DB2Executing SQL Commands in QMFExecuting SQL Commands in SPUFILearning CREATE TABLE CommandMastering INSERT CommandUnderstanding UPDATE CommandImplementing DELETE CommandExecuting SELECT CommandCreate table with Primary keyCreate table with Composite keyCreate table with referential integrityDiscussed on few SQL commands like -104, -206,-204,-180,-181, -540,-601,-805,-818,-811,-305 and etc.Joins in DB2Inner joinLeft outer joinRight outer joinFull outer joinSub-queriesThe topics outlined above are thoroughly explored on the Mainframe server to facilitate better comprehension and practical knowledge acquisition. Through both Course 1 and Course 2, students will engage in hands-on learning experiences that reinforce their understanding of DB2 concepts and their application within the Mainframe environment.
Who this course is for:
Beginners who are learning DB2 first time
Mainframe developers
Homepage