DB2 is well known as Data base 2 which is introduced by IBM. It is known as Relational database (Relational is nothing but the data stored will have a relation in between). The relational data stored in format of TABLE which contains Tuples (ROWS) and the row consists of Attributes (COLUMNS).
DB2 is almost similar to the SQL (Structured Query Language) but with some additional features and mainly used to process the large amount of data from the Mainframe application.
Readers who are having or not having mainframe knowledge.
The tutorial is intended for the readers with no previous programming or computer science experience as well as for those with some computing background. In the tutorial, all the topics are covered with in depth description and can understandable by anyone who had minimum/no computation background.
Need to learn COBOL, JCL languages if learning for processing DB2 tables from COBOL programs.
Learn COBOL tutorial at COBOL Tutorial
Learn JCL tutorial at JCL Tutorial
There are no prerequisites to learn DB2 language if learning the DB2 only for Database knowledge. Having the computation background will be an advantage in understanding the concepts a bit easy. Without having computation background, it is a bit time taking to understand the concepts and need to go through the topic more than once to understand clearly.
Table of contents:
- DB2 - Introduction
- DB2 - Table Storage Structure
- DB2 - Index Storage Structure
- DB2 - Precompilation Process
- DB2 - BIND PROCESS
- DB2 - ISOLATION levels
- DB2 - Db2 program Execution process
- DB2 - Host Variables
- DB2 - SQLCA
- DB2 - Cursor
- DB2 - Db2 Statements in Cobol program
- DB2 - DDL
- DB2 - DML
- DB2 - TCL
- DB2 - DCL
- DB2 - JOIN Statement
- DB2 - NULL
- DB2 - DB2 Error codes
All Tutorials Home Page DB2 Introduction