-
COBOL: Indexed BY Vs USAGE Vs OCCURS
In COBOL, Index data items, OCCURS, and KEY clauses are tricky. Explained the benefits and usage of these items with examples. Read More ⇢
-
How to Use OUTPUT statement in JCL
SYSOUT statement in JCL (Job control Language), a simple example of how to use 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. how to print multiple copies of a data set… Read More ⇢
-
How to Use DB2 LOCATE Built-in Function
Checkout here my earlier post on built-in functions. LOCATE is a Scalar function. Here is my ideas how to use correctly. Below is the Syntax for LOCATE function SELECT LOCATE(‘String to be searched’, Source string’, Start position)FROM SYSIBM.SYSDUMMY1; Key points in LOCATE function The LOCATE function returns the starting position… Read More ⇢
-
DB2 Tutorial For Software Developers (3 of 5)
DB2 tutorial is good for both DB2 and mainframe developers is it is quick to read and given in the form of questions and answers. Read my part-2 post on DB2 tutorial. Data Definition Language(DDL) CREATE: –This statement is used to create objects Syntax : For Creating a Table CREATE… Read More ⇢
-
Top Data warehousing Interview Questions (Part 1 of 2)
Data warehousing interview questions useful to read before you give an interview or training. Read More ⇢
-
SQL Built-in Functions to write better query
All the built-in functions you cannot use in SQL queries. Some functions help you achieve greater performance in SQL queries. Follow these suggestions to get an idea about alternative SQL built-in functions. Read More ⇢
-
CICS ATI, START Real time Macros for new programmers
Command macros to be used in CICS for ATI and START functions Read More ⇢
-
Easytrieve Guide for Mainframe Programmers (5 of 20)
Read my Post-1, Post-2, Post-3, Post-4 on Easytrieve. 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… Read More ⇢
-
DB2 Tutorial For Software Developers (2 of 5)
DB2 tutorial to learn quickly useful for mainframe developers. Read More ⇢
Srinimf 
You must be logged in to post a comment.