Blog Posts - Mainframe



Why DB/DC does not support for Batch programs

The interesting point is DB/DC does contain both transaction manager and database manager. So this region supports to CICS to access IMS database. Except BATCH it supports for all kinds of transactions. Note: Pure BATCH runs under MVS address space.

What is Sort Status in COBOL

Sort status is like ‘File status’ in COBOL. With sort status clause, you can get sort or merge successful or not in the COBOL. The syntax is: Select file-name assign to dd-name Sort Status IS data-name1. It is two-char field. In the case...

Top stunning Questions on CICS ‘RETURN’ command

Return is one of the beautiful command in CICS, which passes control to  other program of next higher logical level, or to CICS. The LENGTH value in RETURN command should not be higher than the size of DFHCOMMAREA (32760 bytes max). The passing CHA...

Ten Top DFHCOMMAREA QUIZ Questions

1) How many ways you can pass data from one program to another program? -DFHCOMMAREA -CHANNELS -INPUTMESSAGE 2)What are the 3 commnds that you use in CICS to pass data to another program? -LINK, XCTL and RETURN 3)How to create a CHANNEL and Container...

How to Declare Read-Only Cursors in DB2

I am very cool today reading Db2 magazine. I have got an idea why can’t I write a post on DB2 Read-only cursors. So I have written this excellent post. There are so many rules to say a cursors is Read-only. Below are the list of rules, that sa...

DB2 Cursors Tricky interview Question

Q) Can we open the same cursor multiple times, when you use more than one DB2 subsystem ? A) The answer is ‘Yes”. Many programmers said ‘No’ to this question. But this is a tricky interview question. Recently my friend faced s...

Differences of DEDB Vs DL/I databases in IMS DB

DEDB - Often it is called data entry database. These kind of of databases will be used in Banking industry. And credit and Debit card processing projects. The implementation of DEDB is different from DL/I. Continue reading →...

How “SYSIBM.SYSDUMMY1” different from other catalog tables

The SYSIBM.SYSDUMMY1 table contains one row. The table is used for SQL statements in which a table reference is required. You can read here how many ways we can use SYSDUMMY1 table in DB2. Continue reading →...

Free Credit card processing Online Training

Below are the some interesting links for online credit card domain training. These are absolutely free. We need to have head/ear phones to listen. Lot of career opportunities are available if you  are good in Cards domain. After clicking the link, a...

Differences of DB2 SELECT, Sub-SELECT and Full SELECT

SELECT -The select-statement is the form of a query that can be directly specified in a DECLARE CURSOR statement or FOR statement, prepared and then referenced in a DECLARE CURSOR statement, or directly specified in an SQLJ assignment clause. It can...

MQSeries Tutorial for Mainframe Programmers (5 of 5)

A  queue manager is that part of an MQSeries product that provides the messaging and queuing services to application programs, through the Message Queue Interface (MQI) program calls.  It controls access to queues and serves as transaction (syncpoi...

JCL to SORT few fields in an input Dataset

//EXAMP JOB A492,PROGRAMMER //SORT EXEC PGM=SORT //SYSOUT DD SYSOUT=A //SORTIN DD DSN=A123456.SORT.SAMPIN,DISP=SHR //SORTOUT DD DSN=A123456.SORT.SAMPOUT,DISP=OLD //SYSIN DD * SORT FORMAT=CH, FIELDS=(110,10,A,145,17,A,1,75,A)/*Filed under: JCL, Mainfr...

‘SORTWORKdd’ is not mandatory in DFSORT JCL

Why SORTWORKdd is not mandatory: //SORTWKdd DD : Defines a work data set for a sort. Typically not needed, because DFSORT can allocate work data sets for a sort dynamically. Why STEPLIB not needed for SORT JCL: /STEPLIB DD : The DFSORT program would...

Frequently happen COBOL compilation errors

The following are the list compilation errors occurred during compilation of COBOL programs: Misspelling the name of a DIVISION. In Micro Focus Personal COBOL, misspelling IDENTIFICATION DIVISION produces an error of PROCEDURE DIVISION MISSING. This...

3 Ways of data movement in DB2

Method-1: Using DML INSERTs gets data into the DB2 tables, but it is not a feasible option for large amounts of data. The LOAD utility is needed for populating tables with large amounts of data. Method-2: For removing data from a DB2 table, we can us...

Top features of IMS DC MFS control blocks

The IMS message format service (MFS) is a facility of the IMS Transaction Manager environment that formats messages to and from terminal devices, so that IMS application programs do not deal with device-specific characteristics in input or output mes...

8 Index Access paths DB2 uses for SQL performance(1 of 2)

DB2 uses the following index access paths: Matching-index scan (MATCHCOLS > 0) Index screening Nonmatching-index scan (ACCESSTYPE = I and MATCHCOLS = 0) IN-list index scan (ACCESSTYPE = N) Multiple-index access (ACCESSTYPE is M, MX, MI, or MU) On...

Top Idea to restart a Batch Job in IMS DB -U102 error

Restarting Batch Jobs: Before you restart a DL/I batch job, ensure all database changes have been backed out. IMS™ might have backed out the database changes dynamically if a pseudo-abend occurred and you specified BKO=Y in the JCL and the data se...

PL/I top features of %PROCESS options -Compile time options (1 of 2)

The %PROCESS statement identifies the start of each external procedure and allows compile-time options to be specified for each compilation. The options you specify in adjacent %PROCESS statements apply to the compilation of the source statements to...

Top featutures of DB2 REPAIR Utility

The REPAIR utility repairs or fixes data in tables and their related data structures. The data can be of any type, such as data contained in a table or data that is generally not accessed, such as map pages and index entries. The options of the REPAI...


Trending Topics

Close