• JCL-How to Give Dummy VSAM Dataset

    There are multiple DUMMY data set benefits you can see in your JCL. Explained how to created DUMMY dataset in VSAM. Added more info why DUMMY is used in projects.

  • 10 PLI Key Error Handling Phrases

    PLI conditional errors popular in all the programs.

  • PLI: How to Declare Arrays

    An array is a subscripted collection of data items of the same data type. PL/I allows arrays of arithmetic values, character strings, bit strings, label constants, entry constants, pointers, files, or structures. You can refer more in it. The following are examples of array declarations: declare test_scores(100);declare A(4,5);declare A( 1:4, 2:5, 0: 10); You make…

  • Creating Super and Participating Package in Chgman

    The best way to create super package and Participating package in Changeman in mainframe projects.

  • How to Retrieve Rows Using TimeStamp Best SQL Query

    Best SQL query to retrieve rows by using Timestamp

  • Your Roadmap to a Successful Career in Technology

    No, this isn’t just a catchy headline. This is real talk — the kind you need if you truly want to succeed in your career. Get Success in Career: Why Chasing Salary Alone Will Hold You Back I spent over two hours today searching for an article that speaks directly and truthfully about career growth.…

  • DB2- COBOL Sample Program With Cursors

    Please find the COBOL-DB2 sample program.     COBOL-DB2-Sample program

  • SQL Rollback: How to Understand Its Background Process

    ROLLBACK and cursors there is a relation for these two things in DB2. This post tell all about cursors behavior when ROLLBACK happens.

  • DB2-Triggers and Stored Procedures

    Both, Triggers and Stored procedures are DB2 objects. Triggers info will be stored in SYSIBM.SYSTRIGGERS  Stored procedures will be stored in SYSIBM.SYSROUTINES

  • Mainframe: Cool Tips

    Mainframe tips that you may apply in your project.

  • How to Write Simple Easytrieve Program

    The first step Easytrieve is a reporting Language. The benefits and types of flavours available in the market explained here. A sample program is given to undestand about this language.

  • IT Project (Mainframe) – Risk

    To know if risk is involved in an IT project ,we need to calculate two values: one is MEAN and 2nd is SD (standard deviation). Formule: SD==> (PE-OPE)/6 Percentage ==> SD/Mean==> for example, percentage is 10.90, that project we treat risky. Note :-Read my previous post for more clarity: https://srinimf.wordpress.com/2011/07/03/it-project-estimation/ General thumb Rule to decide Risk: If the percentage…