Recent Updates: Tech.Jobs.Biz.Success

Visit http://srinimf.com For Recent Updates.

This Blog Posts All Posts Directory Listings Articles

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

Resolution For CICS APCT Abend

03/07/2015 02:47:49 AM

The very first reason getting this abend in CICS is Load module of program or Map is not loaded at the time of CICS transaction execution. Solution: I have compiled a new program, but i have not defined that program with PPT entry. So we can expect A > read more

How To Prepare For Mainframe Interview

03/05/2015 09:37:53 AM

Interview preparation need to be done in 3 stages: Stage-1: Decide which job you want to go. Either Contract or permanent job. Permanent jobs need full preparation of all the skills that you put in Resume is Required. You need to be in a position to > read more

JCL-My JOB Submitted But Not Running

03/04/2015 08:50:32 AM

Question: I submitted a job for execution, which was stuck in processing for a long time. Although it completed later, but I was wondering if there is any way I can look for the reason for the delay. I had a look at the JESMSGLG but nothing was there > read more

JCL-Tough Questions For Interviews

03/03/2015 19:44:09 PM

Why we need to use Tape datasets? We need to use tape datasets to back up the data. Tape datasets we can delete by IDCAMS utility. There are special REXX tools are there to browse Tape datasets What is PRTY? It denotes priority for Output datasets Ho > read more

Best Approaches Mainframe to UNIX

02/26/2015 20:04:45 PM

Based on this legacy, a significant portion of today’s transactions is still processed by mainframes. Yet, unlike in the beginning of the computer era, big businesses no longer require mainframes to handle large volumes of data quickly and accurat > read more

5 New Things On DB2 Cursors

02/24/2015 11:17:38 AM

Cursors plays prominent role in application programming development. When to use Cursor is most important decision. If we use Cursors un-necessarily, it causes to take more CPU time. Program requires a SELECT statement that returns more than one r > read more

Nested Cursor – DB2

02/22/2015 05:48:29 AM

In DB2 we can use nested cursor. A cursor within the cursor is called nested cursor. DECLARE Cursor: We can declare all cursor definitions in working storage section. OPEN CURSOR FETCH CURSOR      When Source=10                OPEN CURSOR- > read more

Driverless Cars -Role of IT Professionals

02/21/2015 01:13:14 AM

What could have prevented the accident? The obvious answer is that you could have -- by paying attention. But that answer isn't so simple. Driver error is the most common cause of traffic accidents, and with cell phones, in-car entertainment systems, > read more

CICS-ABEND Command and Rules

02/20/2015 21:37:40 PM

The ABEND command forces the current task to terminate abnormally. If a HANDLE ABEND command is in effect, control will be transferred to the routine it specifies. Otherwise, control is returned to CICS. An optional storage dump can be produced. Synt > read more

Mainframe Ques and Messages

02/19/2015 20:37:34 PM

Message queues, and the software that manages them, such as IBM WebSphere MQ for z/OS, enable program-to-program communication. Messaging means that programs communicate by sending each other messages (data), rather than by calling each other directl > read more

DB2 Columnar Functions- CAST and DECIMAL

02/19/2015 10:23:32 AM

CAST can be used to change the data type of an expression to a different data type or the same data type with a different length, precision, or scale. SELECT EMPNO, CAST(SALARY AS INTEGER) FROM   Samples.EMP; The specified data type if DB2 not sup > read more

Hyperion Report Generating Tool

02/17/2015 19:43:25 PM

Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development, Srinimf Jobs, Teradata Tagged: Hyperion Tool > read more

Passing Data From JCL to COBOL

02/16/2015 23:02:02 PM

From JCL we can pass data into COBOL program many ways. One is through PARM (maximum limit is 100 bytes), second through Input file, third through SYSIN card. The data that we passed from PARM and SYSIN are passed to LINKAGE SECTION. In LINKAGE secti > read more

Simple Way to Write DML SQL in DB2

02/15/2015 22:47:08 PM

DML – Data manipulation language commands. S-I-D-U (The way we can remember as Cricketer name) SELECT All queries begin with the SELECT SQL statement, which is an extremely powerful statement that is used to construct a wide variety of queries > read more

5 More DB2 SQL Performance Tips

02/13/2015 20:57:54 PM

SELECT from INSERT, UPDATE whenever possible.  This feature is great for getting the values associated with identity, sequence, and any other database column keys while doing an INSERT or UPDATE SQL operation. This capability provides for the captur > read more

