Recent Updates: Srinimf|Tech.Jobs.Biz.Success

Visit For Recent Updates.

This Blog Posts All Posts Directory Listings Articles

Use these Technics to improve COBOL Program Performance

11/25/2015 01:23:06 AM

Don’t open the file until you need it: The OPEN and CLOSE instruction generates a lot of excessive code, so the recommendation is to always put all of your files in the same OPEN and the same CLOSE. Well the default number of buffers in MVS is 5, s > read more

25 Awesome Things You Can Learn From These COBOL Interview Questions

11/23/2015 03:29:59 AM

1.Which one of the following is an INCORRECT specification for a data-nme? LAST-NAME 1234 12A3 SALES 2.Which of the following is an INVALID paragraph name ? a) 999 b) A-1 c) A+1 d) XX9 3.Level numbers range from _____  to _____ . a) 00,  49 b) 01, > read more

2 Types of Views Updatable and Read-only -Advanced SQL

11/22/2015 06:49:13 AM

Unlike base tables, VIEWs are either updatable or read-only, but not both. INSERT, UPDATE, and DELETE operations are allowed on updatable VIEWs and base tables, subject to any other constraints.INSERT, UPDATE, and DELETE are not allowed on read-only > read more

30 Awesome CICS Interview Questions to Your Next Job

11/22/2015 03:29:02 AM

What are CICS Control programs and their respective CICS control tables? PCT-KCP PPT-PCP FCT-FCP DCT-TDP JCT-JCP TCT-TCP TST-TSP Can we do Sort by the SORT verb in the CICS Program? No Can we open files explicitly in the CICS Program? NO.CiCS automat > read more

2 Easy Steps write your COBOL program efficient way

11/21/2015 03:13:02 AM

Always use an odd number of digits in a COMP-3 field  Since the COMP-3 field is stored as a single digit in a nibble (half of the byte), with one nibble consuming the space for the sign, we know that every time we reference an even number digit COMP > read more

DB2 LOAD And UNLOAD JCL Is Not Rocket Science! Here’s Why

11/20/2015 12:42:10 PM


Master CICS Release Command In Just A Few Minutes!

11/19/2015 05:16:01 AM

What is the function of RELEASE command in CICS? And why you need to use this command? The main function of LOAD and RELEASE commands are to reduce the storage used. The main benefit is dynamically we can LOAD a program to memory and we can issue CAL > read more

Enhance Your Assembler Language Skills while You Are Trying For Next Job

11/18/2015 20:15:21 PM

Filed under: Assembler Tutorial Tagged: Assembler Language Tutorial, Complete Assembler Tutorial > read more

Best Mainframe Interview Questions Tips You will Read This Year

11/16/2015 22:45:26 PM

Mainframe Interview Questions COBOL Interview Questions IMSDB Interview Questions DB2 Interview Questions VSAM Interview Questions CICS Interview Questions JCL Interview Questions PLI Interview Questions APPLY BIG ANALYTICSFiled under: Mainframe Inte > read more

Create Function in DB2 -Best example

11/16/2015 12:56:51 PM


Benefits of VSAM Verify command

11/15/2015 22:36:16 PM

VSAM provides you with several means of locating problems in your catalogs and data sets. You can also use the access method services REPRO command to copy a data set to an output device. The access method services VERIFY command provides a means of > read more


11/11/2015 07:55:28 AM

SYNCPOINT- Is thread safe command. It just establishes syncpoint. Syntax: SYNCPOINT—————————————————>< SYNCPOINT ROLLBACK – Back out to last s > read more

SQL Query to describe ‘NULL’ value -Best example

11/11/2015 05:52:26 AM

Table: DATA COL1     COL2    COL3 1           2          NULL SQL Query: SELECT col1 + col2, col2 + col3, col1 + col2 / col3 FROM data Question : What are the three values returned by the sample table and query above? Choice > read more

Unix and Mainframe Basic differences

11/11/2015 04:46:25 AM

Below are the basic differences for Unix and Mainframe: Boot the system versus IPL the system Files versus data sets Editors (vi, ed, sed, and emacs (UNIX)) versus ISPF (z/OS) telnet or rlogin (UNIX) versus TSO logon (z/OS) Filed under: Mainframe App > read more

Mainframe -Powerful features of Zo/s system

11/11/2015 01:52:08 AM

Below are the powerful features present in Zo/S system: Uses address spaces to ensure isolation of private areas Ensures data integrity, regardless of how large the user population might be. Can process a large number of concurrent batch jobs, with a > read more

