Recent Updates: Tech.Jobs.Biz.Success

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

Already a Member? Log In to Your Account
  
This Blog Posts All Posts Directory Listings Articles

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

DB2 – SQL With Joins – Performance

10/12/2014 05:42:18 AM

Make sure there is an understanding of inner vs. outer joins. Many times SQL is written with Table1 outer joined to Table2, and then inner joined to Table3. The inner join being coded last can offset the exceptions that took place in the outer  join > read more

Super Package, Complex Package and Participating Package

10/10/2014 20:09:05 PM

Super Package: It can hold multiple participating packages. Both local and remote packages Complex Package: It can hold multiple participating packages. Both local and remote packages. Even it can hold super packages. Participating Package: A package > read more

Srinimf.Jobthread

10/05/2014 05:46:55 AM

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

Database Challenge – Show Your Knowledge |DB2, Oracle, Sybase

10/04/2014 01:26:33 AM

Databases are becoming more popular, and today’s ,www.biganalytics.me, data world, analytics playing critical role. There are many databases in the market. Only few of them so popular. Every database, we can query it with SQL. It is a popular l > read more

DB2- Revolving Tablespaces|Rotating Partitions

10/03/2014 00:08:18 AM

DB2 naming standards These naming standards apply to DB2 running on a z/OS mainframe. Probably the first thing you notice about DB2 is the naming convention. DB2 names rarely fit in with the rest of the naming conventions in your site! They look like > read more

Intertest – CICS Programs Debugger

10/01/2014 10:41:45 AM

CICS INTERTEST GUIDE CICS ITST COMMANDSFiled under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development, Srinimf Jobs, Teradata Tagged: Intertest - CICS Programs Debug > read more

DB2 – Timestamp and Sysdummy1

09/29/2014 10:17:17 AM

SYSIBM.SYSDUMMY1 is an EBCDIC table, provided by DB2. It is used when we need to fetch data that is not in a table, For e.g. Current Date, Current Time etc.. Example >DB2 SELECT 2+3 FROM SYSIBM.SYSDUMMY1 Output: 1 ———– 5 1 rec > read more

IBM – Debugger Tool Setup And Commands

09/24/2014 10:25:27 AM

The following links will help: IBM Debugger Tool Setup Debugger Commands Filed under: Analytics, CICS, Data Warehousing & Tools, Easytrive, IMDB/DC, Mainframe, Quiz, Self-development, Srinimf Jobs, Teradata Tagged: IBM - Debugger Tool Setup And Comma > read more

DB2-Performance Tuning | Explain Plan

09/22/2014 20:36:33 PM

DB2 EXPLAIN The primary function of the explain is to provide access path information for select statements. Information regarding delete, update, and insert statements are somewhat limited in information. For SQL statements referencing a single tabl > read more

Teradata – Online Practice

09/21/2014 03:58:39 AM

The following are good resources to start your Teradata. Practice Test Teradata knowledge Teradata Practice dumps Teradata QUIZ Teradata top 50 questions Teradata Mock certification Test Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing > read more

DB2-SQL DISTINCT and Group By

09/18/2014 10:31:36 AM

We should not use DISTINCT in SQL query, it takes more io. Select distict ename,enum from emp where ename=’krishna’ and enum=1000 The alternative way is: Select ename,enum from emp where ename=’krishna’ and enum=1000 group by > read more

DB2 V11 – New Technique Duplicate Removal

09/16/2014 21:32:13 PM

Enhanced duplicate removal: – Lots of queries require duplicate removal: e.g. DISTINCT, GROUP BY, etc. – Dup elimination via sorting can be expensive – New techniques: Index duplicate removal, early out Index duplicate removal: One feature that > read more

DB2- Joins Performance Tuning

09/15/2014 08:57:09 AM

Response time Response time is determined mostly by the number of rows participating in the join number of rows participating in the join Provide accurate join predicates Provide accurate join predicates ?? Never use a JOIN without a predicate Neve > read more

Teradata – Active Load

09/14/2014 05:57:55 AM

Active Load Teradata is able to load data actively and in a non-disruptive manner and, at the same time, process other workloads.Teradata delivers Active Load through methods that support continuous data loading. These include streaming from a queue, > read more

