DBRM: DataBase Request Module has the SQL statements extracted from the host language program by the SQL precompile. The COBOL-DB2 program is preprocessed by DB2 to produce a DBRM that will be used to bind against a particular DB2 subsystem. The Db2 system uses the DBRM to optimize application program interaction. PACKAGE: A package contains control structures that DB2 uses […]
DBRM, Package, Collection and Plan Read More »
IEBGENER and IEBCOPY are IBM utilities used for various operations. IEBCOPY is a data set utility that is used to copy or merge members between one or more partitioned data sets, or partitioned data sets extended (PDSEs), in full or in part. You can also use IEBCOPY to create a backup of a partitioned data
IEBGENER and IEBCOPY utility JCL Reference Read More »
A PDSE is a Partitioned Data Set Extended. It consists of a directory and zero or more members, just like a PDS. It can be created with JCL, TSO/E and ISPF just like a PDS and can be processed with the same access methods. The directory can expand automatically as needed, up to the addressing
Partitioned Data Set Extended – PDSE Read More »
The FETCH FIRST n ROW ONLY clause is used to limit the result set of a query to a specified number of rows. It is particularly useful when you are only interested in retrieving a subset of the total records. Retrieving the entire result table from the query can be inefficient. You can specify this
FETCH FIRST n ROW ONLY and OPTIMIZE FOR n ROWS Read More »
A DB2 null Indicator/value represents missing or unknown information at the column level. When a column is set as null, it can mean one of two things: the attribute is not applicable for certain occurrences of the entity, or the attribute applies to all entity occurrences, but the information may not always be known. It
DB2 NULL Indicator use in SQL Queries Read More »
DB2 locking and concurrency is a critical part of DB2 as well as batch performance. Batch update jobs processing large amounts of data will need to have restart logic through the use of the COMMIT statement and a program data save area. This will identify the restart point. Commit frequency should be an input parameter
DB2 locking and concurrency – Tips & Trick Read More »
Depending on the linkage options, the object module of the calling program is linked with the object module of the called program “before or during” execution – referred to as static or dynamic linking. Note : Even if your program is coded to call a program statically, the compiler can convert it to the dynamic
Static or Dynamic Call Option in Cobol Read More »
LINEAR and BINARY searches can be coded using traditional code or using the SEARCH or SEARCH ALL verb. The one that is coded using traditional code uses an Occurs to define the re-occurrence of the elements in the table and the Subscript to control stepping through the table one element at a time using the
SEARCH and SEARCH ALL use in Cobol Program Read More »
Using indexes to address a table is more efficient than using subscripts since the index already contains the displacement from the start of the table and does not have to be calculated at run time. Subscripts, on the other hand, contain an occurrence number that must be converted to a displacement value at run time
Indexes vs Subscripts use in Cobol Program Read More »
The ONCODE built-in function provides a fixed-point binary value that depends on the cause of the last condition. ONCODE can be used to distinguish between the various circumstances that raise a particular condition—for instance, the ERROR condition. For codes corresponding to the conditions and errors detected, refer to the specific condition. 3 in a SELECT/WHEN/OTHERWISE
While executing a job there are many abend code due to which it can fail. Here is a list of common Abend Codes and their explanations. Abend Code:1. S001 – An I/O error occurred. Check reason code for exact cause. Examples are trying to read beyond End of File, trying to write to an input
Abend Code and their meaning in JOB Spool Read More »
USAGE and COMP: USAGE CLAUSE -There are two general forms of internal representation – computational and display (Usage and Comp). Only numeric data items can be displayed as computational, and as the name suggests, an item specified as computational can take part in arithmetic operations more efficiently. Whether a data item is computational or display, it
USAGE and COMP Declaration Read More »
REDEFINES: Sometimes, it may be found that two or more storage areas defined in the DATA DIVISION are not in use simultaneously. In such cases, only one storage area can serve the purpose of two or more areas if the area is redefined. The REDEFINES clause allows the same memory area to be described by
REDEFINES and RENAMES use in COBOL Program Read More »