Mainframe -OS/390 and ZO/s difference

11/11/2015 01:45:04 AM

This question asked for many mainframe programmers. They are unable to tell correct answer. For your benefit I am giving the basic difference. OS/390: This architecture runs under 32 BIT address space Z/OS: This architecture runs under 64-BIT address > read more

The ‘BPXBATCH’ utility to UNIX commands through JCL

11/11/2015 01:37:54 AM

The below is the sample JCL. You can use it to run UNIX commands through JCL. //COPYFILE JOB (INFO),’Execute UNIX’,CLASS=A,MSGCLASS=0, // MSGLEVEL=(1,1),NOTIFY=&USERID //NETCAT EXEC PGM=BPXBATCH //STDIN DD SYSOUT=* //STDOUT DD SYSOUT=* // > read more

How the Multiple versions of Package is useful in DB2

11/10/2015 04:33:25 AM

The below are the reasons, apart from our regular development, you need to keep multiple package versions in DB2. Sometimes we would like to keep multiple VERSIONs of the same PACKAGE. For example, in a fallback situation, it would be nice to have bo > read more

3 Top methods to keep Mainframe+COBOL programs Web enabled

11/09/2015 21:49:28 PM

I have identified three methods, which help to keep Mainframe and COBOL modules are web enabled. Use a mechanism like EXCI or a local queue to make a request to a CICS transaction or a WebSphere Application Server application running on the z/OS syst > read more

VSAM -How ESDS allows duplicate record

11/09/2015 12:08:52 PM

An entry-sequenced data set (ESDS) acts like sequential file organization but has the advantages of being under control of VSAM, some use of direct processing, and password facilities. Basically, the data set is in the sequence in which it is created > read more

How to run COBOL program with different versions of Db2 Package

11/09/2015 05:14:18 AM

Creating a package version: If you want to run different versions of a program without needing to make changes to the associated application plan, use package versions. This technique is useful if you need to make changes to your program without cau > read more

How you can use ‘DISPLAY UTILITY’ in DB2

11/08/2015 20:49:46 PM

The DB2® command DISPLAY UTILITY displays the status of utility jobs, including utility jobs in a data sharing group. The output from the command consists of informational messages only. One set of messages is returned for each job identified by the > read more

Big Data and Analytics with DB2 v11

11/08/2015 20:33:21 PM

Filed under: DB2 V11 Tagged: Big Data and Analytics with DB2 v11 > read more

Increase DB2 performance through data redundancy

11/08/2015 01:04:36 AM

It does not matter to a user why his or her database request failed. Whether a transaction timed out because of bad performance, or a component of the solution failed, or an administrator has taken the database offline to perform maintenance, the res > read more

EIBDATE in CICS and How to know when task is started in CICS

11/07/2015 18:40:48 PM

Contains the date the task is started; this field is updated by the ASKTIME command. The date is in packed decimal form (0CYYDDD+) where C shows the century with values 0 for the 1900s and 1 for the 2000s. For example, the date 31 December 1999 has t > read more

NVL and COALESCE functions basic differences in DB2

11/07/2015 16:17:43 PM

The NVL function returns the first argument that is not null. ==>NVL(expression1, expression2) The arguments are evaluated in the order in which they are specified, and the result of the function is the first argument that is not null. The result can > read more

CICS PIPELINE complete information

11/07/2015 10:57:30 AM

A CICS pipeline is shared by many different Web services, and is used to configure shared qualities of service. It is usually the CICS system programmer who is responsible for configuring PIPELINE resources. This is done using a pipeline configura > read more

How to pass a Channel to Local or Remote System in CICS

11/06/2015 12:27:30 PM

START CHANNEL >-START–TRANSID(name)–CHANNEL(name)————————–> –+——————–+–+——————-+—— > read more

How CONCAT Operator ‘||’ and CONCAT function are identical

11/05/2015 12:42:32 PM

CONCAT Operator ||: The operands of concatenation must be compatible strings. A binary string cannot be concatenated with a character string, including character strings that are defined as FOR BIT DATA . A distinct type that is based on a string typ > read more

How to write Reports using Esytrieve Plus -Complete tutorial

11/05/2015 07:30:56 AM

Filed under: Easytrieve, Eazytrieve Tagged: File Commands in Easytieve, Report writing with Easytrieve, Sample JCL to run Easytrieve program > read more

The CA-7 Job Scheduling Tool Complete Commands

11/04/2015 21:30:28 PM

