Let's mainframe!
What is DCLGEN in DB2?
DCLGEN (Declarations generator) are used in the COBOL-DB2 programs that we write. The program should declare the tables and views that it accesses. DCLGEN produces these DECLARE statements so that we do not need to code these statements manually. It also generates corresponding host variable structures. When DCLGEN is used to generate a table declaration, the DB2 uses the DB2 catalog to get the relevant information from it. DCLGEN, then uses this information to create an SQL DECLARE TABLE statement for the table/view. DCLGEN has SQL DECLARE TABLE statement, the Cobol equivalent variables for columns and NULL indicators too.
DCLGEN (Declarations Generator) in DB2 is used in COBOL-DB2 programs to declare tables and views. It generates SQL DECLARE TABLE statements and corresponding host variable structures, saving manual coding effort.
Lets' mainframe!
Do you know what DBRM is?
DBRM is Database Request Module and is a component inside DB2, it is created after the pre-compilation of COBOL-DB2 program. This is a module that consists of SQL source statements that get ex...
Let's Mainframe!
JOBLIB is a DD statement which is a user defined library (we can code many) at job level where load modules of the programs called in the JCL should reside. The JOBLIB should be coded between the Job card and the firs...
Let's mainframe!
Distinction between CHAR and VARCHAR data types -
CHAR data type has a predetermined maximum length, while VARCHAR data type is a varying length character string.
So, it means, Char will always have the same leng...
Let's Mainframe! :)
VB (Variable Blocked) file:
There are two types of control information in a VB file-
There might be several records in...