- Blog
- Blog
- Homepage
- Homepage
-
PLI Presentation for Mainframe Programmers
The best Tutorial on PLI for Mainframe developers. This is an awesome presentation given step by step details with examples and compile and run jcl.
-
QMF Commands for Senior Mainframe Programmers
The useful QMF daily use commands for mainframe programmers. You can save your time with these commands.
-
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 at this table by using…
-
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 DFSORT, REXX, COBOL program. DB2…
-
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 programming, the EVALUATE verb makes…
-
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.
-
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 eligible employees have a commission…
-
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 Using a Web services engine,…
-
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 paragraph names are private to…
-
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 that enterprises will invest more…
-
6 Steps: How to Fix SQL Query Performance Issue
Check SQL performance gaps explained complete steps in this tutorial
-
IMS DB Tutorial Learn Quickly
Complete tutorial on IMS DB for learners and developers highly useful.
Srinimf 
You must be logged in to post a comment.