Srinimf

Advertisements

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

  • DB2-Stored procedures & Triggers

    Both are DB2 code. Stored procedures are created and stored in SYSPROC catalogue table. These are static and whenever user wants they can call in th program. How to call stored procedures? Syntax is as follows: SAMPLE is stored procedure name. Exec SQL CALL SAMPLE END-EXEC. Triggers are dynamic. When particular situation happens… Read More ⇢

  • PL1 mostly used Logical Expressions

    PLI program top logical expressions. Like many other top level languages PL/I also has For, While, Do While loops. Read More ⇢

    PL1 mostly used Logical Expressions

  • Top JCL The Real Usage of IFTHEN in DFSORT

    DFSORT conditional sort best example. Given here step by step explanation for each step. Read more. Read More ⇢

    Top JCL The Real Usage of IFTHEN in DFSORT