Srinimf

Advertisements

  • SQL Query: How to Find Salary Dept wise

    Here’s an interview question; asked in many interviews. The question: Write SQL query to find Salaries paid department-wise. You can get salaries paid to employees for each of the department codes from the EMPLOYEE table. Read: 5 SQL MCQ Questions, Useful for Interviews As Well Get Table Details Take a look… Read More ⇢

    SQL Query: How to Find Salary Dept wise

  • DB2 Load and Unload: How to Achieve Parallel Processing

    The best way to LOAD is split your input data set into part and load individual data set into part of partition table space. However, splitting your input data set sometimes is not an easy process and you may need to create a batch job to do the work using… Read More ⇢

    DB2 Load and Unload: How to Achieve Parallel Processing

  • 2 More things on Advanced COBOL Programming

    A great opportunity for mainframe programmers to implement these advanced concepts into their development projects. As you gain experience you need to show some performance improvement in your day to day coding. These, you can tell, that you did in your projects, in your appraisal meetings. EVALUATE In advanced COBOL… Read More ⇢

    2 More things on Advanced COBOL Programming

  • DFSORT Top Ideas on Sorting of Multiple Fields

    The SORT sample code helps you to use in your JCL. The powerful code is so powerful and you can sort multiple fields at a time using DFSORT with JCL in mainframe reporting Jobs. Read More ⇢

    DFSORT Top Ideas on Sorting of Multiple Fields

  • How to Use DB2 NULLIF Function

    NULLIF returns a null value if the two arguments of the function are equal. If the arguments are not equal, NULLIF returns the value of the first argument. Example: NULLIF: Suppose that you want to calculate the average earnings of all employees who are eligible to receive a commission. All… Read More ⇢

    How to Use DB2 NULLIF Function

  • 3 Approaches to Modernize Mainframe Apps

    Mainframe modernization using Web services/SOA has, in recent years, become one of the most effective, efficient, and economical means to reach these goals. In manufacturing, telecommunications, energy, high tech, insurance, government, health care, education, and other industries, organizations have achieved remarkable results modernizing the mainframe with Web services/SOA. 3 Approaches… Read More ⇢

    3 Approaches to Modernize Mainframe Apps

  • 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… Read More ⇢

    COBOL: EXTERNAL file Vs GLOBAL file

  • 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… Read More ⇢

  • 6 Steps: How to Fix SQL Query Performance Issue

    Check SQL performance gaps explained complete steps in this tutorial Read More ⇢

    6 Steps: How to Fix SQL Query Performance Issue