Blog Posts - Mainframe



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

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

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

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

Mainframe: Batch JCL Conditon Code Confusing Question

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

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

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

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

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

Mainframe: 10 Powerful Points for COBOL and SQL programs

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

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

#Cloud Computing Middleware an approach- Virtualization http://t.co/tZ325ktkGd #biganalytics #bigdata — ApplyBigAnalytics (@applyanalytics) July 27, 2015 CEMT lets you display and change the status of resources, including programs, transactions...

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

Different kinds of NoSQL Databases in the age of Big data | Apply Big Analytics http://t.co/9YNFCZW1iG — Srinimf (@srinimf) July 26, 2015 1) Which block MFS uses for input message? DIF- Device input format 2) What is second block it uses?

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

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

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

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

Easytrieve Guide for Mainframe Programmers (6 of 20)

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

5 Key differences of INDEX and Subscript for COBOL programmers

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

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

I want to share very important points on COBOL index. First point is Index cannot passed into SUB-PROGRAM and why. Second, is Index is not an Integer. Most mainframe COBOL programmers confused much here of how to use OCCURS clause with KEY phrase...

Mainframe: Reduce your Coding lines using OUTPUT statement in JCL (1 of 2)

Tricky SYSOUT statement in JCL(Job control Language), and ignore it many times by programmers to understand it correctly. Why SYSOUT is coded in JCL SYSOUT data sets are output files that are designed to be printed rather than stored on DASD or tape.

Mainframe: DB2 LOCATE Built-in Function-Best examples

You already enjoyed with my earlier post on built-in functions. LOCATE is a Scalar function. Syntax for LOCATE function is as follows: SELECT LOCATE(‘String to be searched’, Source string’, Start position) FROM SYSIBM.SYSDUMMY1; Key...

Mainframe: DB2 Locate Built-in Function

You already enjoyed with my earlier post on built-in functions. LOCATE is a Scalar function. Syntax for LOCATE function is as follows: SELECT LOCATE(‘String to be searched’, Source string’, Start position) FROM SYSIBM.SYSDUMMY1; Key...

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

Data Definition Language(DDL) CREATE: –This statement is used to create objects Syntax : For Creating a Table CREATE TABLE <tabname> (Col Definitions) PRIMARY KEY(Columns) / FOREIGN KEY UNIQUE (Colname) (referential constraint) [LIKE Ta...

Informatica: Top Data warehousing Interview Questions(Part 1 of 2)

I hope you enjoyed with my post informatica transformations. This is big post on interview questions. What is data warehouse? A data warehouse is a electronic storage of an Organization’s historical data for the purpose of analysis and reportin...

Mainframe: Simplify Your DB2 SQL Query with these Built-in Functions

DB2 built-in functions are great to use to simplify your SQL query. There are different functions available. Alternative functions improve the understanding of SQL query. Use Left side functions (alternative functions) instead of Right side function...

Easytrieve Guide for Mainframe Programmers (5 of 20)

HEADING Report headings can be supplied in the field definition of a data item. When NOT coded with the data item, the actual field name is used as a heading. The heading can be specified by simply using the HEADING parameter of the field definition.


Trending Topics

Close