-
DB2: How to Fix Column MASK Error When You Use GROUP BY
SQL Query to create column mask is CREATE (OR REPLACE) MASK (NAME) ON (TABLE) FOR COLUMN (NAME)RETURN (EXPRESSION) ENABLE (OR DISABLE)ALTER TABLE (NAME) ACTIVATE COLUMN ACCESS CONTROL Why COLUMN Masking? Essentially a data mask is nothing more than displaying a value based on a rule for a specific column. Row… Read More ⇢
-
How JCL Job Execution Works: 5 Essential Steps Explained
Here are the stages of JCL job execution. ZO/S uses Job Entry Sub-system (JES) to process jobs into the operating system. Input Phase JES2 jobs can be entered on input devices such as card readers, remote terminals, or other programs. Jobs can also come from other nodes in a job… Read More ⇢
-
Here is Why You Need to Learn Java for Hadoop Jobs
Hadoop projects slowly coming to all big companies. This is the time you to refresh your skills, and try for good career opportunities. Many programmers including Mainframe developers asked this question that the suitable course. The answer is learning basic java is highly useful to learn Hadoop and Big data related… Read More ⇢
-
Sample DFSORT JCL to Sort Three Input Files
How sort 3 input files in dfsort best jcl example Read More ⇢
-
DFSORT Best Example, How to Use Multiple Overlay
The example in this post tells you how to use the OVERLAY parameter, which is useful to overwrite the current field-values with new ones. Read More ⇢
-
QMF Export Report to Excel or Word document
The export command in QMF. You can use it to export your SQL query to a data set where you can use it for future use. Read More ⇢
-
Here is Logic to Use Variable-length Records Linkage Section
Many mainframe programmers asked -Can give VB record in Linkages Section. The answer is yes. Below is the best example for VB Record: Variable Length Record COBOL Related Read More ⇢
-
How to Use DFSORT Utility in JCL
Here is parameters explained that you need for JCL job when you use DFSORT utility. Read More ⇢
-
DB2 Synonyms Vs Alias -7 Top Differences
DB2 Synonyms Synonyms can be thought of as alternative names for tables and views. No authorization is required to define a synonym. A synonym designates a synonym when it is preceded by the keyword SYNONYM, as in CREATE SYNONYM and DROP SYNONYM. In all other contexts, a synonym designates a local… Read More ⇢
Srinimf 