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.
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,
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
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 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 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. ex: 01 WW-VAR1. 05 WW-V1 PIC
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
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
STRING AND UNSTRING with examples: TALLYING and COUNT options String is used to combine two or more strings/variables in to a single string. Examples: 01 name-in. 05 first-name pic x(10) value 'Mahender ' 05 Last name pic x(10) value 'Reddy ' 05 initial pic x(2) value 'G ' If you display the ‘name-in’ it shows
ESCAPE in DB2 Mainframes: In SQL the percent sign(%) and the under score(_) has special meaning. %’ – represents any set of characters _ – under score represents any single character. Ex: select * from emp where email like 'reddy_%'; This will display all the email ids starting with reddy like reddy123,reddy_34 etc. But here
