-
Easytrieve Guide for Mainframe Programmers (6 of 20)
How to print reports in Easytrieve program explained all the syntax details. Read More ⇢
-
COBOL: Indexed By Vs Subscript key Differences
Index vs Subscript and the key differences in terms of COBOL Read More ⇢
-
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 ⇢
Srinimf 