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

Visit For Recent Updates.

This Blog Posts All Posts Directory Listings Articles

JCL evergreen Interview Question on COND Parameter

02/04/2016 21:00:40 PM

Almost in all interviews this question asked. The basic usage of COND parameter is to control execution of job steps. Some rules for JCL COND parameter Use the COND parameter to test return codes from previous job steps and determine whether to bypas > read more

COBOL mostly asked Interview Question on Files

02/04/2016 05:00:00 AM

  Question is there are two files in  a COBOL program one is Master file and the other one is Transaction file, and how to compare records these two files and write the data into master file finally. Experienced programmers can write this logic. Bu > read more

DB2 Column Access Control with GROUP BY

02/04/2016 01:05:14 AM

  SQL Query to create column mask is  CREATE (OR REPLACE) MASK (NAME) ON (TABLE) FOR COLUMN (NAME) RETURN (EXPRESSION) ENABLE (OR DISABLE) ALTER TABLE (NAME) ACTIVATE COLUMN ACCESS CONTROL Why COLUMN Masking? Essentially a data mask is nothing more > read more

JCL Different Phases of Job Execution

02/03/2016 20:36:13 PM

ZO/S uses Job Entry Sub-system(JES) to receive jobs into operating system: The following are the different phases in Job execution: Input Phase Conversion Phase Execution Phase Output Phase Purge Phase Input Phase: -JES2 jobs can be entered on input > read more

How much Java Skills You Need for Hadoop Career

02/03/2016 04:30:49 AM

Hadoop projects slowly coming to all big companies. This is the time to refresh your skills, and try for good opportunities. Many programmers including Mainframe developers asked this question. I would like to share the best Java skills for Hadoop d > read more

How to SORT 3 Input files Using DFSORT Utility in JCL

02/02/2016 20:54:41 PM

DFSORT is a sort utility. If you are aware how to use this utility, you can perform your reporting tasks more effectively and with less time. In all financial projects like Banking, Capital Market and Insurance projects do use DFSORT utility extensiv > read more

DFSORT Best Example for Multiple Overlay

02/02/2016 04:30:34 AM