CA-7 is a job scheduling / workflow automation software package sold by CA Technologies (formerly CA, Inc. and Computer Associates International, Inc.). It is commonly used by banks and other large enterprises with IBM mainframe IT computing platform > read more

PegaSystems Career for Mainframe Programmers

11/01/2015 06:39:56 AM

Many guys asked us in Facebook page-Mainframe-SriniBlogs and at SrinimfJobs about suitable career for Mainframe programmers. Let us see how PegaSystems career helpful to Mainframe developers. Below Skills are expecting for PegaSystems developer: UI w > read more

VbScript QUIZ

11/01/2015 02:16:28 AM

Filed under: VBScript Tagged: VbScript QUIZ > read more

BMP Transaction oriented JCL in IMS DB

10/31/2015 07:58:26 AM

Many mainframe /IMS programmers think that BMP means batch. Actually there are two kinds of transactions. One is BMP(Batch) and the other one is BMP(Txn oriented). Usually MPPs are scheduled by IMS. But BMP(txn) are scheduled by an operator through J > read more

How to Check Spool which Database calls used in IMS DB batch JCL

10/31/2015 00:51:13 AM

The following are the different methods can be used to know Buffer usage and the kind of database calls used in the IMS programs. The IMS monitor, to gather details of buffer usage and database calls over a specified time period in an IMS subsystem. > read more

Why DB/DC does not support for Batch programs

10/30/2015 00:38:45 AM

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. DBCTL- Since this region does installed only da > read more

What is Sort Status in COBOL

10/29/2015 01:05:43 AM

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 > read more

Top stunning Questions on CICS ‘RETURN’ command

10/28/2015 05:39:14 AM

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 > read more


10/27/2015 00:13:23 AM

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 > read more

Machine Learning Quiz for Developers

10/25/2015 04:59:43 AM

Filed under: Machine Learning Tagged: Machine Learning Quiz for Developers > read more

Complete Information on COBOL Indexed files

10/24/2015 07:30:00 AM

The below is the life cycle of Indexed files in COBOL program: Defining an indexed file Opening and closing indexed files Reading through a file Adding records to indexed files Looking up records in indexed files Changing records in indexed files Del > read more

Acquirer Batch reconciliation process in Credit Card Payments

10/23/2015 18:30:16 PM

The below are the general guidelines followed by acquirer for Batch reconciliation or Debit reconciliation in Credit card payment processing Systems. A merchant statement is sent to merchants daily, weekly or monthly in accordance with the Agreement > read more

Top differences of Host based and Terminal based Reversals in Credit card payments

10/23/2015 05:43:28 AM

Below post tells how Host based reversals and Terminal based reversals happen in Credit/Debit cards processing. List of Reversals: Connection timeout Read Timeout Host based reversals (Timeout reversals) Terminal based reversals Connection Timeout: C > read more

Five Facts About Db2 Cursors That Will Blow Your Mind

10/23/2015 00:35:13 AM

These are some of the interesting points on DB2 Cursors. The Cursor WITH HOLD does not impact on IMS DC programs. In CICS, the WITH HOLD does maintains Cursor position till end of the unit of work Cursors will not be closed by ROLLBACK operation, eve > read more

DB2 Cursors Tricky interview Question

10/22/2015 18:08:22 PM

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 > read more

How to Declare Read-Only Cursors in DB2

10/22/2015 07:50:03 AM

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 > read more

Free Credit card processing Online Training

10/20/2015 19:50:01 PM

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 > read more

How “SYSIBM.SYSDUMMY1” different from other catalog tables

10/20/2015 09:58:26 AM

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 → > read more

Differences of DEDB Vs DL/I databases in IMS DB

10/20/2015 07:30:00 AM

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 → > read more

Differences of DB2 SELECT, Sub-SELECT and Full SELECT

10/19/2015 05:31:51 AM

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 > read more

MQSeries Tutorial for Mainframe Programmers (5 of 5)

10/17/2015 11:49:58 AM

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 > read more

‘SORTWORKdd’ is not mandatory in DFSORT JCL

10/16/2015 17:19:31 PM

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 > read more

JCL to SORT few fields in an input Dataset

10/16/2015 13:18:45 PM


Frequently happen COBOL compilation errors

10/15/2015 16:03:44 PM

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 > read more

Limitations of COBOL intrinsic functions

10/15/2015 07:49:43 AM

An intrinsic function is actually a call to a subroutine that acts like a data item, you can’t use an intrinsic function as the destination of a MOVE or in any command that attempts to use it as a destination type data item. An intrinsic func > read more