M204 – Model 204 Database

09/11/2014 10:38:43 AM

Model 204 is a database management system for IBM and compatible mainframe computers, “born” 1965 October 13, and first deployed in 1972. It incorporates a programming language and an environment for application development. Implemented in assemb > read more

How to Use Multiple Joins in DB2

09/10/2014 08:19:34 AM

The below is the best example to go ahead on multiple joins: SELECT m.f1, o.f1, s.f1 FROM Material m LEFT OUTER JOIN Catalog c ON m.MaterialName = c.MaterialName AND m.EffectiveDate = c.EffectiveDate AND c.MaterialType = ‘X1′ AND (c.Mater > read more

COBOL – SQLCA is Not Mandatory- Why

09/07/2014 23:47:42 PM

SQLCA –  Also called SQL communication is area, is not mandatory in COBOL Program. 01 SQLCA. 05 SQLCAID PIC X(8). 05 SQLCABC PIC S9(9) BINARY. 05 SQLCODE PIC S9(9) BINARY. 05 SQLERRM. 49 SQLERRML PIC S9(4) BINARY. 49 SQLERRMC PIC X(70). 05 SQL > read more

List of Mainframe User Companies Worldwide

09/06/2014 02:12:13 AM

http://www.sysed.com/tech_assessments/leader/mainframe_legacy_systems.aspFiled under: CICS, Mainframe, Quiz > read more

DB2- Partition By SQL Query

09/05/2014 22:24:21 PM

SQL> select * from Employee   2  / ID   FIRST_NAME LAST_NAME  START_DAT END_DATE      SALARY CITY       DESCRIPTION —- ———- ———- ——— ——— & > read more

Best JCL Interview Questions – Splitting Input File

09/04/2014 06:06:23 AM

1. Question //URMISPLT EXEC PGM=SORT //SORTIN DD DSN=MYDATA.URMI.FILEIN,DISP=SHR //SORTOF01 DD DSN=MYDATA.URMI.FILEOUT1, // DISP=(NEW,CATLG,DELETE), // RECFM=FB,LRECL=50 //SORTOF02 DD DSN=MYDATA.URMI.FILEOUT2, // DISP=(NEW,CATLG,DELETE), // RECFM=FB, > read more

DB2 – Functions POSSTR and LOCATE

09/03/2014 19:40:03 PM

POSSTR – DB2 Function Similar to the LOCATE function, but with the arguments reversed.POSSTR returns the position of the first occurrence of the second argument within the first argument. For example SELECT POSSTR(‘DATABASE ADMINISTRATION > read more

Maximum Limits On DB2

09/01/2014 10:41:04 AM

 Item  Limite  Longest alias, synonym, collection ID, correlation  name, statement name, or name of a column, cursor,  index, table, view, or table check constraint  18 bytes  Longest authorization name, package name, or name of  a plan, data > read more

Micro Focus COBOL With UNIX

08/27/2014 00:10:32 AM

The main functions of Object COBOL are presented to you through a menu displayed by the Object COBOL Development Environment. The menu is displayed at the bottom of the screen, and shows you which key to press to invoke the function you want. Central > read more

SQL – What Is An Index

08/26/2014 21:14:45 PM

This is a basic topic on SQL performance tuning: Simply put, an index is a pointer to data in a table. An index in a database is similar to an index in the back of a book. For example, if you want to reference all pages in a book that discuss a cer > read more

IMSDB – User (System) Abend Codes

08/26/2014 00:44:46 AM

0002 Explanation: When the IMS control region abnormally terminates, it forces this abend for active dependent regions. This abend can also occur after normal shutdown of the control region if a new dependent region attempts to start. System action: > read more

Srinimf.Jobthread | India,USA,World IT Jobs

08/25/2014 12:53:37 PM

http://srinimf.jobthread.comFiled under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Srinimf.Jobthread | India, USA, World IT Jobs > read more

SQL – Commit Keeps DBA Away

08/24/2014 21:56:42 PM

When performing batch transactions, you must know how often to perform a “commit.” “Controlling Transactions,” a COMMIT statement finalizes a transaction. A COMMIT saves a transaction or writes any changes to the applicable ta > read more

ResumesIndia Jobs | India IT Jobs

08/24/2014 09:54:16 AM

ResumesIndia Jobs > read more

5 Powerful Thoughts on SQL NULLs

08/24/2014 02:04:21 AM

NULL BASICS: An arithmetic operation involving a NULL returns NULL. For example, NULL minus NULL yields NULL, not zero. A boolean comparison between two values involving a NULL returns neither true nor false, but unknown in SQL’s three-valued l > read more

CICS – Function Shipping

08/20/2014 22:10:34 PM

The following information contains guidance about parameters that are important in the definition of remote data resources that are to be accessed by function shipping. Those data resources are: Remote files Remote transient data queues Remote tempor > read more

Mainframe – SQL Challenge -1

08/19/2014 21:55:13 PM

Question 1: Get maximum salaries department wise? Sol: SELECT DeptID, MAX(Salary) FROM EmpDetails GROUP BY DeptID Question 2: Write COBOL logic to get nth prime number? IDENTIFICATION DIVISION. PROGRAM-ID. PRIME. AUTHOR. XYZ. DATE-WRITTEN. JULY 2014. > read more

10 Points – Instream and Cataloged Procedures of JCL

08/18/2014 20:49:01 PM

There are many rules to modify a Instream or Cataloged procedures: I have given here important rules. In-stream Procedures : Do not place any JCL statements (other than the ones listed in this topic) or any JES2 or JES3 control statements in the proc > read more

3 Different Types of HINT in DB2

08/18/2014 05:52:28 AM

PLAN_TABLE hints This type of hint to tries to enforce a particular access path for an SQL statement that is issued by a specific single authorization ID. It uses rows in a PLAN_TABLE instance that owned by the same authorization ID to apply hints ba > read more

8 Ways to Become Expert in SQL

08/17/2014 01:18:23 AM

verview Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself? If eve > read more

SQL Queries 30 Days Challenge – Day 1

08/16/2014 01:04:06 AM

I am posting 30 difficult SQL queries in 30 days. Follow me on “Srinimf” to grab these queries. Query:1 How to select employee name who does not have supervisor? Solution: SELECT ENAME,EMPNO FROM EMP WHERE ESUPER IS NULL; The above result > read more

DB2- LOCATE Scalar Function

08/15/2014 06:22:24 AM

SCALAR – Function returns first occurrence position in first string, second string: Example1: SELECT LOCATE(‘I’,’MINE STRING’) FROM SYSIBM.SYDUMMY1 It returns value 2. Since first occurrence is 2. Example2: SELECT LOCATE > read more

3 Ways to Handle DB2 VARCHAR Field in COBOL

08/13/2014 22:18:59 PM

The below example shows, how COBOL handles VARCHAR field at 49 level. 01 SNAME. 49 SNAME-LENGTH PIC S9(4) COMP. 49 SNAME-TEXT PIC X(100). :SNAME-LENGTH contains the number of bytes in :SNAME-TEXT when selecting SNAME. SNAME-TEXT should be the same le > read more

5 ways to deal with a difficult team member

08/13/2014 00:29:22 AM

1.Spot Signs Early Observe signs early on. ” Procrastination, blaming others and not trying for self improvement are signs of a non-cooperative team member,” says Sudhir Dhar, associate director and head — human resources and administra > read more

Oracle PLSQL Step By Step Guide

08/12/2014 00:39:17 AM

Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Oracle PLSQL Step By Step Guide > read more

UNIX and Shell Scripting Programming – A to Z PPT

08/11/2014 05:08:22 AM

Filed under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: UNIX and Shell Scripting Programming > read more

6 Ways to People Management in the Office

08/11/2014 00:39:48 AM

It may take a few months to several years to build your brand in the organisation. But once you are viewed as a smart, hardworking employee, you can be more comfortable discussing your other priorities. As you grow in the organisation, it is extremel > read more

Web server Basics For Dummies

08/10/2014 01:01:16 AM

Server plays prominent role in running applications. Many people false understand that OS is the same as Server. OS and Server both are different The main job of a Web server is to respond to requests from Web client computers There are 3 components > read more

Jig Saw Pizzle- Improve Your Brain Power

08/09/2014 10:17:40 AM

Carousel in Albert Dock, Liverpool puzzle on TheJigsawPuzzles.comFiled under: Analytics, Big Data, CICS, Cloud, Data Warehousing & Tools, Easytrive, Hadoop, IMDB/DC, Mainframe, Mobile Apps, Quiz, Self-development Tagged: Jig Saw Pizzle- Improve Your > read more

Oracle – PL/SQL Architecture

08/08/2014 21:32:33 PM

Oracle PL/SQL Architecture 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 ex > read more

DB2- Advanced Programming With Cursors Part (2 of 2)

08/07/2014 21:16:38 PM

Why DB2 is becoming such a popular database? Yes, there are many reasons. Time to time it is upgrading with latest features. We know CURSORS is DB2 object. There are some advanced concepts, we need to learn. Some Key words: SENSITIVE- Latest updated > read more

UNIX Daily 5 Commands

08/07/2014 06:49:25 AM

File navigating commands: cat Concatenate: displays a file. cd Change directory: moves you to the directory identified. cp Copy: copies one file/directory to specified location. file Identifies the file type (binary, text, etc). find Finds a file/dir > read more

5 Best COBOL Questions and Solutions

08/06/2014 21:44:52 PM

I wake up in the morning,I just started reading a book on How to win in office politics, during that time I have got an Idea, why many people in mainframe still unable to answer some tough COBOL questions. I decided to write 5 best COBOL questions. > read more

COBOL – Tricky Interview Question

08/05/2014 09:12:09 AM

This question you may come across in many interviews. This scenario usually comes in Banking projects/Insurance/Finance projects. Question: There are 2 files, you need to compare key field in each files, and process it. Solution -1 : - First file y > read more

DB2- Programming With Cursors – Part(1 of 2)

08/04/2014 22:22:39 PM

What is cursor? CURSOR is a DB2 object. It deals with a set of rows. Why we need to go for CURSOR- since we have already SELECT statement . The answer is – if  SELECT statement retrieves more than one row, COBOL program may not handle it. So w > read more

Change the Way You Start Your Day

08/04/2014 03:16:32 AM

Change the Way You Start Your Day What’s the first thing you do when you get to your desk? Check email and listen to voicemails? This is the worst way to start the workday. Instead of automatically going into reactive mode and focusing on other > read more

Mainframe – TSO, CLIST and REXX

08/03/2014 21:07:19 PM

TSO - is time sharing option. We can execute TSO commands through ISPF interface. Commonly used TSO commands: Session mangagement LOGON None Start a terminal session. LOGOFF X, then LOGOFF End a terminal session. HELP T (Tutorial) or PF1/13 Display h > read more

3 COBOL Features Not Allowed in CICS

08/02/2014 23:14:01 PM

Designing a COBOL program is a skill, if we write it effectively it reduces CPU time. The following COBOL feature are not allowed in CICS program. ACCEPT – There is no question of accepting data from screen. So we can not use it DISPLAY – > read more

Analytics – How to make mid career change

08/02/2014 00:02:55 AM

After researching in internet and asking my friends I have found some guidelines, who want to make change into analytics. It is never too late to join in analytics SAS certification would be a plus point to start your career Initially, we should not > read more

DB2-Stored Procedures – Examples

07/31/2014 20:57:05 PM

Complete resources on DB2 stored procedures: http://solutions.devx.com/ibm/skillbuilding/archives/introduction-to-db2-stored-procedures.html http://solutions.devx.com/ibm/skillbuilding/archives/walkthrough-creating-stored-procedures-in-db2.html http: > read more

MVS Abend Codes

07/31/2014 09:58:25 AM

Very common abends in mainframe. The below list is frequently occurred system abends. ABEND CODE 013 ABEND CODE 0C1 ABEND CODE 0C4 ABEND CODE 0C5 ABEND CODE 0C7 ABEND CODE 106 ABEND CODE 213 ABEND CODE 222 ABEND CODE 2F3 ABEND CODE 322 ABEND CODE 613 > read more



© 2006-2015 OnToplist.com, All Rights Reserved