• 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…

  • IMS DB HDAM, PHDAM, HIDAM, and PHIDAM databases

    A hierarchical direct (HD) database is a database that maintains the hierarchical sequence of its segments by having segments point to one another (instead of by physically storing the segments in the hierarchical sequence). HDAM HD databases are stored on direct-access devices in either a VSAM ESDS or an OSAM data set. In most cases, each segment in an…

  • Software Project Estimation Top Three Ideas

    Top methods you need to estimate software development project.

  • COBOL: How to Use INDEXED BY Clause

    COBOL Tricky example on OCCURS and Indexed By explained

  • Sample IMS DB and COBOL Program

    COBOL sample program on how to access IMS segments.