Aggregate functions Vs Scalar functions in DB2

10/13/2015 20:11:50 PM

Functions in DB2: A function is an operation denoted by a function name followed by zero or more input values that are enclosed in parentheses. It represents a relationship between a set of input values and a set of result values. The input values to > read more

‘CEILING’ scalar function in DB2, the result can be NULL

10/13/2015 16:02:06 PM

CEILING The CEILING function returns the smallest integer value that is greater than or equal to the argument. Syntax is CEILING(numeric-expression) The schema is SYSIBM. The argument must be an expression that returns a value of any built-in numeric > read more

DB2 Large object data types- Advantage of LOBs

10/12/2015 19:37:42 PM

You can use large object data types to store audio, video, images, and other files that are larger than 32 KB. The VARCHAR, VARGRAPHIC, and VARBINARY data types have a storage limit of 32 KB. However, applications often need to store large text docum > read more

File open should be ‘Input’ or ‘I-O’ in COBOL START statement

10/12/2015 16:13:52 PM

The START statement is the best option in COBOL to deal with indexed files. In this post you will learn also best interview questions asked; What is KEY IS How record will START in this file position Exception handling The format of the START stateme > read more

DB2 ‘Aggregate’ function tricky questions

10/11/2015 09:35:46 AM

An aggregate function receives a set of values for each argument (such as the values of a column) and returns a single-value result for the set of input values.  The following information applies to all aggregate functions, except for the COUNT(*) a > read more

Introduction to VBScript – (1 to 9) Videos

10/10/2015 22:36:57 PM

Filed under: VBScript Tagged: Introduction to VBScript Video Tutorials > read more

ISPF Mainframe Certification Commands

10/10/2015 18:00:07 PM

EDITING A DATA SET – If you do not know the Data Set Name: Obtain a list of data sets using screen 3.4 Tab to the left of the desired data set, type e for edit and press Return. This will bring the data set up in a full-screen editor. If you k > read more

DB2 ‘OPEN’ Cursor unsuccessful probable reasons

10/10/2015 16:52:28 PM

The ‘OPEN’ cursor fails during execution of the DB2 program is mainly due to lack of privileges. The privilege set consists of the privileges that are held by the authorization ID of the owner of the plan or package. If the plan or packag > read more

How to write a macro in Stratus COBOL

10/10/2015 15:45:55 PM

Filed under: Stratus, Stratus COBOL Tagged: Macro writing tips in Stratus COBOL > read more

IBM Q-Replication in Zo/s environment

10/09/2015 15:50:54 PM

High Availability Solutions on the IBM z/OS Platform: Functionality of Q-Replication: They replicate data from and to one or more DB2 for z/OS nodes within a site or across sites They require a high throughput replication solution that keeps up with > read more

MQSeries Tutorial for Mainframe Programmers (4 of 5)

10/09/2015 11:33:31 AM

Terminology used in MQSeries: Queue Manager: A queue manager is a program that provides messaging services to applications. Applications that use the Message Queue Interface (MQI) can put and get messages from queues. The queue manager ensures that m > read more

DB2 Global variables in version 11

10/07/2015 11:45:46 AM

Traditionally within a relational database system, most interactions between an application and the DBMS are in the form of SQL statements within a connection. To share information between SQL statements within the same application context, the appli > read more

How DB2 Stored procedure is beneficial in the below scenario

10/07/2015 06:04:14 AM

In which of the following scenarios would a stored procedure be beneficial? a)An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa b)An application running on a remote client needs > read more

How to access “IMS DB” database using SQL Queries(1 of 2)

10/06/2015 06:17:16 AM

Like DB2 you can access IMS DB database using SQL queries. How you can access, basic steps required are as follows: Changes required in DBD (database descriptor) Need IMS connect IMS V13 is needed, which supports accessing IMS DB through SQL Queries > read more

Java collections for Mainframe programmers

10/05/2015 05:54:53 AM

What is collections: Collections provide the ability to manage groups of objects. A collection can be ordered or unordered, contain duplicates or not, depending upon the particular implementation chosen. Collections can also contain key-value pairs t > read more

How to identify a given module is Subroutine in COBOL programming

10/05/2015 00:11:13 AM

In COBOL programming, the subroutine needs the following three clauses. With these you can say the module is subroutine or main module. Linkage section In procedure division USING At the end of program, either, EXIT PROGRAM or GOBACK With the above c > read more

Can “STOP RUN” be given in COBOL subroutines

