- Blog
- Blog
- Homepage
- Homepage
-
How to ‘Sort’ Input dataset in JCL
Sort card you can write in JCL to select few fields from input dataset and after sorting you can write those records into output file. The JCL is good sort example.
-
10 Top COBOL Compilation Errors With Root Causes
Here is a list of COBOL compilation errors. Also, added root causes so that you can refer to these while fixing your programs.
-
Limitations of COBOL Intrinsic Functions
Rules you need to know on COBOL intrinsic functions.
-
Aggregate functions Vs Scalar functions in DB2
Top differences of Aggregate functions and Scalar functions
-
DB2: CEILING Scalar Function Example
SQL CEIL function explained with best examples
-
DB2 Large object data types- Advantage of LOBs
You can use large object data types to store audio, video, images, and other files that are larger than 32 KB. The VARCHAR, VARGRAPHIC, and VARBINARY data types have a storage limit of 32 KB. However, applications often need to store large text documents or additional data types such as audio, video, drawings, images, and…
-
How to Set Position for File Using COBOL START Statement
The START statement is the best option in COBOL to deal with indexed files. In this post you will learn also best interview questions asked; What is KEY IS How record will START in this file position Exception handling The format of the START statement is given below: START file-name [KEY IS {EQUAL TO GREATER…
-
SQL ‘Aggregate’ Vs ‘DISTINCT’
The power of DB2 aggregate functions well explained with examples and syntax. Especially it covered all the rules related to SQL aggregate functions in a way dummies can understand quickly.
-
Introduction to VBScript – (1 to 9) Videos
The awesome free VBScript video tutorials so that you can learn writing scripts quickly. Read more.
-
ISPF Mainframe Certification Commands
EDITING A DATA SET – If you do not know the Data Set Name: Obtain a list of data sets using screen 3.4 Tab to the left of the desired data set, type e for edit and press Return. This will bring the data set up in a full-screen editor. If you know the Data set…
-
DB2: How to Fix Cursor Open Error Quickly
The ‘OPEN’ cursor fails during execution of the DB2 program is mainly due to lack of privileges. Resolution to Fix Cursor Open Error The privilege set consists of the privileges that are held by the authorization ID of the owner of the plan or package. If the plan or package is bound with VALIDATE(BIND), the…
-
IBM Q-Replication in Zo/s environment
Q Replication captures changes to source tables and converts committed transactional data to messages. The data is not staged in tables. As soon as the data is committed at the source and read by Q Replication, the data is sent to the target location through WebSphere MQ Q-Replication Functionality They replicate data from and to…
Srinimf 