-
DFSORT: Convert Lower to Upper Case
DFSORT Overlay command to change input dataset values to desired format. Read more on how to use it. Read More ⇢
-
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 Read More ⇢
-
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. Read More ⇢
-
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. Read More ⇢
-
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. Read More ⇢
-
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… Read More ⇢
-
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. Read More ⇢
-
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. 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. Read More ⇢
Srinimf 