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

Visit For Recent Updates.

This Blog Posts All Posts Directory Listings Articles

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

How Logging happens in DB2 when CREATE,INSERT and DELETE

09/17/2015 00:10:23 AM

When changes are made to the data in tables, subsequently changing the table space and index spaces, DB2 writes one or more records to its log so that a backout of the changes can be performed if the unit of work fails. DB2 can also use this informat > read more

Mainframe- Sending PDF to a email id using Batch JCL

09/16/2015 22:17:56 PM

The below JCL sends PDF ( report which is present in a data set ) to a email id you want to send. Receiver will get an email with PDF as an attachment. JCL for XMIT pdf //???????X JOB (????????,????,1439,9999,9999),XMITIP-SAMPLE, // CLASS=?,MSGCLASS= > read more

3 Ways of data movement in DB2

09/16/2015 02:05:43 AM

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

What is the difference between Data warehousing and Business intelligence

09/16/2015 00:09:00 AM

Data warehousing deals with all aspects of managing the development , implementation, and operation of a data warehouse or data mart including meta data management, data acquisition, data cleansing, data transformation, storage management, data distr > read more

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

09/15/2015 00:03:46 AM

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) One-fe > read more

Top features of IMS DC MFS control blocks

09/14/2015 23:59:23 PM

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

Perl programming for UNIX automation

09/14/2015 06:09:26 AM

Overview: Perl is a high-level, object-oriented programming language that supports many programming concepts found in languages such as C and C++. Moreover, for many Unix system administrators, Perl is the tool they depend the most on when it comes > read more

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

09/13/2015 21:39:22 PM

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

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

09/12/2015 01:53:57 AM

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

Top featutures of DB2 REPAIR Utility

09/11/2015 05:30:14 AM

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

MQSeries Tutorial for Mainframe Programmers (1 of 5)

09/10/2015 00:37:16 AM

Middleware : “Middleware is software that is used to move data from one program to another, shielding the developer from dependencies on communications protocols, operating systems and hardware platforms.” Middleware products tend to fall in one > read more


09/09/2015 01:52:21 AM

-180 THE DATE, TIME, OR TIMESTAMP VALUE value IS INVALID Explanation The length or string representation of a DATE, TIME, or TIMESTAMP value does not conform to any valid format. The value can contain one of the following: For a host variable, the po > read more

Top DB2 concurrency features Lost Updates, Dirty Reads, Phantoms

09/08/2015 00:41:25 AM

When transactions are not serializable (which is often the case in multi-user environments): Lost Updates: This event occurs when two transactions read the same data and both attempt to update that data, resulting in the loss of one of the updates. F > read more

COBOL Usage is Pointer data item

09/07/2015 01:57:48 AM

Another extension of the USAGE clause is to define data items that contain addresses of data or procedures. These are POINTER items: POINTER A four-byte data item that holds the address of another data item. PROCEDURE-POINTER A four- or eight-byte da > read more

Mainframe TSO, how to get all the PDS to which a member belongs to

09/04/2015 00:00:56 AM

If you want to find a member but you don’t know the PDS to which it belongs and you only know the High level qualifier of the PDS. For example: Let’s consider High level qualifier as RF01.pp258c.* and member as RG57TDLT. Go to 3.4 and list all PD > read more

How to keep command does not disappear in TSO command line

09/02/2015 23:53:22 PM

Any command entered in the COMMAND LINE disappears after the successful execution of its intended function. If you want to repeat the same command , you got to re-type it or use some PF key to retrieve the last command entered. But here is a cool met > read more

3 Key points of Acquire BIND option in DB2

09/02/2015 00:21:35 AM

Acquires is one of the BIND options in DB2. Continue reading → > read more

How to know your version of DB2 in Mainframe

08/31/2015 10:27:26 AM

A tricky question for Mainframe DB2 programmers. Question is where I get information about DB2 version of sub system. The below post answers to this question. Secondly, each DB2 sub system can have different version of DB2. AS DB2 goes through V8, V9 > read more

2 Top features of IBM DB2 CHECK DATA utility

08/31/2015 04:20:23 AM

The CHECK DATA option checks the violation of the referential integrity rules between two tables. It also checks whether data values conform to the data validation constraints applied to the table space that is specified with the utility command. For > read more

Top features of SAS 9.2 for Mainframe projects ( 1 of 5)

08/30/2015 06:08:28 AM

How many ways you can invoke SAS in Mainframe: You can invoke SAS with any of the following methods: in interactive mode under TSO using the SAS CLIST in interactive mode under TSO using the SASRX exec in batch mode with the SAS cataloged procedure b > read more

