Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • COBOL mostly asked Interview Question on Files

    The mostly discussed and frequently asked questions on COBOL files.

  • 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 access control is specifically geared…

  • 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 entry network and from internal…

  • 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 courses. I would like to…

  • Sample DFSORT JCL to Sort Three Input Files

    How sort 3 input files in dfsort best jcl example

  • 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.

  • 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.

  • 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

  • How to Use DFSORT Utility in JCL

    Here is parameters explained that you need for JCL job when you use DFSORT utility.

  • 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 table or view and can…

  • How Real-life Data Science Project Looks

    Data science enables the creation of data products. One of the earlier data products on the Web was the CDDB database. Read more.

  • Here’s How to Alter Column Datatype in SQL

    SQL query to alter datatype ALTER TABLE BOOKS ALTER BOOKNAME SET DATA TYPE VARCHAR(200) ALTER ISBN SET DEFAULT ‘UNKNOWN’; Certain characteristics of a table cannot be changed. For example, you cannot change the table space in which the table resides, the order of columns, or change the data type of a column to an incompatible data type…