Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

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

  • Data Science Concepts for Mainframe Developers: Video Simplified

    Basics of data science concepts helpful video for mainframe developers.

  • 5 JCL Cataloged Procedure Interview Questions

    The popular questions given here on JCL cataloged procedure. These are so basic but asked in many interviews. Read more.

  • COBOL: All About Null-terminated Strings

    Even though I was busy in my work, I decided to spend some time for our readers on technical help.  COBOL strings is a key subject  and across all the big mainframe projects (Finance, Insurance and Manufacture) without strings there is no COBOL code. The below codes helps to implement in your projects: Working storage variables…

  • IBM Z13: Top Features You Should Know

    IBM Z13 new features is now trending in almost all big projects. Learn now the real functions.

  • DB2: 4 Top INSERT SQL Queries

    Top questions on DB2 SQL insert values and how to find errors explained.

  • Digital Skills That a Mainframe Developer Can Learn Easily

    This is the time for Mainframe programmers to learn digital skills. The main reason is opportunities are very few in the market for Mainframe Skills. Why mainframe skills not only enough? The reason is Mainframe works still on legacy skills. But IBM is doing a lot of research to bring the mainframe to the next…

  • JCL Temp Dataset With disp ‘KEEP’ or ‘CATLG’

    The data set in JCL can have three possible options one is KEEP, CATLG and PASS. Each has its own usages. Keep reading more.

  • How to Browse TCT, PPT, FCT, PCT entries in CICS

    How to browse TCT table data? Use command DSPCICSTCT to browse entries in TCT (Terminal Control Table). Only you can browse the data, but you cannot change or delete it. How to browse PCT table data? Use command DSPCICSPCT to browse entries in PCT (Program Control Table). Only you can browse the data, but you cannot change…

  • CICS COBOL Program Example

    Identification Division.==>No differencesEnvironment Division==>MUST be EMPTY in CICS Program!No SELECT statements allowed!Data Division==>No FILE SECTION – (No SELECTS) Data DivisionWORKING-STORAGE SECTION.Switches, Flags, Variables, Records, etc.You get ‘fresh’ copy each time program loaded!LINKAGE SECTION  (New Item!!)DFHCOMMAREA defined or CICS will!Used to receive data from CICS.CICS also inserts EIB Block definition Procedure DivisionUses most  COBOL statementsAlso uses…