Mainframe: How SORTWKxx datasets increases sort performance in JCL

08/29/2015 23:05:07 PM

The use of more work data sets increases the maximum amount of data DFSORT can process in a single sort application. Any valid ddname of the form SORTWKdd or SORTWKd can now be used for DASD work data sets (for example, SORTWK01, SORTWKC3, SORTWK2 > read more

Why to avoid SELECT COUNT(*) in your SQL query

08/29/2015 09:12:53 AM

Many queries in programs execute SQL Select Count(*) statements just to see if any rows exist for particular data. Many times it doesn’t matter whether there is one row or one million rows; it just matters if any rows exist. When this is the ca > read more

DB2 Error codes -204, -205, -206

08/27/2015 23:58:57 PM

The error code -204 says: The object name is undefined. Resolution is need to check if the DB2 object name is correct. The error code -205 says: Invalid column name. In other way, the column name is not defined on that table. Resolution is check if t > read more

How a record in a KSDS is randomly accessed by primary key

08/26/2015 07:39:41 AM

As you’ve already learned, a KSDS consists of a data component and an index component. The primary purpose of the index component is to locate the records in the data component by their key values. To increase the efficiency of this process, the in > read more

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

08/26/2015 00:22:33 AM

Files in a UNIX environment are organized into a hierarchical structure, If this looks familiar to you, that’s because both the DOS and Windows operating systems use a hierarchical file organization too. As you can see, all files within a hierarchi > read more

ISPF basic editor commands for Software developers

08/25/2015 00:35:06 AM


5 Essential features of COBOL REDEFINES phrase

08/25/2015 00:30:41 AM

In COBOL REDEFINES is one of the frequently being used phrase. It has many advantages if you use it pproperly. REDEFINES is possible at two levels: At group level  (01 level) At field level The REDEFINES clause allows you to define the same data fie > read more

Mainframe tip- Resolution TSO session not allowing to do anything

08/24/2015 08:29:28 AM

If by mistake you try to browse the migrated dataset then your TSO session will not allow you to do anything and you will get below error. So to come out of this press  cntrl+shift+A  twice  then below message will appear- Press Y, then press any > read more

Mainframe COBOL Debugging mode ‘D’ in 7th Column

08/24/2015 01:22:52 AM

To get Display for each PARA instead of using 2-3 lines code we can do it by single line code. If you are writing a new code then it will be useful to use this tip. *SOURCE-COMPUTER.  IBM-370.   SOURCE COMPUTER IBM370.  WITH DEBUGGING MODE. And gi > read more

Informatica Interview Questions- Part( 1 of 2 )

08/23/2015 17:26:52 PM

The following are the interview questions asked at CGI for informatica developers. What type of testing will do in project? A). Unit testing, System testing, Integration testing How many ways we can do performance tuning in informatica? A) – Op > read more

Mainframe tip- Resolution for ‘Member in Use’ error

08/23/2015 08:18:48 AM

Sometimes while opening the member of PDS in edit mode we see the message ‘Member in Use’ in that if you want to know who else is using that member then you press F1 twice or you can type WHOHAS in front of that member then it will show y > read more

Mainframe tip to cut first 10 lines, last 10 lines from 10000 lines dataset

08/23/2015 01:14:25 AM

I have a dataset with 10,000 lines. I want to cut the first 10 lines and last 10 lines and paste into another dataset. When I cut the first 10 lines and then again the last 10 lines, only the last 10 lines are pasted into the new dataset. Is there an > read more

Mainframe tip editing IMS DB database with File Aid

08/22/2015 06:08:02 AM

In case you are not able to open File Aid in Edit mode, try doing this…………………….. Open your file Aid with option 2 for Edit, you will get below screen. Now in the bottom of the                              > read more

DB2 Date and Time formats for Software developers

08/21/2015 20:28:30 PM

5 Top Data warehousing Skills in the age of Big data and Analytics #datawarehousing — ApplyBigAnalytics (@applyanalytics) August 21, 2015 International Organization for Standardization (ISO) YYYY-MM-DD HH.MM.SS IBM USA St > read more

COBOL Different Error Handling Phrases

08/21/2015 13:15:49 PM


2 Top ideas to Copy or Load a Data set in Mainframe

08/21/2015 00:13:45 AM

You must load a VSAM data set by writing it sequentially. Entry-sequenced and linear- space data sets are in whatever sequence you want. Key-sequenced and relative- record data sets must be ordered on the record keys. Idea-1: You can load the data se > read more

DB2- MAX Column function- best example

08/20/2015 05:16:07 AM

