Author Archive

Dynamic SQL in DB2 COBOL

How to code Dynamic SQL(DS) in a COBOL DB2 Program Dynamic SQL is prepared and executed at the run time as opposed to embedding it in the host language program as in a static  one. Using dynamic SQL in the application programs has proved many advantages. For ex: In some cases the businesses requirement demands

Exception Handling in CICS

Exception handling It is one of the core concept in CICS coding. Programmer should have knowledge on exception handling methods for effective use of these methods while developing any program. This topic gives various types of exception handling and usage of each one in detail. By default CICS manages the exceptions internally and ends programs

File AID Tutorial and useful commands

File aid is having two types one which is used for File operations and second one is used for DB2 (file aid for DB2). Here we are going to discuss about the file aid for files. Fileaid is a very useful tool in the mainframes, it can be used to browse (PS, VSAM), EDIT the

Useful QMF Commands

Useful QMF Commands Below are commonly used QMF commands for quick reference 1. Connect: To connect to different database other than the default one(e.g.; if the default is DSNS and u want to connect to DB2T) Then issue the command Connect to DB2T in the QMF main panel. 2. Import : This is to import

Cursor positioning in CICS Methods

Cursor positioning in CICS is an important aspect in the screen and program design. At the time of screen (MAP) design the initial cursor location must be specified as per the requirement. This is the Static Cursor positioning. This can be changed dynamically at the time program coding and it is called as the Dynamic Cursor

SuperCE compare process with Example

Comparing two datasets using SuperCE for specific columns As all we know SuperCE allows the comparison of the datasets. Generally we use it to compare the whole datasets. But some times we may require comparing the datasets according to the data present in the specified location (ex: from col 15 to col 20).  Procedure:Step-1 Enter

File-AID Reformat Option

File-AID reformat option is very useful to copy one file to other by adding/modifying some data to it. It can be used to copy one file layout to other file layout by adding the additional data to the input file. It can be used to copy all or selected records of any input file to

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.
Bitnami