-
How to Create Report Using DFSORT
The best way of writing DFSORT JCL to create awesome reports using Headers and Trailers. You will know meanings for different Trailer numbers. Read More ⇢
-
DB2: How to Bind Package Versions
You are very much familer with versions in DB2 package. These simple ideas help you to understand about package versions very neatly and clearly. Read More ⇢
-
Two SQL queries on Self-join and Inner-Join
Self join vs Inner join learn here using the best examples. Read more. Read More ⇢
-
21 Tricky COBOL Interview Questions You Need
Q1. What are the differences between COBOL and COBOL II? A1. There are at least five differences: COBOL II supports structured programming by using in line PERFORMs and explicit scope terminators, it introduces new features (EVALUATE, SET .. TO TRUE, CALL .. BY CONTEXT, etc), it permits programs to be… Read More ⇢
-
Top JCL Statements You can Refresh now
In JCL refresher 2, you will learn basic syntax to be used in job control language. Syntax something like how to give comments, other mandatory syntax details given in this post. Read More ⇢
-
JCL refresher#1: What is JCL
JCL is a job controlling language. You will learn how jcl works, and what is the use of it in mainframe in JCL refresher#1. Read More ⇢
-
JCL: How to Use PDSMAN Library Management Utility
Library management is an everyday task in Mainframe. The CA PDSMAN utility written in JCL absolutely help you improve productivity. Read More ⇢
-
SQL Query: How to fetch Salary of Same Hiredate
Power filled SQL query to retrieve data like Salary and Hire date from an EMPLOYEE table. Read More ⇢
-
SQL- How to Create Updatable and Read-only Views
You can write fantastic SQL in this way so that you can avoid updatable VIEWs in your project. Two rules you can blindly use to determine if your VIEW is Read-only or Updatable in DB2. The most important point is you can UPDATE Read-only Views with this approach such as… Read More ⇢
Srinimf 