The MAX function returns the largest value in the specified column or expression. The following SQL statement determines the project with the latest end date: SELECT MAX(ACENDATE) FROM DSN81010.PROJACT; The result of the MAX function is of the same d > read more

DB2- AVG Column function – Best example

08/20/2015 00:05:36 AM

The AVG function computes the average of the values for the column or expression specified as an argument. We should not give AVG function on CHAR arguments. This function operates only on numeric arguments. The following example calculates the avera > read more

5 Top ideas on JCL Checkpoint and Restart (1 of 2)

08/19/2015 00:23:23 AM

RD in JCL exec statement: There are two methods of restarting a job: restarting from a step (step restart) and restarting from a checkpoint (checkpoint restart). Step restart is simpler and doesn’t require the system to take a checkpoint. You s > read more

DB2 Questions on Primary Key, View , Static SQL and Dynamic SQL

08/18/2015 00:28:03 AM

What’s the advantage of using a view? By using views, you can set up different presentations of the same data. Each view is derived from the actual table data, but each user will see a subset of the data. The main benefit to using views is that > read more

DB2 Numeric, String, Date, Time Data types

08/17/2015 00:29:06 AM

Numeric Data types: SMALLINT: As the name suggests, the smallest numeric data type that DB2 supports. These values use 2 bytes of storage (16 bits) and are interpreted as 2s-complement signed numbers, providing a range between -32768 and 32767. INTEG > read more

Calling Stored Procedure in DB2- best example

08/16/2015 23:49:00 PM

