- Blog
- Blog
- Homepage
- Homepage
-
Easytrieve Guide for Mainframe Programmers (6 of 20)
How to print reports in Easytrieve program explained all the syntax details.
-
COBOL: Indexed By Vs Subscript key Differences
Index vs Subscript and the key differences in terms of COBOL
-
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.
-
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 without rerunning the entire job…
-
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 of search-string within source-string. If…
-
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 TABLE <tabname> (Col Definitions) PRIMARY…
-
Top Data warehousing Interview Questions (Part 1 of 2)
Data warehousing interview questions useful to read before you give an interview or training.
-
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.
-
CICS ATI, START Real time Macros for new programmers
Command macros to be used in CICS for ATI and START functions
-
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 definition. The HEADING parameter has…
-
DB2 Tutorial For Software Developers (2 of 5)
DB2 tutorial to learn quickly useful for mainframe developers.
-
Top IMS DB Status codes Asked in Many Interviews
The most popular and mostly asked IMS DB or IMS DC status codes in interviews.
You must be logged in to post a comment.