Srinimf

Blog

srinimf.com/

Blog

srinimf.com/

Profile

srinimf.com/author/moonrobot/

Profile

srinimf.com/author/moonrobot/

Homepage

srinimf.com

Homepage

srinimf.com

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

  • Learn NoSQL Beginner’s’ Course for Data Analysts Video

    Complete tutorial for NoSQL. NoSQL Overview Related

  • Here’s Logic to Access CICS from DB2 Stored Procedure

    There are 2 ways we can access CICS from DB2 stored procedure. Method:1 Preparing CICS and WLM for EXCI Prior to executing a stored procedure that invokes EXCI, you must define the following resources on the resource definition screen in the CICS region where the CICS program will execute: connections, sessions, transaction, program, and any files accessed. You can…