- Blog
- Blog
- Homepage
- Homepage
-
COBOL VSAM Return Code: Here’s Example How to Define it
There are teo different status codes. One staus code is related to COBOL. The other one is related to VSAM. The VSAM returned codes to COBOL are saved in VSAM return code variable. These tips help you to use for ESDS, RRDS and KSDS files.
-
Associate Vs. Allocate: DB2 Stored Procedure Example
Here’s an example of DB2 Stored procedure and explained the purpose of Associate and Allocate.
-
VSAM: How to Resolve File OPEN Errors
A resolution to resolve VSAM file OPEN errors. You will get file status code as 35. This means you have received file OPEN error.
-
Mastering VSAM: A Comprehensive Guide
The goal of this VSAM tutorial is for who have not had practical experience and for experienced developers. It is presented in simple English including handling files, errors handling and day to day use all utilities in VSAM.
-
How the Bigdata and ML You Need to Solve Data Problems
Machine Learning has a relation with Big data to solve big data problems. The relation is to show value analytics for companies to generate more revenues.
-
Why DLITCBL in IMS DB programs you need
IMS DB Mandatory statement is DLITCBL for all COBOL and IMSDB programs. Read for full details
-
How to Create Physical and Symbolic Maps in CICS
Symbolic Maps are generated in the same language. The physical Maps are being used only at run time. To run any CICS online program you need both Maps. The symbolic map contains all the variables that you need to mention in the program.
-
SQL: Column Vs Table Vs Row Vs Table Functions
There are four different SQL functions in SQL. Each function makes you so confuse when you are very beginner. This post explains SQL functions in Simple manner for beginners as well as for advanced programmers and developers.
-
Thumb Rule for Secondary Indexes Per Table
The secondary index is most critical object, after the primary index. This post explains the most optimum value for number of secondary indexes you can give on any Table.
-
SQL Index Vs Database Index: Top Differences
The differences between SQL index and Database index is little tricky question. This is the most confusing and discussed in many social media. The differences listed here are simple and you can grasp the subject quickly.
-
Essential DL/I Functions for Efficient IMS DB Operations
The complete list of DL/I functions that you need to write a COBOL program for IMS DB database. This list helps you write your programs so effectively. The main use of DL/I functions is to interact with database and to manipulate segments in IMS DB database.
-
How to Use DECODE in SQL Query and Its Real Purpose
The DECODE scalar function in DB2 SQL helps you handle logic related scenarios. You can also handle NULL values and you can replace NULL values with values as you wish in your end result.