• CICS: CEMT, CECI, CEBR Commands Part(2 of 3)

    Here is when to use CEMT, CECI and CEBR commands in CICS. CEMT, CECI and CEBR Commands CEMT lets you display and change the status of resources, including programs, transactions, data sets, queues, and terminals. You’ll use CEMT in a CICS test environment often to refresh a copy of a program, allocate and deallocate a…

  • Recently asked IMS DC Top Interviews Questions(2 of 2)

    IMS DC my second set of interview questions. 1) Which block MFS uses for input message? DIF- Device input format 2) What is second block it uses? MID- Message input descriptor 3) Which block application program uses for output messages? MOD-Message output descriptor 4) What is next block it uses? DOF- Device output format 5)…

  • COBOL strings popular ideas to learn now (2 of 2)

    What is String concatenation in COBOL. Read my previous post on COBOL Strings-INSPECT VERB. String concatenation involves joining the contents of two or more source strings or partial source strings to create a single destination string. In COBOL, string concatenation is done using the STRING verb. Before I discuss the STRING verb formally, let’s look…

  • COBOL: How to Use PERFORM Varying Correctly

    Perform varying typical examples explained with logic. These examples are useful for you to refer to and use in your projects.

  • Easytrieve Guide for Mainframe Programmers (6 of 20)

    How to print reports in Easytrieve program explained all the syntax details.

  • COBOL: Indexed By Vs Subscript key Differences

    Index vs Subscript and the key differences in terms of COBOL

  • COBOL: Indexed BY Vs USAGE Vs OCCURS

    In COBOL, Index data items, OCCURS, and KEY clauses are tricky. Explained the benefits and usage of these items with examples.

  • How to Use OUTPUT statement in JCL

    SYSOUT statement in JCL (Job control Language), a simple example of how to use it correctly. Why SYSOUT is coded in JCL SYSOUT data sets are output files that are designed to be printed rather than stored on DASD or tape. how to print multiple copies of a data set without rerunning the entire job…

  • How to Use DB2 LOCATE Built-in Function

    Checkout here my earlier post on built-in functions. LOCATE is a Scalar function. Here is my ideas how to use correctly. Below is the Syntax for LOCATE function SELECT LOCATE(‘String to be searched’, Source string’, Start position)FROM SYSIBM.SYSDUMMY1; Key points in LOCATE function The LOCATE function returns the starting position of search-string within source-string. If…

  • DB2 Tutorial For Software Developers (3 of 5)

    DB2 tutorial is good for both DB2 and mainframe developers is it is quick to read and given in the form of questions and answers. Read my part-2 post on DB2 tutorial. Data Definition Language(DDL) CREATE: –This statement is used to create objects Syntax : For Creating a Table CREATE TABLE <tabname> (Col Definitions) PRIMARY…

  • Top Data warehousing Interview Questions (Part 1 of 2)

    Data warehousing interview questions useful to read before you give an interview or training.

  • SQL Built-in Functions to write better query

    All the built-in functions you cannot use in SQL queries. Some functions help you achieve greater performance in SQL queries. Follow these suggestions to get an idea about alternative SQL built-in functions.