Example for Multiple OVERLAY: OPTION COPY OUTREC IFTHEN=(WHEN=INIT, BUILD=(1:1,40,50:106,4,60:170,4,BI,EDIT=(TT.TT),70:170,4)), IFTHEN=(WHEN=(50,4,CH,EQ,C’COR’,AND,70,4,BI,GT,+2000), OVERLAY=(70:C’20%’,X)), IFTHEN=(WHEN=(50,4,CH,EQ,C’COR’ > read more

QMF Export Report to Excel or Word document

02/01/2016 20:35:31 PM

EXPORT : Sends Queries, forms, procedures, reports, charts, and data from temporary storage to a TSO data set Queries, forms, procedures, and tables from the database to a TSO data set Syntax: Export  Report/Query/Form  to   data set Name Once yo > read more

How to give VB Record in Linkage Section

02/01/2016 03:35:09 AM

Many mainframe programmers asked -Can give VB record in Linkages Section. The answer is yes. Below is the best example for VB Record: LINKAGE SECTION. 01 RECORD-FLAGS PIC 9(8) BINARY. 88 FIRST-REC VALUE 00. 88 MIDDLE-REC VALUE 04. 88 END-REC VALUE 08 > read more

You Never miss Different JCL Steps in a DFSORT Job

01/31/2016 22:24:50 PM

The job control language (JCL) you need to do a sort depends on whether you run DFSORT directly or call DFSORT from a program. For now, concentrate on running DFSORT directly. The below are the list of Parameters to be used in DFSORT job: Required JC > read more

You Never miss Different JCL Steps in a DFSORT Job

01/31/2016 22:24:50 PM

The job control language (JCL) you need to do a sort depends on whether you run DFSORT directly or call DFSORT from a program. For now, concentrate on running DFSORT directly. The below are the list of Parameters to be used in DFSORT job: Required JC > read more

DB2 Synonyms Vs Alias -7 Top Differences

01/31/2016 04:42:39 AM

DB2 Synonyms Synonyms can be thought of as alternative names for tables and views. No authorization is required to define a synonym. A synonym designates a synonym when it is preceded by the keyword SYNONYM, as in CREATE SYNONYM and DROP SYNONYM. In > read more

Using Data isn’t really what we mean by “Data Science” -Why?

01/30/2016 20:40:30 PM

The Web is full of “data-driven apps.” Almost any e-commerce application is a data-driven application. There’s a database behind a web front end, and middleware that talks to a number of other databases and data services (credit card processing > read more

How to Change Table Column Data type in DB2

01/30/2016 08:55:03 AM

Query to change Data Type ALTER TABLE BOOKS ALTER BOOKNAME SET DATA TYPE VARCHAR(200) ALTER ISBN SET DEFAULT ‘UNKNOWN’; Certain characteristics of a table cannot be changed. For example, you cannot change the table space in which the ta > read more

Data Science For Mainframe Developers

01/30/2016 04:44:34 AM

This video covers all basics for every mainframe programmers must know. Also tells how to enter into this career, and roles and responsibilities as Data Science developer. Also the below points covered: Data Manipulation Data Analysis with Statistics > read more

5 Frequently Asked Questions on JCL Cataloged Procedures

01/30/2016 02:34:42 AM

1. What is in-stream procedure? A) An in-stream procedure is a named set of job control statements in a job that can be re-executed within that job, simply by invoking the name of the procedure. 2. What is Cataloged procedure? A)A cataloged procedur > read more

Apply these Technics to handle Null-terminated Strings in COBOL

01/29/2016 04:32:52 AM

Even though I was busy in my work, I decided to spend some time for our readers on technical help.  COBOL strings is a key subject  and across all the big mainframe projects (Finance, Insurance and Manufacture) without strings there is no COBOL co > read more

The Role of IBM Z13 in Mobile World and Fraud Detection

01/28/2016 22:51:25 PM

IBM took the wraps off a new mainframe computer on Tuesday, promising it will help customers to detect more fraud in real time and plow through billions of transactions generated each day by smartphones and tablets. Related: How Z13 Mainframe archite > read more

DB2 Error while Inserting a Record -It is not Duplicate Record why?

01/28/2016 20:31:37 PM

What are basic rules of INSERT in DB2? The INSERT statement inserts rows into a table or view or activates the INSTEAD OF INSERT trigger. The table or view can be at the current server or any DB2® subsystem with which the current server can establis > read more

What Mainframe Programmers should Learn Next

01/27/2016 20:35:21 PM

The demand for mainframe skills in the market is dwindling. At the same time Pay packages also not that much attractive compared to modern technical skills. Why mainframe skills not only enough? The reason is Mainframe works still on legacy skills. > read more

Idea -Temporary Data Set with Disp ‘KEEP’ or ‘CATLG’

01/27/2016 04:30:09 AM

If the DISP parameter for a temporary data set specifies KEEP or CATLG, the system changes the disposition to PASS and deletes the data set at job termination. However, the system does not change the disposition for a data set when all of the followi > read more

COBOL File Status Codes and Their Meanings

01/27/2016 00:25:38 AM

In COBOL You can see during execution you will come across different error codes. The error codes are as follows: 00 – Successful means no error 1X -These errors come during AT END conditions 2X -Invalid Key errors 3X -Permanent errors 4X -Logi > read more

How to Browse TCT, PPT, FCT, PCT entries in CICS

01/26/2016 09:24:43 AM

How to browse TCT table data? Use command DSPCICSTCT to browse entries in TCT (Terminal Control Table). Only you can browse the data, but you cannot change or delete it. How to browse PCT table data? Use command DSPCICSPCT to browse entries in PCT > read more

COBOL -CICS Program Tips and Technics for Developers

01/26/2016 04:05:20 AM

Identification Division. ==>No differences Environment Division ==>MUST be EMPTY in CICS Program! No SELECT statements allowed! Data Division ==>No FILE SECTION – (No SELECTS) Data Division WORKING-STORAGE SECTION. Switches, Flags, Variables, Recor > read more

IMS DB Command Code Vs Proc Option

01/25/2016 23:37:10 PM

What is command code in IMS DB? Its benefits? Command codes in a SSA makes the call powerful since DL/I treats such SSA’S differently from those without the command codes while performing some special functions. Command codes save programming a > read more

2 New COBOL Compiler Options in V5.1 for Zo/s

01/25/2016 04:37:13 AM

Enterprise COBOL for z/OS , V5.1 introduces two significant compiler options. Based on new code generation and optimization technology the new ARCH -The syntax is ARCH(n). Parameter n is an integer between 6 and 10 inclusive, specifying the machine a > read more

DB2 In CURSOR with Multi Record Fetching

01/24/2016 21:21:19 PM

5 different best examples with Rowset positioning in DB2. These example also you can use for DELETE, UPDATE and SELECT multiple rows. Retrieve first 20 rows with rowset positioning-  EXEC SQL FETCH NEXT ROWSET FROM C1 FOR 20 ROWS INTO :HVA-EMPNO, :H > read more

4 Different Flavours of NetCOBOL

01/24/2016 09:13:08 AM

NetCOBOL for .net The Fujitsu NetCOBOL® for .NET COBOL compiler enables access to the latest web technologies. COBOL applications can easily integrate with Internet XML Web Services and ASP.NET applications. The NetCOBOL for .NET compiler produces M > read more

2 Incredible DFSORT Insert Separators Examples in JCL

01/24/2016 04:30:33 AM

The best example is how you can insert separators: OUTREC FIELDS=(1,8,20C'*',9) or OUTREC BUILD=(1,8,20C'*',9) In the above example, inserting ‘*’ of 20 times. The following are valid separators: blanks zeros strings current date future d > read more


01/23/2016 08:43:35 AM

COBOL loop – Use of PERFORM VARYING  option. For example, you have loaded a file into internal array, then to search internal array you need PERFORM option. PERFORM paragraph-name VARYING a-variable-value FROM start-value BY increment-value UN > read more

DB2 Stored Procedures in 10 Days (Part-1)

01/23/2016 04:22:23 AM

Today’s post -What is stored procedure? -How many types of stored procedures? -What are those? A stored procedure  is a user-written program that can be called by an application with an SQL CALL statement. It is a compiled program that is st > read more

DB2 Complex SQL Query on Self-join example

01/22/2016 22:24:08 PM

Why Self-join you need? To refer fields within the same table you can go for self-join. The below is the example SQL query for self-join. Let us first create two copies of the same table MATCH, M1 and M2: CREATE TABLE M1 AS SELECT * FROM MATCH; CREAT > read more

IBM Debugger Break Point Commands

01/22/2016 00:14:27 AM

LIST AT -Display a list of all breakpoints in the log FINDBP -Find the next statement breakpoint and position the source window to it CLEAR AT -Clear all breakpoints in the current enclave A or AT Line command:- set a breakpoint at the selected state > read more

5 Ways How Data sharing Happens in CICS Transactions

01/21/2016 20:32:42 PM

Below is the list of 5 ways how data sharing happens among CICS transactions: DFHCOMMAREA in RETURN command Common Work Area (CWA) Using CHANNEL command in RETURN Using DISPLAY screen -Data can be stored between pseudoconversational transactions from > read more

2 Best Ideas on How to Re-order fields with BUILD option in DFSORT

01/20/2016 20:36:28 PM

There are 2 ideas you can do re-order the fields in the output file. Option -1 is you need to write a COBOL sort program. You need to code the fields how you want and write into output file. Click here to know sample COBOL sort program. Option-2 is y > read more

2 Incredible Ideas on Deleting a VSAM record in CICS

01/20/2016 09:19:03 AM

The first thing any CICS programmer must do is proper plan for coding. What step first and what step next gives a fair idea on CICS coding. This question asked in CICS interviews many times. Related: Python+Jobs+Best skill by Udemy First option is RE > read more

5 Thoughts on CICS RIDFLD Updating a VSAM record

01/20/2016 04:33:12 AM

Below is the flow chart that states how to UPDATE a VSAM record in CICS: Step:1 First step is you need to read a record from file with UPDATE option. Else, CICS treats it as READ only EXEC CICS READ FILE(FILEA) INTO(Record1) RIDFLD(Key1) UPDATE END-E > read more

DFSORT -How to Delete Fields with FIELDS or BUILD

01/19/2016 22:47:25 PM

Let us take an example and see, how we can delete fields with FILEDS or BUILD The SORT, SUM and OUTREC statements are as follows: SORT FIELDS=(106,4,CH,A) => It sorts records based on fields given SUM FIELDS=(162,4,BI,166,4,BI) ==> It sums the fields > read more

Take Advantage of DB2 v11 Isolation Levels -Read these 10 Tips

01/19/2016 21:57:35 PM

List of DB2 V11 Interview Questions on isolation levels: 1) What is default isolation level? A) If we do not mention isolation level. DB2 consider it as RR. The package Isolation level overrides other isolation level like Result table isolation level > read more

