Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • DB2: How to create user-defined data type

    User-defined data types are like user-defined functions to create customized data types. UDD Type Example For example, CREATE DISTINCT TYPE AUDIO AS BLOB(1M); So now the “audio” becomes a new data-type. If we talk about user defined data types, there are 2 types. Distinct Type In this case, the only user-defined type is customized based on an…

  • 9 Daily Use SDSF Spool Commands

    Daily use top SDSF spool commands list.

  • Delete GDG cluster Sample JCL Example

    JCL to delete GDG and VSAM base cluster quickly.

  • How do we re-arrange Columns in SDSF spool

    How to arrange columns in SDSF spool in mainframe.

  • How to Resolve Pending States in DB2

    You will find three types of pending states in DB2. These are Copy pending, Release pending and Check pending. Here are the resolutions. First, we need to identify the pending state and determine the appropriate corrective action. Here are the three pending states and their respective corrective steps: DB2 Pending States Check Pending Reason: When…

  • DB2 Bind Options – And Their Correct Meaning

    DB2 bind options useful to know for compile or binding.

  • Explained SAS Macro Here’s Tutorial

    Simple SAS macro that filter input file and write into output data set. Explained all steps to execute a macro using JCL in mainframe

  • DB2 Bind Options This is the Example How to Use in JCL

    Sample DB2 batch jcl along with bind options given for your quick reference. Read more.

  • VSAM: KSDS, ESDS, LDS, RRDS Differences and Their Uses

    Top differences of VSAM RRDS, KSDS, ESDS and LDS

  • 7 Powerful ISPF Commands

    As a mainframe professional it is a challenge to give good productivity. As ISPF is the main editor we need to use ISPF commands extensively. FKA ON/OFF   ==>To display or hide function key info   RETF   ==>  to retrieve Last used command   SCRNAME  ==>  to give screen name   SCRNAME ON/OFF    ==> To on/off screen names  …

  • Mainframe Rexx for Beginners (1 of 3)

    REXX is a platform-independent Scripting Language. It uses extensively in the mainframe. It is a free-flow language. Let us take a simple program (Reference “Informit”) The above program is self-explanatory. Points: In my next posts, I will give details from starting of REXX and its usage in the mainframe.

  • Job Roles That are Popular in Tech Companies

    For example, assume you are working for a Software Company, one needs to know from the day one, which skills you need to have career success.