Srinimf

  • JCL: Sysin DD* and SYSIN DD DATA

    Here is sample JCL of SYSIN card with DD* and DD DATA. Here, I have shared with example when to use these two. Read More ⇢

    JCL: Sysin DD* and SYSIN DD DATA

  • IMS- ACB(Access control block)

    IMS™ builds the ACB with the ACBGEN utility by merging information from the PSB and DBD. For execution in a batch environment, IMS can build ACBs either dynamically (PARM=DLI), or it can prebuild them using the ACB Maintenance utility (PARM=DBB). ACB Lib ACBs must be prebuilt for use by online application programs. ACBs cannot be prebuilt for GSAM DBDs. However,… Read More ⇢

    IMS- ACB(Access control block)

  • COBOL – How to Use ‘ CANCEL’

    Global, External, Initial what is the difference in COBOL Read More ⇢

    COBOL – How to Use ‘ CANCEL’

  • DB2- Date, Time, Timestamp

    The beautiful examples of DB2 Date, Time and Timesatmp and how to use Sysdummy1 table in DB2. Really good to read and you can use in your code directly. Read More ⇢

    DB2- Date, Time, Timestamp

  • Why is IMS DB popular? Here are the Real Reasons

    The IMS database management system (DBMS) implements the hierarchical model tree structure to organize the collection of records in a one-to-many entity relationship data model. Read More ⇢

    Why is IMS DB popular? Here are the Real Reasons

  • IMSDB Tricky Proc Options GO, N, E, T Explained

    DURING PCB GENERATION, below are the top five PROCOPT parameters you can use – read segments in the hierarchy or update segments, etc. Top Proc Options. G – Your program can read segments. R – Your program can read and replace segments. I – Your program can insert segments. D… Read More ⇢

    IMSDB Tricky Proc Options GO, N, E, T Explained

  • Mainframe funda that All You Need

    IBM officials said 1,067 schools worldwide are recognizing the vast number of job opportunities available in enterprise computing and the importance of teaching students key systems technology like the IBM System z mainframe Read More ⇢

  • DB2 Stored Procedure Best Example

    Stored procedures can be written in COBOL, PL/1, REXX and Java etc. Db2 stored procedures are handled by WLM -work Load Manager. Main uses are reusability and security. Stored Procedure Flow Note: The language to write stored procedure can be SQL, COBOL, PL/1 and JAVA. It runs in the database (in our case DB2). It… Read More ⇢

    DB2 Stored Procedure Best Example

  • How to create Triggers in SQL

    The triggers in DB2 is really a complex task for many SQL developers. The example SQL helps you to start your journey. Read More ⇢