Category: DB2

DB2 Error Codes

DB2 Error Codes / DB2 SQL Codes :   0  – Successful execution.   +100  – End of the data.   -203  – Reference to Column name is ambiguous. The column name is specified at...

More

AccessPath, plan and package

Bind process creates access paths to the DB2 tables. Access path is the optimized path to get the data with the SQL statements. Plan is a DB2 object which is a result of a...

More

DB2 Pre Compiler

The DB2 pre compiler is run first before compiling the COBOL code. The DB2 precompiler seperates the SQL statements from the COBOL program and puts them in DBRM(DataBase Request Module). The DB2 precompiler adds...

More

SQL Code

SQLCODE: Zero – Statement Successful. +ve – Statement Successful with some exceptions. +100 – End of data. Row not found. -ve – Serious error.

More

Embedded SQL

COBOL program uses Embedded SQL statements. SQL statement within a program is called an Embedded SQL. How to code Embedded SQL : – Start each SQL statement with EXEC SQL and end with END-EXEC....

More

SQL Communication area

SQLCA: SQL Communication Area. When ever we write a DB2 program it is mandatory to Write SQLCA. It is a 01 level record structure.

More

Host Structure in DB2

COBOL program sends and receives data to and from DB2 tables via Host structure. Host structure acts as a communicator between DB2 and COBOL program. Host structure is defined at 01 level.

More

DB2 and it’s benefits

DB2 is a relational database. Relational database is one which is based on Codd’s rules. Benifits of DB2: – Easy to Use. – Non Procedured – Supports organization for access path of required data....

More