DB2-Aggregate Functions|No Row Found

02/11/2015 20:21:06 PM

DB2 Aggregate functions also called Column functions. Example: SELECT MAX(VALUE_1) FROM SAMPLES.TABLE_1; Rules: All aggregate functions, we need to use only in SELECT statement If no row found, we will not get +100 sqlcode, instead we will get NULL v > read more

DB2- Avoid Select Column Before do UPDATE

02/09/2015 19:40:28 PM

We do not have to retrieve data first and manipulate it before executing the SQL UPDATE. Avoiding that work requires an extra call to DB2. Below example dynamically retrieve a row, and update the Column value. suppose an employee is to be given a 1 > read more

DB2 SQL- Rules for Creating Index

02/09/2015 04:56:02 AM

Indexes will speed-up the performance. Before creating Indexs, the following rules can be considered. Consider indexing on columns used in WHERE, GROUP BY, and ORDER BY clauses, as well as for UNION, INTERSECT, and EXCEPT statements. Limit the indexi > read more

CICS – Pseudo Conversational Program

02/08/2015 00:45:36 AM

CICS- is also called Customer information control system. The term pseudo conversation program refers effective utilization of resources, and the conversation terminates itself. Traditional program has both presentation logic and business logic in s > read more

VSAM- File Reading in COBOL Program

02/06/2015 20:44:58 PM

The below example shows how we can write code in COBOL program to read VSAM file. I am giving here the best method how we can give. Simple Read just like sequential files: OPEN INPUT sample-file. READ sample-file INTO identifier. AT END statement. > read more

DB2- How to write Best SQL Queries

02/05/2015 10:31:48 AM

The following SQL checklist will help to review SQL Queries. Check for by mistake any inner join is coded as outer-join Check all union statements, is it really needed, or we can go with UNION ALL Check for NULLABLE columns, if NULL value comes, we n > read more

DB2-SQL Error -204 and Resolution

02/04/2015 20:52:26 PM

-204 name IS AN UNDEFINED NAME. Suggestion: Correct DB2 CREATOR or OBJECT NAMEs located in SQL statements. This is possible, the Table name that you have given in the SQL query is not available. Probably incorrect name given. DB2 Objects: Database is > read more

COBOL-Tough Interview Questions on VB Files

02/03/2015 20:01:29 PM

VB files can have data varying in length. The length we can control by depending on clause Table with OCCURS either VB  or FB, can have maximum 7 dimensions The key value specified in any Array mus not exceed 256 bytes The EXIT PROGRAM statement sho > read more

DB2-SQL Part-2

02/02/2015 19:39:20 PM

Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development, Srinimf Jobs, Teradata Tagged: db2 sql > read more

DB2- SET Operators

02/02/2015 10:59:47 AM

Set operators allow you to combine one are more queries. EXCEPT -All duplicate rows found in each result data set produced are eliminated from the result data set of the first query and this modified result data set is returned. EXCEPT ALL - All > read more

CICS- NODYNAM Compiler Option

02/01/2015 20:48:24 PM

When we are working with CICS, we need to mention NODYNAM compiler option. The reason is NODYNAM allows, to give both STATIC and DYNAMIC calls. We give DYNAM option, when we want to use dynamic DLLs in CICS program. Must use Compiler options in CICS > read more

VSAM-Tough Interview Questions

01/30/2015 10:22:56 AM

How many ways VSAM will identify records? Three ways. Key, RBA, RRN What is the size of primary key? Min 1 byte to Max 255 bytes What is RBA ? Starts from 0 to first record LERCL. Second records starts from length of first record. What is RRN? Relat > read more

CICS-Invoke Web service Error-Response 13 and 14

01/29/2015 09:43:07 AM

