- Blog
- Blog
- Homepage
- Homepage
-
Easytrieve Guide for Mainframe Programmers (2 of 20)
Easytrieve Part-2,
-
DB2- Use of ‘COALESCE’ Function (2 of 2)
Usage of COALESCE function, and detailed explanation given in this post. The given example helps you to handle NULL values in SQL rows returned from the table. Syntax for COALESCE function Explanation The COALESCE function will inspect its parameter list and return the first non-NULL value, so this converts the AVG() parameter from NULL to…
-
Easytrieve Guide for Mainframe Programmers (1of 20)
Basic Easytrieve to start with reporting tool. This is part-1 Tutorial.
-
TPPCB Structure in IMS DB/DC
TPPCB structure useful for IMS DB or DC programs.
-
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,…
Srinimf 