What is the role of stored procedure in DB2 Workloads in a client/server environment can be moved from the client to the sever by creating one or more stored procedures. Once a stored procedure has been created and registered with a database (by exec > read more

Mainframe: DB2 Tutorial For Software Developers (5 of 5)

08/16/2015 04:33:12 AM

Read my Part-4 post on DB2 tutorial. Indexes: What is an Index ? ‘An index is an ordered set of pointers to rows of a base table’. Or ‘An Index is a balanced B-tree structure that orders the values of columns in a table’ Why an Index ? One > read more

All about Mainframe DB2 VARCHAR Field

08/15/2015 00:54:28 AM

VARCHAR(n): Varying-length character strings with a maximum length of n bytes. n must be greater than 0 and less than a number that depends on the page size of the table space. The maximum length is 32704. Handling additional data in VARCHAR fileds > read more

Mainframe JCL- DD Statements for Tape data sets

08/14/2015 00:19:23 AM

DD statement parameters that you can use for tape data sets. Here, the only parameters that are new are the RETPD, EXPDT, and LABEL parameters. RETPD and EXPDT let you set a time limit for how long a data set should be kept, and LABEL is the paramet > read more

Mainframe: DB2 Catalog tables in accessing Remote Data

08/12/2015 23:31:38 PM

The following system catalog  tables being updated while accessing data from remote systems: SYSIBM.LOCATIONS SYSIBM.LUNAMES SYSIBM.IPNAMES SYSIBM.MODESELECT SYSIBM.USERNAMES SYSIBM.LULIST SYSIBM.LUMODES Buffer pools in DB2 Buffer pools are database > read more

JCL- ICETOOL to Copy a data set to multiple data sets

08/12/2015 00:19:59 AM

Combining ICETOOL with DFSORT in Mainframe JCL. Best DFSORT examples so you can simplify your JCL code. Continue reading → > read more

ICETOOL in Job control Language (JCL) of Mainframe (1 of 4)

08/10/2015 23:59:58 PM

What is ICETOOL ICETOOL, a versatile data set processing and reporting utility, provides an easy-to-use batch front-end for DFSORT. How to use ICETOOL ICETOOL combines new features with previously available DFSORT features to perform complex sorting, > read more

DB2- Split Predicates to improve SQL Performance

08/10/2015 00:10:47 AM

Best rewriting SQL query methods to improve Query performance. First write Split predicates out if possible: SELECT DEPTNO, DEPTNAME FROM DEPT WHERE (ADMRDEPT = ‘E01′ AND DEPTNAME LIKE ‘BRANCH%’) OR (DEPTNO = ‘D01′ > read more

DB2- Different SQL Queries for Creating Index (1 of 2)

08/09/2015 00:32:44 AM

Provide a fast, efficient method for locating specific rows of data in very large tables. (In some cases, all the information needed to resolve a query may be found in the index itself, in which case the actual table data does not have to be accessed > read more

Best ways to handle unrecoverable errors in CICS programs

08/08/2015 00:13:17 AM

Method-1 Best one method is to call error program, by passing error parameters. WORKING-STORAGE SECTION. * COPY ERRPARM. C 01 ERROR-PARAMETERS. C * C 05 ERR-RESP PIC S9(8) COMP. C 05 ERR-RESP2 PIC S9(8) COMP. C 05 ERR-TRNID PIC X(4). C 05 ERR-RSRCE P > read more

COBOL- Alternative Key vs Alternative Index

08/07/2015 00:45:57 AM

The concept of Index, Primary key and Alternative key and Alternative index creates many questions, much confusion in the mind of COBOL programmers. There are many simple and powerful solutions for Alternative Key and Alternative index files. Alterna > read more

Mainframe: DB2 Tutorial For Software Developers (4 of 5)

08/06/2015 00:48:00 AM

Read my previous post(3 of 5). Functions Types are two : Column Function Scalar Function Column Functions Compute from a group of rows aggregate value for a specified column(s) AVG, COUNT, MAX, MIN, SUM Scalar Functions Are applied to a column or exp > read more

CICS- How XCTL,LINK and RETURN controls execution of programs

08/05/2015 01:06:23 AM

How programs executed in CICS When CICS initiates a task, it loads a program and transfers control to that program. That program, in turn, can invoke other programs. Those programs will return control to the invoking program when their processing is > read more

Mainframe: Batch JCL Conditon Code Confusing Question

08/04/2015 00:23:36 AM

Step return code (condition code) and System completion codes are confusing questions in batch jcl. I have given here differences between those. Continue reading → > read more

Top Data virtualization Techniques for BI projects (1 of 5)

08/01/2015 00:23:00 AM

The term data virtualization is based on the word virtualization. Virtualization is not a new concept in the IT industry. Probably the first application of virtualization was in the 1960s when IBM used this concept to split mainframes into separate v > read more

Mainframe: MQSeries for Senior Software Developers(1 of 3)

07/31/2015 01:06:09 AM

These posts specially for mainframe programmers, they can use these tips for development as well as for maintenance projects. Integrate your mainframe applications to different distributed applications using MQseries. A message queue, known simply as > read more

Mainframe: 10 Powerful Points for COBOL and SQL programs

07/30/2015 00:59:26 AM

In Mainframe it is possible to run a SQL query without writing a COBOL program. By using, SPUFI, QMF and IBM Studio SQL query must begin with EXEC SQL and end with END-EXEC. Second, your SQL query usually uses COBOL host variables. Host variables in > read more

CICS: CEMT, CECI, CEBR Commands Part(2 of 3)

07/29/2015 07:42:01 AM

#Cloud Computing Middleware an approach- Virtualization #biganalytics #bigdata — ApplyBigAnalytics (@applyanalytics) July 27, 2015 CEMT lets you display and change the status of resources, including programs, transactions > read more

Mainframe: Top IMS DC Interview Questions (2 of 2)

07/28/2015 07:41:27 AM

Different kinds of NoSQL Databases in the age of Big data | Apply Big Analytics — Srinimf (@srinimf) July 26, 2015 1) Which block MFS uses for input message? DIF- Device input format 2) What is second block it uses? MID- > read more

Mainframe:COBOL Strings, INSPECT,Concatenation, Splitting (2 of 2)

07/27/2015 00:23:53 AM

What is String concatenation in COBOL. Read my previous post on COBOL Strings-INSPECT VERB. String concatenation involves joining the contents of two or more source strings or partial source strings to create a single destination string. In COBOL, st > read more

Mainframe-COBOL Occurs, Indexed By,USAGE is Index (2 of 2)

07/23/2015 21:44:32 PM

Read my previous post-1. This post is an advanced topic for Tables/arrays. OCCURS depending ON. Best example to create variable array: 01 ORG-LIMIT PIC 99 COMP VALUE 50. 01 DIVISION-NAME-TABLE. 05 DIVISION-ENTRY OCCURS 1 TO 50 TIMES DEPENDING ON ORG > read more

Easytrieve Guide for Mainframe Programmers (6 of 20)

07/22/2015 06:18:48 AM

VARIOUS I/O COMMANDS: This section will cover a wide variety of commands that will be essential to the EZT+ programmer in organizing the logic that is necessary to construct an EZT+ program. The statements to be covered are . . . . .   PRINT     > read more

5 Key differences of INDEX and Subscript for COBOL programmers

07/21/2015 00:06:37 AM

You can refer my posts on INDEXED BY and KEY IS of a Table. Subscript: Subscript should be an integer. It should have working storage definition Subscript can be passed to a sub-program Subscript varies from 1 to size of OCCURS Subscript references > read more

© 2006-2015, All Rights Reserved