10/04/2015 11:20:32 AM

The statement “STOP RUN” be given usually in calling modules. When the “STOP RUN” statement encounters, this tells COBOL run time unit to stop execution of COBOL program. This is the reason, it cannot be given in subroutines. > read more

COBOL subroutine why “EXIT PROGRAM” is mandatory

10/04/2015 08:07:12 AM

In COBOL program there are three key phrases. Those are STOP RUN, GOBACK and EXIT PROGRAM. The phrase EXIT PROGRAM can use in subroutine. What happens if it has given: This statement “EXIT PROGRAM” gives control back to calling module. So > read more

How to write ‘COBOL Program’ in DB2 stored procedure Zo/s

10/03/2015 11:14:40 AM

I want to add more points on how to write COBOL program in DB2 stored procedures. The functionality of below stored procedures is: Searches the catalog table SYSROUTINES for a row matching the input parameters from the client program. The two input p > read more

How to create DB2 Stored procedures in ZO/S

10/02/2015 23:49:35 PM

Workstation-based development tools can help you create, install, and test stored procedures for DB2® for z/OS®. Stored procedures are portable across the entire family of DB2 servers including DB2 for z/OS, DB2 for i, and DB2 for Linux, UNIX, and > read more

Top differences of COBOL 66 Level and Redefines clause

10/02/2015 07:39:49 AM

COBOL 66 Level The 66 level assigns an alternate name to a field or group. It doesn’t add a new field to the record, it just assigns an alternate name to an existing field. You must use the level number 66 for data description entries that cont > read more

COBOL “Search” and “Search all” differences

10/02/2015 00:15:08 AM

As you aware SEARCH and SEARCH ALL both are COBOL reserved words. You can use these two to search COBOL tables. How to code these two and key differences is a question. This has been asked many times in interviews. SEARCH: SEARCH can be used in COBOL > read more

Informatica version 9.6 latest features

10/01/2015 06:19:27 AM

Informatica version 9.6 added many new features in various categories. The below post tells some of the important enhancements in the new version. You can read informatica version 9.5 enhancements here. Informatica Analyst: The following work spaces > read more

How to Copy HFS files to ZFS files in Mainframe

09/30/2015 09:37:41 AM

HFS and zFS are both used with Unix System Services but zFS is IBM’S preferred file system for Unix System Services files. From the Unix standpoint there’s no difference in HFS and zFS as far as mounting directories, the hierarchical stru > read more

COBOL file status codes 37, 38 and 39

09/30/2015 00:25:54 AM

OPEN -37 – For sequential and relative files, the specified open mode is not supported by this file. OPEN -38 – For sequential and relative files, the file was previously closed with lock. OPEN-39– For sequential and relative fil > read more

JavaScript and AJAX for Mainframe programmers

09/29/2015 08:19:20 AM

Now a days many applications are going online. Lot of websites are creating to be more informative for users. As a mainframe programmer, learning JavaScript will help you understand how latest technologies working. You can do career transition. JavaS > read more

How De-editing works in COBOL-85

09/29/2015 00:13:55 AM

De-editing occurs when an elementary item with a PICTURE clause containing editing characters is MOVEd to a similarly defined elementary item, but without the editing characters. By “similarly defined,” I mean numeric edited to numeric, or alphan > read more

Differences of COBOL tables vs Java arrays

09/28/2015 00:26:03 AM

I learned Java and I am getting benefit. Read/follow my blogs, so you will also become valuable developer. COBOL Multiple dimensions (maximum seven). Fixed in size at compile time, unless you use the OCCURS DEPENDING ON clause, which specifies the mi > read more

Hierarchical file system (HFS) in Mainframe UNIX (2 of 2)

09/27/2015 21:27:31 PM

Hierarchical File System is a UNIX compliant file system that runs under z/OS UNIX System Services. HFS has been functionally stabilized and will eventually be dropped from support. zFS is IBM’S preferred file system for Unix System Services fi > read more

How to use UNIX files in Mainframe Batch job

09/27/2015 06:34:26 AM

HFS files are designed to run in a UNIX environment, you can still access them through a batch job. The JCL you use is a little different, though, than for standard data sets. Zo/s provides some additional parameters for the DD statement that allow y > read more

Mainframe: Replace spaces in input file with a String

09/27/2015 06:13:56 AM

If I find a space in position 63-72, I need to replace with 9999-99-99.Is there any way to perform this? My Input looks like the following records. Input: —————————————R > read more

How to resolve ‘CICS’ production abends in Mainframe

