-
DB2: CEILING Scalar Function Example
SQL CEIL function explained with best examples Read More ⇢
-
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… Read More ⇢
-
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… Read More ⇢
-
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. Read More ⇢
-
Introduction to VBScript – (1 to 9) Videos
The awesome free VBScript video tutorials so that you can learn writing scripts quickly. Read more. 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… Read More ⇢
-
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… Read More ⇢
-
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… Read More ⇢
-
MQSeries Tutorial for Mainframe Programmers (4 of 5)
Lean different types of queues being used in mainframe MQSeries. Read More ⇢
Srinimf 