The well explained ideas in SQL query how you can include sequence is given here for your quick reference. These also useful for learning SQL.
The big data process sometimes it is complex. To get the desired result we need quality data and help from many people. Read more.
The awesome advantages of of VSAM make still VSAM files are popular in mainframe. It has its own advantages and dis-advantages. Read more.
These are the ways you can submit JCL to JES from CICS. Then CICS provides an interface to JES to submit JCL. Read more.
The following are list of most commonly used errors in CICS. The list is bigger but to make it simple here I have given common error codes that you get in projects in your day to day development.
The power filled CICS tutorial terribly useful for developers and production support people. Read more.
The best way of writing SQL select query in SQL to avoid ambiguous column issue. Mostly people confuse with alias concept. This SQL query using alias in SELECT is beneficial to apply in your current project.
CLIST is an interpreted language. CLISTs can be run in background (by running JCL which executes the TSO control program (IKJEFT01)). Read more with examples.