15 Precious Uses of INREC,OUTREC and OUTFIL in JCL DFSORT

01/19/2016 04:30:38 AM

With INREC, OUTREC, and OUTFIL, you can perform a wide variety of tasks while sorting, copying, or merging, including the following: Delete fields. Reorder fields. Insert separators (blanks, zeros, strings, current date, future date, past date, and c > read more

How to call SORT from COBOL Program

01/18/2016 20:12:13 PM

> read more

How to Code SQL in PL/I Program (Part-1 of 2)

01/18/2016 00:54:49 AM

SQL Query to UPDATE in PL/I: EXEC SQL UPDATE DSN8A10.DEPT SET MGRNO = :MGR_NUM WHERE DEPTNO = :INT_DEPT ; The above SQL statement you can use in your PL/I program. The terms EXEC and SQL should be in one line. If you need you can use comments in betw > read more

Tricky CICS Interview Question on Updating VSAM records

01/16/2016 05:02:54 AM

The length of records in an ESDS, a fixed-length RRDS, or a fixed-length KSDS must not be changed on update. However, the length of the record can be changed when rewriting to a KSDS with variable-length records. For a file defined to CICS as contain > read more

IDCAMS -How to COPY VSAM data Set to NON-VSAM Data Set

01/16/2016 04:42:41 AM

Yes, you can copy a VSAM data Set to a Sequential Data Set. The below helps to achieve this: //COPY JOB ,'your name',CLASS=class,TIME=(mm,ss),LINES=lines /*ROUTE PRINT node.location // EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=A //VSAM DD DSN=UF.userid.VS > read more


01/15/2016 20:37:32 PM

COBOL default date format is YYYYMMDD. The below list of COBOL intrinsic functions help to get different DATE related things: CURRENT-DATE None Alphanumeric Current date and time DATE-OF-INTEGER 1 integer Integer Standard date equivalent (YYYYMMDD) o > read more

5 Power Thoughts on DB2 V11 Date Subtraction

01/15/2016 06:46:55 AM

Subtracting dates: Idea-1 The result of subtracting one date (DATE2) from another (DATE1) is a date duration that specifies the number of years, months, and days between the two dates. Idea-2 The data type of the result is DECIMAL(8,0). If DATE1 is g > read more

COBOL Date Logic to Find Number of Days

01/13/2016 23:33:32 PM

You need to know what date is 150 days from today.  Convert today to an integer date, add 150 to it and convert it back. No more checking which months you’re going through to see if it’s a 30 day or 31 day month. No more leap year calcul > read more

DB2 Alternate Isolation Level Option for ‘UR’

01/08/2016 08:30:09 AM

The isolation level option usually improves performance compared to other options. This reads all uncommitted data. No need to wait for till lock is released on the page or row. The other option is SKIP LOCKED DATE Example: SELECT ELEMENT FROM WORKQU > read more

JCL for VSAM alternate index cluster with explanation

01/07/2016 23:24:22 PM

VSAM alternate index is built by IDCAM BLDINDEX perameter. In the below JCL the IDS is ESDS base cluster. The ODS is Alternate index. //BIX1 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* //SYSOUT DD SYSOUT=* //SORTWK01 DD SPACE=(CYL,(50,50)) //SORTWK02 DD > read more

5 Tricky Questions on VSAM alternate Index

01/07/2016 20:46:35 PM

VSAM -Alternate index only allowed on KSDS and ESDS, but not on RRDS Alternate index should be declared for alternate key,and a path. So alternate key is different from alternate index. The path behaves like we are accessing a record from KSDS or ESD > read more

5 Top Limitations of COBOL SEARCH ALL

01/07/2016 09:36:47 AM

The condition following the word WHEN can test only for equality: Valid: WHEN T-CUSTOMER-NO (X1) = CUST-NO-IN Invalid: WHEN T-WEIGHT-MAX (X1) < WEIGHT-MAILED If the condition following the word WHEN is a compound conditional: a. Each part of the cond > read more

DSLIST or 3.4 Option -Different View Modes of Data Sets

01/07/2016 04:30:47 AM

DSLIST commands for data sets lits Continue reading → > read more

How to know new ISPF version changes with SAREA command

01/06/2016 23:18:59 PM

Keeping up with changes to ISPF can be well worth a little effort. When you encounter a new release of ISPF, the first thing you should do is check out the “Changes for this release” Help option, paying particular attention to the Program Develop > read more

Best Example for COBOL SEARCH and WHEN condition

01/05/2016 22:52:48 PM

The below flow chart shows how Search works. So, SEARCH is a serial search. SEARCH ALL is a binary search. Key points: Multiple WHEN conditions you can give AND , ‘=’ , ‘>’, ‘ > read more

CICS Storage GETMAIN Shared Option

01/04/2016 21:09:43 PM

Frequently asked question is – Do we really need to be coded GETMAIN and FREEMAIN commands in all CICS programs? Let us read complete post to get answer for this question. The below is the syntax for GETMAIN command: GETMAIN >>-GETMAIN–SE > read more

Job Skills and Duties for IT Integration Analyst

01/03/2016 07:46:51 AM

An integration analyst is tasked with planning, coordinating, and managing the assimilation of new software applications and programs into an organization’s existing computer network. The analyst typically supports each department by determinin > read more

Java script exceptions Try,Catch and Throw

01/02/2016 01:06:01 AM

function getMonthName (monthNumber) { // JavaScript arrays begin with 0, not 1, so // subtract 1. monthNumber = monthNumber – 1 // Create an array and fill it with 12 values var months = new Array(“Jan”,”Feb”,”Mar”,”Apr”,”May > read more

Hot IT Skills You need for Digital Business

01/02/2016 00:58:06 AM

Top IT Skills You need for Digital India boost. Mobile Development UI or web development Data Science Along with the above skills the additional skills also you need are: Internet of Things Robotics The other jobs that you need hot in demand are: Int > read more

One Check-list for COBOL Tricky Move Statements

12/28/2015 22:22:51 PM

The below list is COBOL complex/tricky move statements that you will come across in day to day COBOL coding. COBOL Move statement from assumed decimal to decimal data type. Four best examples you can refer. Related: Certification in COBOL Programming > read more

How IPCONN and TCPIPSERVICE need to define in CICS Webservice

12/28/2015 05:23:27 AM

An IPCONN is a Transmission Control Protocol/Internet Protocol (TCP/IP) communication link to a remote system. An IPCONN definition specifies the outbound attributes of the TCP/IP connection. How to define IPCONN The inbound attributes of the connect > read more

25 Very Best CICS Questions for Your Next Interview

12/27/2015 21:25:35 PM

Q1: What is meant by Handle Condition Ans-1. It is used to transfer control to the para when the exceptional condition occurs for which it is designed Q2: What is meant by Ignore Condition Ans-2. The IGNORE CONDITION command causes no action to be ta > read more

2 Best Resources for COBOL certification

12/27/2015 08:59:52 AM

Basics: COBOL began in the 1960s as part of the Conference on Data Systems Languages. The language provides programmers with a tool to create programs for businesses using a file-oriented approach. The standards for the language are published by the > read more

JAVA Celebrating 20th B’day

12/27/2015 00:44:44 AM

“Over the past 20 years Java has grown and evolved to become one of the most important and dependable technologies in our industry” explains Georges Saab, Vice President of the Java Platform Group at Oracle.  We are celebrating the 20th year sin > read more

Complete Information on MCC (Multi Currency Cards)

12/26/2015 01:53:44 AM

With multi currency cards you can purchase in different currencies. During the transaction customer can opt for DCC (Dynamic currency conversion), to get exchange rate on that day itself. Else, you can use globally , some international credit cards t > read more

3 Ingenious COBOL OCCURS Examples that You Never Miss

12/25/2015 20:50:36 PM

Tables and the OCCURS clause Suppose you wanted to store your monthly sales figures for the year. You could define 12 fields, one for each month, like this:    05  MONTHLY-SALES-1    PIC S9(5)V99.    05  MONTHLY-SALES-2    PIC S9(5)V99. > read more

2 Awesome differences of DB2 Declare Cursor and Describe Cursor

12/25/2015 03:03:46 AM

The DESCRIBE CURSOR -statement obtains information about the result set that is associated with the cursor. The information, such as column information, is put into a descriptor. Use DESCRIBE CURSOR for result set cursors from stored procedures. The > read more

6 Precious Tips to help better Understand of GDGs in JCL

12/24/2015 21:26:30 PM

1. INTRODUCTION Generation Data Groups or GDGs are a group of data sets which are related to each other chronologically and functionally. These related Data Sets share a unique Data Set Name. Every GDG data set has a Generation number and Version > read more

Understanding The Background Of DFSORT Tip TRLUPD in JCL

12/24/2015 20:49:49 PM

My input data set has a trailer with a count of the data records and a total of a field in the data records. I want to remove some data records. How can I update the count and total in the existing trailer record to reflect the output data records? F > read more

4 Different Steps that you need to do before LOAD process in DB2

12/22/2015 22:48:46 PM

The below are the 4 different steps you need to make sure before start the LOAD process. No sorting of the data rows occurs during LOAD processing. Rows are loaded in the physical sequence in which they are found. Sort your input records in clusteri > read more

Best DB2 SQL Queries to work on Duplicate Values

12/21/2015 20:37:26 PM

How to remove duplicates: SELECT DISTINCT(Column_name) from test_table; The above query selects all distinct values. How to get only duplicate values: SELECT COL1, COL2,COL3,COUNT(*)  FROM TEST_TABLE WHERE PAN_ID >=10 GROUP BY COL1, COL2, COL3 HAVIN > read more

PACBASE For Mainframe Is Not Rocket Science! Here’s Why

12/20/2015 22:55:44 PM

Filed under: PACBASE Tagged: Pacbase guide to first time developers, Pacbase Tips and Technics > read more

15 best VSAM Quiz Questions for Mainframe Developers

12/20/2015 00:59:41 AM

VSAM data can be processed by logical record or by control interval [True] After software-end-of-file is written, the file is in recovery [False] VERIFY cannot be used for an empty data set or an LDS. [True] Strings allow concurrent positioning withi > read more

How to use EXPLAIN in COBOL program

12/19/2015 09:00:50 AM

The following statement sets the CURRENT EXPLAIN MODE special register, so that Explain information will be captured for any subsequent eligible dynamic SQL statements and the statement will not be executed. SET CURRENT EXPLAIN MODE = EXPLAINFiled un > read more

Happy New Year 2016

12/19/2015 08:30:07 AM in service for 6 years. Most popular site across the world. wishes happy , prosperous, healthy new year for all its readers across the world. Thank you all for keeping this site most successful and one of the best blog/site.Fi > read more

JCL GDG Required and Optional Parameters

12/19/2015 06:00:29 AM

Required: NAME(entryname) Specifies the name of the GDG being defined. LIMIT(limit) Specifies the maximum number, from 1 to 255, of GDSs that can be associated with the GDG being defined. Optional: EMPTY remove all GDS entries from GDG base when a > read more

The Linux Mainframe -Emulators and Commands

12/17/2015 21:00:50 PM

You can learn Linux through on-line courses. If you know already mainframe this is easy to work on Linux mainframe. Lot of jobs available with combination of these skills. What are the different Linuxes: You can run mainframe Linuxes without fear of > read more

COBOL move Comp-3 to Numeric

12/15/2015 20:41:58 PM

How to move COBOL comp-3 value into numeric format Continue reading → > read more

Complete List of COBOL Picture clause Charecters

12/15/2015 20:11:40 PM

Filed under: COBOL Tagged: List of COBOL Picture clause Charecters > read more

Want to Know More About Import, Load and Special Register in DB2

12/14/2015 20:47:44 PM

Special register — a storage area that is defined for an application process by DB2 and isused to store information that can be referenced in SQL statements. Examples of a “specialregister” are CURRENT TIMESTAMP or CURRENT USER. Differe > read more

The 10 Best IT Skills in 2016

12/13/2015 07:57:43 AM

UX/UI Design or Developers-Consumers won’t settle for anything less than a quick, seamless and painless user experience, whether they’re using enterprise software, shopping or gaming. User experience and user interface (UX/UI) designers a > read more

Are You Ready to Know DB2 Schema? Read this 3 Key Points!

12/12/2015 08:46:36 AM

A schema is a logical grouping of database objects. It also is used for name qualifiers, which help naturally organize database objects by their name. Continue reading → > read more

DB2 V10 the best enhancement for COPY Utility

12/11/2015 00:51:37 AM

DB2 is a leading database in the market. The skills of DB2 are more valuable than any other database. Please check latest available jobs. Continue reading → > read more

3 Key Technical Skills You Need for IoT (Internet-of-things) Jobs

12/09/2015 04:31:42 AM

The Internet of Things (IoT) is about to transform the next decade. Literally everything will be connected to everything. Some estimate that 50 billion devices will be IoT-connected by 2020. The clock on the connected device transition is ticking ver > read more

Master DB2 Complex Interview Questions In Just A Few Hours!

12/08/2015 22:18:06 PM

The document attached here contains lots of best Db2 interview questions. Collected questions from different  DB2 interviews. The summary of best Questions in DB2: How to generate Sequence number in DB2 How to tell answer for Restart logic in DB2 W > read more

A complete guide on DB2 v10 Virtual Storage Relief New addition

12/06/2015 23:33:51 PM

Prior to DB2 10, the primary constraint to vertical scalability was virtual storage below the 2 GB bar. DB2 V8 introduced 64-bit support for DB2 control blocks and data areas. DB2 9 for z/OS provided an additional10-15% relief for agent thread usag > read more

SQL Error -500 -Cursor was closed when the connection destroyed

12/04/2015 12:41:28 PM

Explanation: The FETCH, UPDATE, DELETE, or CLOSE statement identifies a closed cursor that was defined with the WITH HOLD option. The cursor was closed when the connection on which it was dependent was destroyed during a commit operation. The connect > read more

You have answer for this JOB COND parameter Question in JCL

12/03/2015 21:34:10 PM

Question: By using COND parameter how will you stop executing first job step? Ans: In reality, this is not possible. Always when step runs, then it generates return code. So, fromm second step onwards you can control the execution of steps by compari > read more

10 Superb Ways to write Your COBOL Program

12/03/2015 06:49:53 AM

Your skill and experiences says, how you can write your program. That needs some essential tips you need to follow. Always remove extra variables declared in working storage section Use different paras for different business logic . Do not put all yo > read more

How to write ‘IF condition’ to check Multiple validations

12/02/2015 20:44:38 PM

The below examples are selected IF conditions. These seems little tricky ‘IF Conditions’. Easily you can get idea on usage of multiple conditions. So, you can use these in your projects. Example:-1 IF (FIELDA NOT > 55 AND NOT < 10) Exampl > read more

3 Quick Tips Mastering COND parameter usage in JOB and STEP

12/01/2015 20:17:31 PM

The parameter COND controls your job steps execution as you wish in your JCL. There are some key diffrences for giving COND parameter in JOB and in STEP. To indicate the results of its execution, a program can issue a return code. Using a COND parame > read more

5 Must Know Tips If You Want To Use VSAM Alternate Index

11/30/2015 22:38:48 PM

Alternate indexes (AIXs) allow logical records of a KSDS or of an ESDS (in this context, a base cluster) to be accessed sequentially and directly by more than one key field. AIX eliminate the need to store the same data in different sequences in mult > read more

Everything You Need To Know About DB2 Distributed Computing

11/29/2015 23:10:13 PM

Distributed computing environments typically involve requests from users at one DBMS client that are processed by a DBMS server. The server DBMS is typically remote to the client. Excellent job opportunities, if  you are good at Distributed Computin > read more

Ultimate answer for GDG (+1) vs GDG (+2) Generation in JCL

11/29/2015 06:01:03 AM

GDG stands for generation data group. Always GDGs take care of your dataset with different generations. A best example is a telephone company operating its accounts, processing billing for its customers. There are files to generate all over the month > read more

Understanding The Background Of Data Modelling Cordinality.

11/28/2015 21:48:40 PM

When performing data modeling in preparation for designing a database, knowing that two entities are related to each other is not sufficient. In addition to knowing that they are related, the cardinality of the relationship must also be documented. C > read more

Never miss this Tableau-9 Essentials Free Video Training

11/28/2015 01:19:13 AM

The Tableau training website offers a multitude of resources for Tableau users with many of the videos being brief and addressing specific topics. This self-study syllabus organizes those videos to help you find the training you need on specific topi > read more

Mainframe Self Study Materials with Complex Interview Questions

11/28/2015 01:06:20 AM

The below list is the best selected interview Questions. PDF materials. You can download @Free of cost. >>>>VSAM 1.0 >>>>REXX 1.0 >>>>MVSQuest Second Edition >>>>MVSQuest Second Edition – Tools >>>>MQSeries 1.0 >>MAINFRAMEQ&A >>Mainframe refere > read more

COBOL REDEFINES You Can Override Data-type

11/26/2015 20:37:02 PM

COBOL REDEFINES Quiz Questions| COBOL REDEFINES Interview Questions. Best COBOL Redefines examples and important rules you can apply for your COBOL development. 01 WS–OLD PIC X(10). 01 WS–NEW1 REDEFINES WS–OLD PIC 9(8). 01 WS– > read more

How to Create VSAM dataset without Using IDCAMS and Option 3.2

11/25/2015 23:22:43 PM

Many friends asked how to create VSAM dataset without IDCAMS and Option 3.2. Of course you can use tools to create VSAM dataset. Using SMS (Storage management sub system) you can create a dataset. The following parameters you need give in JCL, RECORG > read more

Use these Technics to improve COBOL Program Performance

11/25/2015 01:23:06 AM

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

25 Awesome Things You Can Learn From These COBOL Interview Questions

11/23/2015 03:29:59 AM

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

© 2006-2016, All Rights Reserved