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

Visit For Recent Updates.

This Blog Posts All Posts Directory Listings Articles

DB2 SQL Quiz for Mainframe Programmers

07/02/2015 01:05:19 AM

Check your SQL knowledge. SQL Quiz for mainframe programmers. 1)SQL was first developed: A)In the 1970s B)In 1982 C)By IBM D)By ANSI E)NONE 2)A SELECT without a WHERE clause: A) Always outputs results to a log file B) Results in an error message C) > read more

Mainframe: Top IDMS Interview Questions (1 of 5)

06/30/2015 11:30:05 AM

What is the difference between a schema and a sub schema? The schema is the physical arrangement of the data as it appears in the DBMS. The subschema is the logical view of the data as it appears to the application program. What is a region? Region > read more

Mainframe: JES2 and JES3 Control ‘/*’ Statements in Job Card

06/29/2015 12:11:02 PM

JES2,JES3 and JES statements: Under JES2 and JES3, a job stream can also include JES2 or JES3 control statements that influence the way the Job Entry Subsystem processes your job. In old projects, you may come across JES control statements in older j > read more

Mainframe: 3 Simple Ideas to Handle Cursor Position in CICS

06/28/2015 21:46:21 PM

These 3 techniques are so helpful for CICS-Mainframe programmers to implement handling cursor position. Using IC: First, if a map contains a single entry field, you can specify the IC option in the DFHMDF macro for that field. For maps with more than > read more

These COBOL File Status Codes Asked in Many Mainframe Interviews

06/25/2015 21:53:21 PM

The below COBOL errors frequently being asked in many interviews, and occurring in day to day development of COBOL programs. COBOL File Status Codes: 00- Successful 02-Duplicate alternate key 22-Duplicate Key 23-Record not found 24-Space not found to > read more

Project Manager Responsibilities in Software Company (1 of 2)

06/24/2015 21:31:17 PM

Project Manager-Software Project managers run the projects. Their role differs from that of technical managers, whose primary responsibility is maintaining the integrity of the systems. How project managers learn skills These managers have taken clas > read more

Easytrieve Guide for Mainframe Programmers(3 of 20)

06/23/2015 21:57:22 PM

EZT+ LIBRARY FILE STATEMENT All files and their associated fields (including any Working Storage items) used in your EZT+ program MUST be described in the library section BEFORE they are used in your program. The FILE STATEMENT is used to define the > read more

COBOL Data Division Clauses (1 of 3)

06/22/2015 21:09:59 PM

Many mainframe programmers not so clear about COBOL data division clauses. The below clauses extensively used in COBOL programmes. Also, the below are top COBOL interview questions. The Data Division clauses are used to describe elementary and group > read more

Sample COBOL DATE Program for Mainframe Projects

06/21/2015 22:25:27 PM


Endevor Presentation for Mainframe Programmers

06/20/2015 22:44:59 PM

Endevor is a source code management and release management tool for mainframe computers running z/OS .It is part of a family of administration tools by CA Technologies (formerly Computer Associates), which is used to maintain software applications an > read more

Easytrieve Guide for Mainframe Programmers (2 of 20)

06/19/2015 21:45:57 PM

EZT+ SYNTAX EZT+ and its free-form ENGLISH language structure make it easy for you to develop an efficient and flexible style of programming. To avoid fundamental programming errors you should follow these simple EZT+ syntax rules.  STATEMENT AREA > read more

DB2- Use of ‘COALESCE’ Function (2 of 2)

06/18/2015 21:25:39 PM

Usage of COALESCE function, and detailed explanation. SELECT bird_name, AVG(COALESCE(found_tally, 0)) FROM Samples AS SA LEFT OUTER JOIN SampleGroups AS SG ON SA.sample_id = SG.sample_id AND SA.bird_name = :my_bird_name AND group_id = :my_group GROUP > read more

Eazytrive+ Material for Mainframe Programmers (1of 20)

06/17/2015 23:54:51 PM

What is EZT+?  EZT+ is an information retrieval and data management system. It provides the NEW USER the tools to produce comprehensive reports. The experienced programmer is given the tools to create more complex reports.  EZT+ is an ENGLISH style > read more

TPPCB Structure in IMSDB/DC

06/15/2015 19:37:07 PM

TPPCB Structure: 01  TPPCB. 05  TP-LTERM                    PIC  X(08). 05  FILLER                      PIC S9(04)   COMP. 05  TP-STS-CODE                 PIC  X(02). 88  TP-BB-GOOD   > read more

PLI Presentation for Mainframe Programmers

06/14/2015 00:46:10 AM

Filed under: IMDB/DC, Mainframe, PL/I Tagged: Mainframe PLI, PLI > read more

QMF Commands for Senior Mainframe Programmers

06/13/2015 21:46:39 PM

QMF is an excellent tool for mainframe programmers to increase productivity. QMF for windows a solution,we can query on multiple data sources. Database management system implementations within a single company are no longer restricted to a single dat > read more

DB2 SQL Query to Find Salary Dept wise

06/11/2015 22:52:10 PM

Good SQL query example. It is asked in many interviews. Suppose, that you want to know how much salary is paid to employees for each of the department codes listed in the SAMPLE database’s employee table. Take a look at this table in the Contr > read more


06/10/2015 21:25:18 PM

DB2 V11 LOAD and UNLOAD Enhancements: LOAD SHRLEVEL NONE with PARALLEL option LOAD SHRLEVEL CHANGE with PARALLEL option The best way to LOAD is split your input data set into part and load individual data set into part of partition table space. Howev > read more

2 More things on Advanced COBOL Programming

06/10/2015 00:26:34 AM

A great opportunity for mainframe programmers to implement these advanced concepts into their development projects. As you gain experience you need to show some performance improvement in your day to day coding. These, you can tell, that you did in y > read more

Sorting Multiple Fields in DFSORT

06/08/2015 21:00:03 PM

Let us sort records in the bookstore data set by specifying multiple control fields. When you specify two or more control fields, you specify them in the order of greater to lesser priority. Note that control fields might overlap or be contained w > read more

DB2 NULLIF Scalar Function

06/08/2015 01:30:40 AM

NULLIF returns a null value if the two arguments of the function are equal. If the arguments are not equal, NULLIF returns the value of the first argument. DB2+Mainframe+CICS+Updated+JOBS [If your from INDIA please search here ] Example: NULLIF: Sup > read more

3 Thoughts on Modernization of Mainframe Online Applications

06/07/2015 22:12:36 PM

Mainframe modernization using Web services/SOA has, in recent years, become one of the most effective, efficient, and economical means to reach these goals. In manufacturing, telecommunications, energy, high tech, insurance, government, health care, > read more

How COBOL Sharing Data Between Main and Subprograms

06/06/2015 22:06:21 PM

These are interesting things on COBOL. Surely if you implement these in your development projects your productivity will increase. Within a main program and each of its contained subprograms, data and files are normally private, which means that they > read more

Sweet Spots of DB2 V11 with Hadoop

06/04/2015 21:00:00 PM

Big data and business analytics represent the new IT battleground. Here is some stats: IDC estimates the big data market will reach $16.9 billion by 2015, and that enterprises will invest more than $120 billion to capture IDC estimates the big data m > read more

SQL Tuning Refresher for Data warehousing Programmers

06/03/2015 21:38:52 PM

SQL tuning is very critical in the context of data ware housing. Before tuning, the following factors we need to consider to take decision. Isolating the Problem The first challenge is to isolate exactly where the performance problem lies. For exampl > read more

IMSDB Refresher for Mainframe Programmers

06/02/2015 21:25:32 PM

I am giving here IMSDB refresher for your super success in interviews. This tutorial contains all key points in IMSDB. Many interviewers follow or touch these questions in selecting IMSDB programmers. Few points on IMSDB: [You can read my other arti > read more

ROLLUP or Sub Total in DB2 V11 SQL

06/01/2015 22:37:40 PM

A ROLLUP grouping is an extension to the GROUP BY clause that produces a result set containing sub-total rows in addition to the “regular” grouped rows. Subtotal rows are “super-aggregate” rows that contain further aggregates > read more

Python the Most Powerful Language

05/31/2015 21:20:06 PM

According to 2014 statistics Python became one of the powerful language, after Java, C++ in series. Python is free downloadable language. You can start practice today. Tools for Python-Downloads: Anaconda Python Both eas > read more

Top UNIX Job Scheduling Interview Questions

05/30/2015 22:49:05 PM

 What is the difference between invoking a job serially and in parallel? A) In UNIX/Linux, the invocation of a program is also called a job or task. To distinguish between a job (task) and process, consider the invocation of a program as a single jo > read more

Highest Paying Jobs in USA

05/30/2015 08:22:18 AM

1. Software Architect Average base salary: $131,000 Number of job openings: 3,200 software+architect+jobs 2. Software Development Manager Average base salary: $124,000 Number of job openings: 2,200 software+development+manager+jobs 3. Solutions Arch > read more

ISPF-Commands For Senior Software Developers (5 Of 5)

05/29/2015 21:15:13 PM

How do I make columns 1-6 disappear from my ISPF editor screen? > read more

2 More Ideas on COBOL Debugging

05/29/2015 00:39:51 AM

COBOL debugging: is a concept used in COBOL programs. Let us go into details of this concept. Many COBOL programmers have a question, if debugging tools are there, why we need to go for COBOL debugging. Yes, it is true, but it has some advantages. H > read more

ISPF-Commands For Senior Software Developers (4 Of 5)

05/27/2015 20:39:54 PM

How do I find for any non-numeric character? A. Use picture string ‘-’. 32. How do I find for any alphabetic character? A. Use picture string ‘@’. 33. How do I find for any uppercase alphabetic character? A. Use picture string ‘>’. 3 > read more

Reduce SQL Complexity With Grouping Sets in DB2 V11

05/26/2015 21:38:25 PM

DB2V11,Grouping Sets-Mainframe. The GROUPING SETS option can be thought of as the union of two or more groups of rows into a single result set. It is logically equivalent to the union of multiple subselects with the group by clause in each subselect > read more

What is EIB Storage Area in CICS

05/25/2015 22:43:27 PM

Execute Interface Block (EIB) is a CICS area that contains information related to the current task. I’ll explain how to use some of the other fields. For a complete explanation of these fields and their possible values, you can refer to the IBM > read more

Writing Transaction File to Master File in COBOL- 8 Tips

05/23/2015 23:07:39 PM

COBOL-Master file-Transaction file. Many interviews these questions are asked in COBOL,transaction file and master file. Easy ideas I have given for your sure success in your interviews. Master files contain the entire data of a particular applicatio > read more

ALTER TABLE table_name DROP COLUMN column_name

05/23/2015 03:32:49 AM

ALTER statement we can use in DB2 SQL query to drop a column. ALTER TABLE table_name DROP COLUMN column_name But, there are lot other conditions involved, which column we can drop or not. The containing table space is not a universal table space. The > read more

1 More Addition Of Global Variables in DB2 V11

05/21/2015 23:43:39 PM

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

Cashback In Credit Or Debit Cards

05/20/2015 22:27:41 PM

A Cashback reward program is an incentive program operated by credit card companies where a percentage of the amount spent is paid back to the card holder. Many credit card issuers, particularly those in the United Kingdom and United States, run prog > read more

Start Tuning Your DB2 SQL Query (Part-1)

05/19/2015 21:41:04 PM

Check the predicates. Whether it is one query or multiple queries in a program, check every predicate in every query to ensure that they are indexable, stage 1, and as simple and straightforward as possible. If there is a Distinct or Group By in the > read more

1 More Addition to Improve DB2 Insert Performance

05/18/2015 23:26:04 PM

1 More Addition in DB2 V11 to improve insert performance: Having to index every data row affects performance and the size of the index. When creating an index, it is useful to exclude one or more values from being indexed, such as values that will n > read more

DB2-New Built-in Functions In Version 11

05/17/2015 22:14:39 PM

ARRAY_AGG The ARRAY_AGG function returns an array in which each value of the input set is assigned to an element of the array. ARRAY_AGG can be invoked in the following situations: Select list of a SELECT INTO statement Select list of a fullselect in > read more

ISPF-Commands For Senior Software Developers (3 Of 5)

05/16/2015 20:55:56 PM

21) I am not able to delete a dataset that resides on a tape. A. Yes. You cannot delete/rename a tape dataset. Only you can uncatalog it. ISPF Editor 22) How do I see only those lines that contain a particular string? A. Type ‘X all’ then ‘F > read more

IMSDB Interview Questions ( Part-2 )

05/15/2015 20:55:55 PM

1) How CICS access IMS DB database? A. Access through CICS command level interface 2) How REXX Exec access IMS DB? A. REXX EXECs can invoke IMS functions by using the IMS adapter for REXX 3) What is ICAL call in IMSDB? A. The IMS Call (ICAL) call i > read more

5 More Frequently Asked DB2 SQL Queries

05/14/2015 21:02:01 PM

I collected from my friends, for DB2 interviews these SQL queries you need to practice more times. Query#1 1) What are the different SELECT statements? A. select clause: Enumerates the column names and related constructs from clause: Describes the ta > read more

ISPF-Commands For Senior Software Developers (2 Of 5)

05/13/2015 21:03:20 PM

In my series of posts, I am giving best ISPF tips to improve productivity. Across the companies following these tips.Mainframe+cobol+db2+jobs+USA+India+UK+ . Read my part-1 tips, if you missed. 11) How do I find out which base cluster does an altern > read more

Top 15 Bangalore IT Jobs

05/13/2015 01:27:28 AM

Daily updated jobs. Experience level: 0 to 10 years. Access all your dream jobs from your Android/Windows/IOS/Blackberry mobile phone. Bangalore+IT+Jobs > SAP+HANA Jobs > Mainframe+DB2+CICS+Jobs > Hadoop+Jobs > ControlM+Mainframe+Jobs > Teradata > read more

IMSDC Interview Questions(Part-1)

05/12/2015 21:07:53 PM

I am giving here some of the top IMSDC interview questions asked in Altimetric, HCL, Tech Mahindra and IBM. 1) What is IMS TM region? A. The IMS TM control region is a z/OS address space that can be initiated as a z/OS started task or as a job by sub > read more

JCL- INCLUDE And OMIT With Examples

05/12/2015 12:45:21 PM

The best way to improve the efficiency of a sort or a merge is to reduce the number of records that are sorted or merged. To do that, you can use the INCLUDE and OMIT statements to identify the records that should be included or omitted from the sort > read more

ISPF-Commands For Senior Software Developers (Part 1 Of 5)

05/10/2015 21:49:33 PM

Advanced ISPF commands. Many mainframe developers do not use these. So I categorized these for Senior Mainframe developers. How do I create multiple instances of ISPF sessions? A. Use PDF command from the TSO panel, which will initiate a new ISPF s > read more

Top DB2 Frequently Asked Questions-Part1

05/09/2015 20:39:04 PM

1) How would you find out the total number of rows in a table? A. Use SELECT COUNT(*) … Allstate uses DB2v6. and QMF V3.3. 2) How do you eliminate duplicate values in SELECT? A. Use SELECT DISTINCT … 3) How do you select a row using i > read more

7 Strategies Of Batch Modernization In ZOS

05/08/2015 21:20:20 PM

The following 7 strategies improve batch performance, that in turn reduce cycle time. Ensuring the system is properly configured Ensuring a properly configured system means making sure there are generally adequate system resources, so work flow is no > read more

DB2-Optimizer Interview Questions

05/08/2015 11:56:44 AM

I want to share some interview questions that were asked in big companies like Dell, HCL, Infosys, CTS etc.. 1) What is optimizer? A. The DB2 optimizer, is the brain of DB2. The optimizer is a sophisticated and complex set of algorithms whose main o > read more

IMSDB-Database Manager Interview Questions

05/07/2015 21:01:57 PM

1) What is database management system(DBMS)? A. Allow access to the data for multiple users from a single instance of the data. Control concurrent access to the data to maintain integrity for all updates. Minimize hardware device and operating system > read more

IMSDB- Application Calls And System Service Calls

05/06/2015 21:51:06 PM

Application Calls get unique (GU) The GU (get unique) call retrieves a specific segment or path of segments from a database. At the same time, the GU call establishes a position in a database from which additional segments can be processed in a forwa > read more

DB2-Concurrency And Locking Interview Questions

05/05/2015 22:49:21 PM

I am giving here some challenging interview questions in concurrency and Locking. These questions are asked in many big companies like IBM, Dell, L&T, Allstate, Infosys, Wipro etc. 1). What is concurrency in database environment? A.  Database syste > read more

Credit Cards Tokenization

05/03/2015 20:32:36 PM

As you whip out your credit card this holiday season, you may wonder how secure your data are at the stores where you’re shopping. After all, it’s almost the one-year anniversary of the massive Target credit card breach, and high-profile > read more

Difference Between Multi-tired Application And Stored Procedures

05/02/2015 22:18:18 PM

Tired Applications: The concept of tiered applications presents a solution to design architects that uses distributed resources dynamically with the ability to insert software and hardware when and where they are needed. Two-tiered client/server appl > read more

CICS-Performance Interview Questions

05/01/2015 21:49:43 PM

Filed under: CICS, COBOL, Mainframe Tagged: CICS, CICS Performance, Top CICS Interview Questions > read more

ZOS-How DFSORT Works In Simple Way

04/30/2015 21:34:23 PM

DFSORT has very sophisticated record selection capabilities, whether before any sort (INCLUDE / OMIT) or after the sort (OUTFIL INCLUDE / OMIT). With OUTFIL INCLUDE / OMIT, you can use different criteria to send records to multiple output destinati > read more

PL/SQL-Syntax Rules

04/29/2015 23:48:58 PM

PL/SQL is a case-independent language, unless you specifically set up Oracle to be case-sensitive or explicitly define object names within the “” marks. In our careers, we have seen the use of camelBack, all_lower_case, crammedupvariabl > read more

JCL-Conditional Include In OUTFIL Statement

04/29/2015 08:39:55 AM

The below JCL Sort example best tells conditional include in OUTFIL of OUT1 outfile: //MATCH EXEC PGM=SORT //SYSOUT DD SYSOUT=* //IN1 DD DSN=… input File1 (FB/10) //IN2 DD DSN=… input File2 (FB/10) //OUT12 DD SYSOUT=* keys in File > read more

JCL-Sort Interview Questions

04/28/2015 22:32:57 PM

Filed under: JCL, Mainframe Tagged: JCL, JCL Sort Interview Questions > read more

Oracle-Shared Pool Concept

04/26/2015 21:36:23 PM

Oracle interview question on shared pool: The shared pool is one of the most critical memory components particularly when it comes to how SQL executes. The way you write SQL doesn’t just effect the individual SQL statement itself. The combina > read more

Stratus- Architecture Of Fault Tolerant System

04/24/2015 10:13:10 AM

Modularity- The hardware and software are constructed of modules of fine granularity. These modules constitute units of failure, diagnosis, service, and repair. Keeping the modules as decoupled as possible reduces the probability that a fault in one > read more

PL/SQL Interview Questions – Part-1

04/22/2015 09:02:23 AM

Filed under: Oracle, PL/SQL Tagged: Oracle, PL/SQL Interview Questions > read more

COBOL Features Not Allowed In CICS

04/21/2015 08:08:28 AM

Many features of command level features not allowed in CICS program. Under CICS, all terminal I/O is handled by the terminal control module, whose services are typically requested by issuing SEND MAP and RECEIVE MAP commands. Because of that, COBOL > read more

Ultra Basic Unix Commands – Part-1

04/20/2015 21:30:05 PM

Below are basic UNIX commands: cat – display or concatenate files cd – change directory chmod – change the permissions on a file or directory compress – compress a file cp – copy a file date – display the current d > read more

PL/SQL Architecture

04/20/2015 10:32:53 AM

When a PL/SQL program unit is passed to Oracle, it gets processed through a compiler. The compiler creates a syntax tree, passes it through an optimizer, and generates machine code that’s stored in the database for execution at a later time. Or > read more

UNIX- Sed And AWK Commands

04/19/2015 07:11:43 AM

Sed Command: The sed command does much the same thing as ed. The main difference is that sed performs these actions in a noninteractive way. Sed is a stream editor (thus the name), and it is designed to work on a specified stream of text according to > read more

PL/I- Compile JCL And Run JCL

04/18/2015 21:05:08 PM


CICS – DATE And TIME Command

04/16/2015 21:17:11 PM

When we are working on CICS, we need to obtain Date and Time from CICS terminals. When a task is started, CICS will store these values in exec interface block fields like EIBDATE and EIBTIME. When a task is started these fields will be updated with T > read more

CICS – Multithreading And Working Storage

04/15/2015 20:36:46 PM

When you code a command-level CICS program in COBOL, you can use the Working-Storage Section just as you do in any other COBOL program: for program variables and switches, as well as for data areas for terminal and file I/O. When CICS loads your prog > read more

DB2 Tough Interview Questions

04/13/2015 09:57:42 AM

Q1.  What is a DB2 bind? A1.  A DB2 bind is a process that builds an access path to DB2 tables. Q2. What is a DB2 access path? A2.  An access path is the method used to access data specified in DB2 sql statements. Q3.  What is a DB2 plan? A3.  > read more

ISPF-Primary Commands

04/13/2015 08:58:49 AM

The primary commands listed here summarize the primary commands you use to display and change your edit profile. Notice that many of these command settings are displayed in the user profile PROFILE This displays the current setting of each mode in th > read more

Stratus Server Commands – Download

04/12/2015 22:20:34 PM

VOS provides compilers for PL/I, COBOL, Pascal, FORTRAN, VOS C, BASIC, and C++. Each of these programming languages can make VOS system calls (e.g. s$seq_read to read a record from a file), and has extensions to support varying-length strings in PL/I > read more

JCL-Include Statement

04/12/2015 06:20:18 AM

In addition to or in conjunction with a JCL procedure, you can use an INCLUDE statement to copy text directly into your job stream. Then, when the job is submitted, the INCLUDE group replaces the INCLUDE statement, and the system processes the embed > read more

IBM Z13 Mainframe – New Series

04/11/2015 21:16:09 PM

IBM claims the z13 mainframe is the first system able to process 2.5 billion transactions a day (or the equivalent of 100 Cyber Mondays every day, according to the company). It can encrypt mobile transactions in real-time and provide on-the-fly ins > read more

CICS Tough Interview Questions

04/09/2015 09:18:13 AM

Question: what is difference between call and link ? Answer: In case of call , whenever you do changes to the called program you need to compile the calling program also. In case of link , it is not needed . Question: what are the differences between > read more

Updating Segments in IMSDB

04/08/2015 08:33:55 AM

Segments can be updated by application programs and returned to IMS to be restored in the database with the Replace call, function code REPL. Two conditions must be met to successfully update a segment: The segment must first be retrieved with a Get > read more

COBOL 2000- Change In Perform

04/07/2015 21:34:53 PM

A new concept introduced in COBOL 2000. That is EXIT PERFORM. EXIT [TO TEST OF] PERFORM This statement can be used in the body of an in-line PERFORM statement either to exit the statement completely or go to the next iteration. For example, you migh > read more

VSAM-Relation Between Alternate Index, Path And Base

04/06/2015 21:12:27 PM

In VSAM, Alternate index is little confusing concept for many mainframe programmers. Since VSAM is a legacy concept and many people are not using it. Now a days people are using DB2. Why we need to go for [Mainframe+VSAM+JOBS] alternate index. Let me > read more

Sample CICS Pseudo Conversational Program

04/05/2015 22:30:46 PM

CICS-Customer information control system. It is a transaction server, run especially on mainframe under ZO/S or ZOS/E. The processing in CICS is interactive. CICS has its highest profile among financial institutions such as banks and insurance compa > read more

IBM InfoSphere DataStage

04/05/2015 01:23:11 AM

InfoSphere DataStage is a powerful data integration tool. It was acquired by IBM in 2005 and has become a part of IBM Information Server Platform. It uses a client/server design where jobs are created and administered via a Windows client against cen > read more

Stratus COBOL Material

04/01/2015 21:41:51 PM

What is Stratus COBOL? Stratus COBOL also called VOS COBOL. COBOL, a widely used high-level language, provides for the internal processing of data within the structure of the four divisions of a program. Programs written in COBOL can access three typ > read more

JCL Sort Example For IFTHEN

03/31/2015 20:40:43 PM

The below example says how to use IFTHEN in sort card. IFTHEN will be used reformatting INREC or OUTREC. Using IFTHEN clauses, you reformat different records in different ways by specifying how BUILD or OVERLAY items are applied to records that m > read more

DB2 V11- Copy Data From One Table to Another

03/30/2015 20:04:19 PM

The below are the steps we need to follow. First, we need t create a new table. CREATE TABLE DA31.TELE (NAME2 VARCHAR(15) NOT NULL, NAME1 VARCHAR(12) NOT NULL, PHONE CHAR(4)) Now new Table TELE is created. I want to copy  some old data into this new > read more

SORT-Overlay Command In JCL

03/30/2015 09:11:45 AM

I came from office during rush hour to home, and decided to write something on SORT Overlay. In recent interviews, I found some guys confused to tell about overlay. Below details are an excellent examples to understand OVERLAY. //SYSIN DD * * Skip th > read more

DB2-JOINS Interview Questions

03/26/2015 11:27:03 AM

In interviews you will be asked definitely a question on Joins. I am giving one of the basic question here. What is join? When you want to see information from multiple tables, you can use a SELECT statement. SELECT statements can retrieve and join c > read more

15 Rapidly Growing IT JOBS

03/24/2015 21:32:36 PM

Open+Source+jobs  [Open Source Jobs] Open source experience and contributions continue to rate highly with IT employers, especially those with significant big data and cloud initiatives on the books. Think along the lines of the aforementioned Hado > read more

COBOL-Use Of Key Phrase In Occurs Clause

03/23/2015 21:22:26 PM

In COBOL, internal arrays play prominent role. How to define an array is very important. We can define single dimension array, multi-dimension array, also can define, variable records in an array. There is no limitation on size of an array (Occurs li > read more

Tough COBOL Interview Questions

03/23/2015 11:44:16 AM

Recently I conducted some interviews, I asked many experienced mainframe programmers on the below file handling questions. Many people confused to tell answers. But, these are very basic questions, everyone has to remember always. After years of prog > read more

Domain Knowledge-Credit Card Processing

03/21/2015 23:29:21 PM

This domain also called PCI – Payment Card Industry. It denotes debit, credit, prepaid, e-purse, ATM, and POS cards and associated businesses. Overview: The payment card industry consists of all the organizations which store, process and transm > read more

Domain Knowledge in Segregated Fund

03/21/2015 23:20:06 PM

A Segregated Fund or Seg Fund is a type of investment fund administered by Canadian insurance companies in the form of individual, variable life insurance contracts offering certain guarantees to the policyholder such as reimbursement of capital upo > read more

Latest Mainframe Interview Questions

03/21/2015 07:59:27 AM

COBOL: - Difference between COMP and COMP-3? COMP- Is binary variable. It is more efficient at boundaries. Comp-3 is packed decimal, it is more efficient in computations. - Redefines advantages? Redefines is possible at same level. And, Since redefi > read more

DB2 Four Isolation Levels-RR,RS,CS,UR

03/16/2015 21:32:48 PM

DB2 offers four locking isolation levels: Repeatable Read (RR), Read Stability (RS), Cursor Stability (CS), and Uncommitted Read (UR). Each of these isolation levels allows the user and application to control the number and duration of read (Share) l > read more

JCL-20 Rules of Instream and Cataloged Procedures

03/13/2015 21:26:05 PM

Instream Procedures: Instream procedures are identical to cataloged procedures except that you place them right along with the job in the input stream, immediately following the JOB statement, rather than as members of partitioned data sets. You migh > read more

Top Mainframe Interview Questions (Part-3)

03/11/2015 22:57:03 PM

COBOL: How to write ‘SRINI’ as ‘INIRS’ Use function “REVERSE” String and Unstring in COBOL? String – To concatenate multiple data fields into a single string Unstring- To split main string, to get only partic > read more

25 Hottest Skills in India By Linkedin

03/09/2015 10:00:04 AM

> read more

Am I Too Old To Become A Computer Programmer

03/08/2015 11:04:39 AM

I tried to read answer to the question “How Do You Learn Programming Fast Or Get A Software Developer Job Easily?” But couldn’t. I am right now a 50yrs old housewife who was working once. I am pretty confident about my “quick& > read more

© 2006-2015, All Rights Reserved