09/26/2015 00:13:31 AM

How to determine the cause of an abend Locate the correct dump in the dump listing. TASK=xxxx in the dump heading indicates the trans-id for the bending task. DATE= and TIME= in the dump heading indicates the date and time of the abend. Note the aben > read more

How ‘XCTL’ command useful in Mainframe -CICS programs

09/25/2015 06:42:35 AM

This questions is asked in many interviews. Still, many people do not know when to use ‘XCTL’ command. I want to make very clear about this command. Below is the syntax: Exec CICS XCTL PROGRAM(program-name) [COMMAREA(data-name)] END-Exec > read more

MQSeries Tutorial for Mainframe Programmers (3 of 5)

09/24/2015 23:57:59 PM

Below are key MQSeries calls need to write in COBOL program. Read MQSeries with COBOL sample program. In this post you will learn how to write different calls in COBOL program. The working storage section of any MQ series program usually carries the > read more

DB2 SQL Procedure Basics for Mainframe Programmers (1 of 2)

09/24/2015 00:29:31 AM

In oracle we say Procedural language as PL/SQL. But, in DB2 we need to say like SQL Procedure. How to declare data types DECLARE v_salary DEC(9,2) DEFAULT 0.0; DECLARE v_status char(3) DEFAULT ‘YES’; DECLARE v_descrition VARCHAR(80); DECLARE v1, > read more

MQSeries Tutorial for Mainframe Programmers (2 of 5)

09/23/2015 00:17:06 AM

API CALLS- MQCONN / MQCONNX / MQDISC MQCONN connects the application to a named queue manager. If successful, a handle is returned that is passed to all subsequent MQ calls. MQCONNX is a variation of MQCONN, but it establishes a “trusted” connect > read more

JCL -How to run only one step in a Job

09/22/2015 00:11:40 AM

The following are the different methods to execute only one step in a Job: Consider a situation. I have a JCL with 10 steps. For reasons known only to me, I want to execute step 5 only. How can I do it? 1.One way to do it is to use RESTART from STEP > read more

How System Failure and Server Failure Handles in DB2

09/22/2015 00:04:25 AM

BACKUP and RESTORE restore data over several possible system problems: System Failure: If the system holding the database crashes or stops working, all the data in it is lost. You cannot recover this data without a database backup. Unpredictable Err > read more

JAVA for Mainframe coders -COBOL Subroutine Vs JAVA Class

09/21/2015 00:23:12 AM

A COBOL subroutine is a source file that contains COBOL code and implements a logical function. It is organized so that other programs can prepare the appropriate information, call the subroutine, and perform the function. Subroutine parameters are d > read more

COBOL -‘ON SIZE ERROR’ receiving field is not modified

09/20/2015 00:11:22 AM

The following is the general format of arithmetic statements with the ON SIZE ERROR phrase: arithmetic statement [ON SIZE ERROR imperative statement] [NOT ON SIZE ERROR imperative statement] [END-arithmetic verb] As with ROUNDED, the arithmetic state > read more

How to protect files over written in UNIX

09/19/2015 06:39:32 AM

You can use the “noclobber” shell variable to avoid accidentally overwriting an existing file. It’s a good idea to include this variable in your shell startup file, such as the .cshrc file, as shown here: $set noclobber The noclobbe > read more

How to compare Two files in UNIX with ‘diff’ command

09/19/2015 00:35:55 AM

Comparing Files The diff command compares two files, returns the line(s) that are different, and tells you how to make the files the same. Here’s an example: $ diff test.two 0a1 New Test. This diff command output tells you that if you > read more

.NET for Mainframe Programmers- Best book

09/18/2015 04:04:29 AM

The important points in the .NET are as follows: Programming language choice Programming language support Development environment Collection of class libraries Virtual machine and runtime Object-oriented technology Different .NET compilers are availa > read more

5 Root Causes to identify for Performance issues in DB2

09/17/2015 21:41:24 PM

Performance in DB2 is caused by many reasons. As a Developer you need to focus on Tuning SQL. As a performance expert or DBA you need to focus on using of Tools and analyzing performance with tools. The below post gives an idea on how you can start y > read more

4 Types of Triggers in DB2

09/17/2015 02:09:34 AM

What Is a Trigger? Simply stated, a trigger is a piece of code executed in response to an SQL data modification operation; that is, an insert, update, or delete driven by an INSERT, UPDATE, DELETE, or MERGE statement. To be a bit more precise: Trigge > read more

© 2006-2015, All Rights Reserved