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

  • 5 TSO Cmmands You Need to Know

    Top TSO commands mostly used by all the programmers in their day to day job.

  • IMS DB: Top Proc Options to Use in PSB

    PROCOPT in PSB of IMS DB

  • IMS DB- SENSEG and SENFLD in PSB

    Sensitive Segments: In a PSB maximum of 30,000 SENSEG statements we can code as per IMS V11. In PSB macro; Col…10      Col..16                                                                Col…72 PCB             TYPE=DB,DBDNAME=DATABASE,           X                     PROCOPT=A,KEYLEN=22SENSEG     NAME=A,PARENT=0,PROCOPT=G So, every PCB refers to a database. The description for each segment is already defined in DBD. So the segments we defined in PSB of PCB statement are called sensitive segments.  Sensitive fields:…

  • IMS DB-Command Code ‘D’ and Proc Option ‘P’

    Command codes enhances the database search in IMSDB. I want to say here about “D” command code and “P” proc option. Command Code Vs Proc Option We need to give Command code ‘D’ in all the SSAs top to bottom, except for last segment. Proc option-Indirectly acts as exclusive locks. “P” proc option is required PROCOPT=P in…

  • IMS DB: Why PCBs Must Give In Sequence In ENTRY

    As we all know, PSB is a database, it represents database view to the application program. And, PSBs are combination of various PCBs. So each PCB represents to one segment. In the PSB generation, we can code in PCB blocks of sensitive segments and sensitive fields. To run each batch program , we need to supply Program-name and PSB-name in JCL thru Parm parameter. PARM=(DLI, Program-name,PSB-name,,,).…

  • SQL Commit Vs Rollback: Syntax to Write in COBOL

    COMMIT statement ends the logical unit of work. Commit in SQL ROLLBACK in SQL