• COBOL: EXTERNAL file Vs GLOBAL file

    Within a main program and each of its contained subprograms, data and files are normally private, which means that they are accessible only to the program in which they are contained. However, COBOL has provisions for sharing data and files among a main program and its subprograms. Procedure names and paragraph names are private to…

  • Sweet Spots of DB2 V11 with Hadoop

    Big data and business analytics represent the new IT battleground. Here is some stats: IDC estimates the big data market will reach $16.9 billion by 2015, and that enterprises will invest more than $120 billion to capture IDC estimates the big data market will reach $16.9 billion by 2015, and that enterprises will invest more…

  • 6 Steps: How to Fix SQL Query Performance Issue

    Check SQL performance gaps explained complete steps in this tutorial

  • IMS DB Tutorial Learn Quickly

    Complete tutorial on IMS DB for learners and developers highly useful.

  • Popular ROLLUP SQL query to apply on your data to group it quickly

    ROLLUP and grouping sets are two similar functions to apply on group of data. Most popular SQL query example to use ROLLUP. You can improve your SQL performance.

  • 3 Free Python Downloads – Here’re Links

    Ipython you complete open source software. You can download quickly to start learning.

  • Unix: Top Editor Commands to Schedule Job and More

    Unix cron top commands to use in scheduling jobs

  • Mainframe ISPF Commands (5 Of 5)

    How do I make columns 1-6 disappear from my ISPF editor screen?   A. Type ‘NUM ON COB’. These are the ‘COBOL numbers’ columns and the screen display will be from Col 9-80. 42. How do I make the numbers on Col 1-6 contiguous, i.e., the COBOL numbers A. Type ‘RENUM’. ISPF sometimes recommends you to do this.…

  • 2 More Ideas on COBOL Debugging

    Here’s a way how to debug COBOL program

  • Mainframe ISPF Commands(4 Of 5)

    1). How do I find for any non-numeric character? A. Use picture string ‘-’. 2). How do I find for any alphabetic character? A. Use picture string ‘@’. 3). How do I find for any uppercase alphabetic character? A. Use picture string ‘>’. 4). How do I find for any lowercase alphabetic character? A. Use picture string ‘<’. 5). How do I…

  • Grouping Sets: How to Simplify SQL Query

    THE GROUPING SETS option’s real usage is to make the union of two or more groups of rows into a single result set. Introduced in DB2V11. The best example given and explained to use it and improve your SQL Query. Grouping Sets in DB2 It is logically equivalent to the union of multiple subselects with…

  • What is EIB Storage Area in CICS

    The EIB is also called executive interface block. The name tells that it is a interface to calling module. So the every action will be updated in EIB fields in CICS. I have given the most frequently used fields to execute CICS programs for your ready reference.