Mainframes Archive

COBOL Perform Types and Usage with examples

Perform Verb in COBOL is used to execute a set of COBOL statements. There exists different types of performs based on the way that is being used. It is vital in keeping a cobol program structured by making it possible to call different paragraphs or sections from another paragraph or section. Following are some of

TSQ and TDQ in CICS

TSQs—> Temporary Storage Ques are important CICS storage facility to store data that must be available to other transactions in the same region. Records stored in TSQs are called as ITEMs and can be referred seq. or directly by using the ITEM number. Remains in the storage until it gets deleted or COLD start. These

Transaction CICS

Transaction in CICS has a great importance which is the unit of work performed and is represented by a 4 char TRANS ID. It is linked to one or more programs and once a transaction is initiated, programs that are defined gets executed. At the time of transction definition, these programs needs to be given/linked.

Cobol DB2 Program execution and Coding requirements

Unlike a normal COBOL program COBOL DB2 program has some special requirements to be considered while coding and execution. For ex: In the coding it is required to include the SQLCA and the program needs to be executed via Terminal monitor Program etc. COBOL DB2 Coding Part: 1. Do the coding as per the requirement,

DB2 Optimizer Overview | How Db2 selects the optimum path

The DB2 optimizer is the main component of DB2. As its name implies, it analyzes the SQL statements and determines the most efficient path to access the desired data from the tables. When the SQl statement is fired, it access the statistics stored in the DB2 catalog to determine the best path to suffice the

Cobol-DB2 Cursor Overview

Db2-Cursor: Cursors in the application program are used to retrieve the multiple rows and process them one by one . Generally by using a singleton select statement in the application program, it is possible to retrieve only one row at a time as the host variable structure allows keeping one value at a time. Ex:

CICS Tutorial

CICS Tutorial part-1 CICS is a transaction procession system owned by IBM and runs under Z/OS operating system. CICS stands for Customer Information Control System which works as a front end for the business applications written in COBOL, PL/1, C, C++, Assembler, PHP and JAVA but most of the applications which CICS supports are written

COBOL Renames Clause with Examples

COBOL Renames clause is used to regroup the elementary data items and gives them an alternative name. This is a logical grouping of the elementary data items which are defined in a sequential order.It is useful for renaming by overlapping elementary elements.66 Level number is used for defining it. [crayon-5b019512104c0954907678/] – 01 , 77 levels

DB2 Table Space Types and its usage

Table Space concept in DB2: Table space is a database object where actually the table data gets stored. It is a like child of the database, where there can be multiple table spaces within a database. Each table space contains the ‘containers’. There can be one or more containers per table space. Containers can be

COBOL Arrays or Tables

Single dimensional arrays: Arrays are data structures that are used to simplify coding and improve processing efficiency. The primary uses of arrays are to define:  a series of similarly formatted input or output record fields in the FILE SECTION  a group of accumulators in WORKING-STORAGE for different categories of totals  a table in WORKING-STORAGE that
Bitnami