Our workshop is using CICS web services. We have a scenario need to invoke a web service to get third party service. Just after triggering service, we are getting error. INVOKE-SERVICE(data-value) CHANNEL(data-value) OPERATION(data-value) URI(data > read more

DB2 SQL Error Codes -104 and -199

01/28/2015 10:21:51 AM

In our workshop DB2 is a Database. The below errors I have got many times. The reasons are I found incorrect host variables. Example, missing codes for CHAR, using ” (double codes) instead of ‘ (Single codes) etc.. -104 ILLEGAL SYMBOL  > read more

SQL – Eliminating Duplicates in a Table

01/27/2015 10:47:07 AM

 Good thoughts on SQL: Often times there are multiple ways of getting the same answer in programming. This pertains to SQL also. Everyone needs to be stronger in SQL. Strong SQL skills greatly enhance one’s ability to do performance tuning of quer > read more

DB2 – SYSDUMMY Tables

01/26/2015 08:31:19 AM

The are four Sysdummy tables in DB2. One is SYSDUMMY1, SYSDUMMYA, SYSDUMMYE and SYSDUMMYU. SYSDUMMY1- The SYSIBM.SYSDUMMY1 table contains one row. The table is used for SQL statements in which a table reference is required, but the contents of th > read more

Alternative Career For Mainframe Programmers – Part-2

01/25/2015 20:32:26 PM

Read my part-1 post. Secondly, the programmers who is working on mainframe have very good business knowledge. People who has the following skills are valuable asset to any organisation. “A programmer who can do analysis, create database struct > read more

Cobol- Static Call and Dynamic Call

01/24/2015 20:04:07 PM

Static call and dynamic call which is best?. The answer is it depends. Static call is faster, it takes less CPU time since load is part of main program load module. Dynamic call is slower, it takes more CPU time since the load module is separately st > read more

DB2- Data Sharing Architecture

01/23/2015 23:33:09 PM

DB2 data sharing lets an application run on one or more DB2 subsystems in a Parallel Sysplex environment. The applications can read and write to the same data at the same time. Data sharing is new concept, earlier we used Distributed Data Facility (D > read more

DB2-Timestamp Mismatch -818 Sql Error

01/21/2015 20:07:19 PM

Cobol Load – Timestamp DBRM-Timestamp At the time of execution of COBOL – DB2 Program, Timestamp of above will be validated. If both are not the same we will get -818 error. See the pictorially how it works. Filed under: Big Data, IMDB/DC > read more

DB2- Local and Remote Collections under a Plan

01/19/2015 10:39:51 AM

Recently in our workshop we faced an issue with switching between two DB2 sub systems. Our data resides in Legacy DB2 sub-system and New DB2 Sub-system. whenever old account comes it should point to Legacy DB2, when new account comes it should point > read more

CICS- VSAM Files and Key Points

01/17/2015 04:26:05 AM

VSAM Files we can use in CICS like flat files how we use Cobol programs. READ, WRITE, REWRITE, DELETE As we already know VSAM files can be concurrently accessed by Batch and Online. VSAM Record-Level Sharing (RLS). This explores a method for acc > read more

Top DB2 Performance Tuning Interview Questions

01/11/2015 01:58:21 AM

For COBOL Developers The SQLCODE must be checked after every SQL statement. The Declare cursor statement is only a declarative, and it gets no return code from DB2. All other SQL calls get some return code. Return code data from the DB2 database sy > read more

DB2- Architecture An Overview

01/11/2015 00:37:29 AM

 DB2 for z/OS  “Born” in 1983 RDBMS for z System platform Exploits the z platform Hybrid engine Relational data ORDBMS extensions XML documents Parallel query engine Cluster support on Parallel Sysplex Data Sharing architecture High Availabilit > read more

10 Techniques to Keep Ahead of Your Competition

01/06/2015 10:57:43 AM

Keep Up With Your Creative Ideas: If you stay at any one job or career long enough, you will someday have creative ideas about how to do things better, quicker, faster or differently. If you ignore those creative ideas, you begin to stagnate, lose fo > read more

DB2 on Cloud

01/05/2015 10:27:29 AM

Filed under: Analytics, Big Data, Cloud, Data Warehousing & Tools, Hadoop, Mobile Apps Tagged: DB2 on Cloud > read more

Mainframe Vs Cloud Computing

12/28/2014 08:04:12 AM

Mainframe: Controlled environment of the mainframe traditionally requires an administrator to provision computing power for specific tasks mainframe has a reputation as old technology that operates under an outdated IT paradigm of command and control > read more

CICS – QUEUE and ITEM Difference

12/23/2014 20:20:01 PM

The underlying data set over which TS is implemented is pointed to by DFHTEMP dd name in the CICS startup. This is a VSAM ESDS file, set up by the systems programmer. All CICS instance wide TS queues use this one file and the application programmer n > read more

CICS-Map Splitting And Text Splitting Logic

12/21/2014 01:41:35 AM

Resources on Coding CICS-BMS Advanced mapping: Recently in our workshop we came an occassion to write complex CICS program. There are two options. One is Map splitting and another one is Text Splitting. Map Splitting: We have only one map, and data > read more

Adding New VSAM File in CICS – DADM Utility

12/19/2014 08:52:48 AM

The File Allocation Definition Add menu below can be used to add a file to the CA DADS Plus for CICS control file. APPLID A11IC4S6 CA-DADS/PLUS 4.0 DATE TIME FILE ALLOCATION DEFINITION ADD COMMAND ===> A TYPE ===> F NAME ===> FILE001 DSORG => UNAV PR > read more

Db2-Load Utility Executes in 13 Phases

12/18/2014 10:16:31 AM

UTILINIT -Performs initialization.RELOADLoads record types and writes temporary file records for indexes and foreign keys. RELOAD makes one pass through the sequential input data set. Check constraints are checked for each row. Internal commits provi > read more

Cobol-DB2 Trigger Package

12/17/2014 11:01:04 AM

When a trigger is created, DB2 creates a trigger package for the statements in the triggered action. The trigger package is recorded in SYSIBM.SYSPACKAGE and has the same name as the trigger. Before a trigger is created, it is good practice to ensur > read more

DB2- Index Rebuilt Error and Resolution

12/16/2014 09:58:57 AM

Recently in our workshop after submitting Load job we are getting error Index re-built. The reason is Load job is failed twice. And Table sapce went to recovery pending status. How to do index revuild? The REBUILD INDEX online utility reconstructs > read more

DB2 Load – Error -904 And Resolution

12/11/2014 09:38:37 AM

UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name. Suggestion: -904 is usually caused because a database utility job has started the desired DB2 object in uti > read more

DB2-Hash Index Functionality

12/04/2014 22:59:28 PM

We all know that, in DB2, there are different data access methods present. Either by using index are scanning methods. Hash index is a new technique in DB2 V10.   The concept is not new this is already being used in Teradata RDBMS, and in IMS datab > read more

CEMT – Use for Closing File

12/01/2014 19:03:07 PM

We can use CEMT to close file in CICS CEMT S File(file-name) CLOSE CEDA Commands: The CEDA CHECK command Use the CEDA CHECK command to check the consistency of a set of resource definitions on the CSD. The CEDA COPY command Use the CEDA COPY command > read more

Legacy Modernization – Mainframe

11/29/2014 01:01:13 AM

Coming year 2015 will be the year for legacy modernization. What are the things we need to consider for modernization. Best strategies in modernization. Once a company realizes the potential benefits of modernizing mainframe applications to the cloud > read more

Best Salaries for Cloud Security

11/28/2014 23:42:41 PM

IT spending for security technologies will increase 46% in 2015, with cloud computing increasing 42% and business analytics investments up 38%. . Enterprise investments in storage will increase 36%, and for wireless & mobile, 35%. Cloud computing in > read more

Teradata – Unique Secondary Index(USI)

11/27/2014 19:32:17 PM

Syntax: CREATE UNIQUE INDEX (department) ON tbl_employee; If a Teradata SQL request uses secondary index values in a WHERE constraint, the optimizer may use the rowID in a secondary index subtable to access the qualifying rows in the data table. > read more

DB2 Catalog Tables

11/23/2014 09:05:01 AM

SYSIBM.SYSCONTROLS table The SYSIBM.SYSCONTROLS table contains one row for each row permission and column mask. SYSIBM.SYSCOPY table The SYSIBM.SYSCOPY table contains information needed for recovery. SYSIBM.SYSCTXTTRUSTATTRS table The SYSIBM.SYSCTXTT > read more

S0C1- Error From DB2 Sub program

11/19/2014 11:06:18 AM

In my recent development I got S0c1 error from my sub program. I checked all the program, but no clue. The reason for S0c1 is DD name missing or Load not found. In our case, we forgot to give correct Load in the JCL. Then we changed Load. Program exe > read more

CICS Purge Failed Transaction – Tops

11/13/2014 10:44:58 AM

CEMT I TA(*) It will list all the task and you have to give fpg(force purge) against the transaction… Tas(0001230) Tra(CEDA)           Sus Tas Pri( 255 )        fpg Sta(TO) Use(A251806 ) Uow(C7357B70963BF140) Hty(ZC      ) > read more

Connecting CICS Region to Multiple DB2 Subsystems

11/11/2014 11:09:04 AM

Using the DB2 group attach facility When you are defining the connection between CICS® and DB2®, you can choose to have CICS connect to a specific DB2 subsystem. You can specify the name of this DB2 subsystem using the DB2ID attribute of the DB2CON > read more

DB2 ZO/S – Distributed Systems

11/02/2014 07:39:50 AM

Distributed the term is very big and lot of information need to be considered. Although there are many other ways that distributed clients can access DB2, they are entering through other attach types, such as CICS, IMS, MQ and RRS.  These are beyond > read more

CICS – Auto Install and No PPT Entry Needed

11/02/2014 01:05:09 AM

In CICS with AUTO INSTALL option we  no need to define each program/map to PPT entry. If Auto install is yes, CICS will dynamically installs definition for program/map when requested. If AUTOINSTALL is active, whenever those programs/maps requested, > read more

CICS – Getmain and Load

11/01/2014 09:36:58 AM

Coming to most important part of CICS architecture, there are two kinds of storage used: Storing data within transaction:  Transaction Work Area (TWA) – User storage acquired by EXEC CICS GETMAIN without SHARED option – COMMAREA in an EXEC CICS > read more

DBMS- Database Schema and Instance

11/01/2014 00:44:24 AM

A schema is a collection of named database objects. Schemas provide a way to logically classify objects such as tables, views, triggers, routines, or packages. A schema name is used as the first part of a two-part object name. For example, if the EMP > read more

DB2 V11- Analytics and Bigdata Features

10/27/2014 20:26:36 PM

DB2 11 also boasts new features for supporting big data and analytical processing. Probably the biggest is the ability to support Hadoop access. DB2 11 can be used to enable applications to easily and efficiently access Hadoop data sources using the > read more

DB2- Fetch First N Rows Only

10/26/2014 08:43:16 AM

We can use this in both main and subqueries: SELECT LASTNAME, FIRSTNAME, EMPNO, SALARY FROM EMP ORDER BY SALARY DESC FETCH FIRST 20 ROWS ONLY; You can also use FETCH FIRST n ROWS ONLY within a subquery. SELECT * FROM EMP WHERE EMPNO IN ( SELECT RESPE > read more

DB2 – PLAN Bind Same Program in Two Subsystems

10/24/2014 11:13:51 AM

> read more

Confusing SQL Queries With Dates

10/23/2014 02:01:47 AM

Query to get latest date: Select item, max(inventorydate) from table where inventorydate is < ‘6/30/2011′ Query to retrieve not more than 6 years from application date: Select item from table where appl_date >= (Currentdate – 6 Year > read more

DB2-Subsystem and Instance

10/22/2014 22:47:58 PM

DB2 Subsystem In DB2 S/390, a DB2 subsystem provides a separate DB2 environment similar to a DB2 ULWO instance. Several DB2 S/390 subsystems can be installed in the same machine logical partition (LPAR), and they can only communicate with each other > read more

Truncate and Delete in DB2

10/19/2014 07:49:06 AM

Truncate in DB2: It deletes all the rows from a table TRUNCATE TABLE INVENTORY DROP STORAGE IGNORE DELETE TRIGGERS; Delete in DB2: DELETE FROM TABLE TABLE_ONE; It also deletes rows from a table Difference between TRUNCATE and DELETE you can use follo > read more

Browse Tape File in Mainframe

10/17/2014 21:05:10 PM

We can use IEBGENER to copy tape file to Sequential file: //STEP01   EXEC PGM=IEBGENER //SYSPRINT DD SYSOUT=A //SYSUT1   DD DSN=J.TAPE.UST.A, //            DISP=SHR //SYSUT2   DD DSN=PQHL.DASD.UST.A, //         DISP=(NEW,CATLG,DELETE > read more

DB2-Identity Column

10/14/2014 10:44:12 AM

Defining an identity column on a new table: An identity column provides a way for DB2 to automatically generate a unique numeric value for each row that is added to the table. When creating a table where you know that you need to uniquely identify ea > read more

RESTART LOGIC IN COBOL DB2 Program

10/13/2014 11:37:56 AM

Originally posted on F1 for mainframes:RESTART LOGIC IN COBOL DB2 Program   Suppose you have a COBOL DB2 program, in which you are reading data from input file which has thousands of records and updating a DB2 table one record at a time.   Now you > read more



© 2006-2015 OnToplist.com, All Rights Reserved