Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

  • VSAM Quiz Questions Part-1

    All are latest questions. Check Quiz here. How to check VSAM dataset? EXAMINEYou can use the EXAMINE IDCAMS command to analyze and report on the structural integrity of the index and data components of a key-sequenced data set cluster (KSDS) and of a variable-length relative record data set cluster (VRRDS). Any problems with the VSAM data set will be…

  • COBOL: How to Code Logic To Insert Multiple Rows

    Multiple rows you can insert using arrays in COBOL program into DB2 tables

  • DB2 Connect: How DB2 to Use as Distributed

    DB2 Connect’s purpose in life is to connect applications to data, not one database to another database. Read more.

  • DFSORT: Convert Lower to Upper Case

    DFSORT Overlay command to change input dataset values to desired format. Read more on how to use it.

  • DB2- 5 Types of Utilities

    There are 5 kinds of Db2 utilities: Data Consistency utility: Check,Repair,Report,Diagnose Backup and Recovery Utility: Copy,CopytoCopy,Mergecopy,Quiesce,Recover,Rebuid index,Repair,Report recovery Data movement and Organization utility: Load,Unlod,Reorg Catologue manipulation utility: CATENFM, ATMAINT, DSNJCNVB, MODIFY RECOVERY, MODIFY STATISTICS, RUNSTATS,  STOSPACE Stand-alone utility:DSNJLOGF, DSNJU003,DSNJU004, DSN1CHKR, DSN1COMP, DSN1COPY,DSN1SDMP,DSN1LOGP,DSN1PRNT

  • SQL Query Raise_Error Function- Here’s Best Example

    Raise error function secrets given in this post. It tells how to use Raise error function inside of Case statement in DB2 SQL query.

  • 2 Ways to Earn Money in Software Job

    Basically software is a service based industry. Lot of brilliance and IQ not required. An average person can easily survive in this industry. Read more to earn money from IT job.

  • Alternative Careers for Mainframe Developers

    As demand for digital skills are growing, then many Mainframe developers are looking for best alternative career. The awesome list given here is highly useful.

  • DB2: How to Setup WLM to Run Stored Procedures

    Creating Stored proc to access DB2 programs written in Cobol,Java,PL1 is, in general 3 steps process. I have given in my other posts how to create stored proc. Still, for my readers I collected some more information. Point 1: Creating WLM environment Pont 2: Build JCL procedure Point 3: Create Stored procedure definition. Steps to Setup WLM You can…

  • How to Call DB2 Stored-procedure from IMS DB

    Call DB2 stored procedure from IMS program an example. Useful logic to use in your project.

  • How to Modernize Mainframe Batch Jobs (2 of 3)

    The most famous different methods that you can use to modernize batch process in mainframe. Read more.

  • How to Access Stored procedure in CICS popular example to invoke it

    Given here beautiful example to call stored procedure from CICS programs. This is a solution and ready to use code for your CICS programs using DB2.