-
DB2 SQL Functions Count Vs Count_Big
How to use count and count_big in SQL. Explained with examples and differences. Read More ⇢
-
SQL CAST Function: How to Convert CHAR to VARCHAR
Cast function in SQL useful to covert one data-type to other, Read More ⇢
-
CICS Quiz Part 1
I created a CICS quiz with 11 questions. Your pass score is 80%. Focussed, on important basics. In my next posts, I will give some more quizzes. Topics covered: – Files – MAPS -Frequent Abends – TSQ and TDQ -Subroutines Start here to take Quiz CICS Part 1. Read More ⇢
-
ISPF Find Commands
Here is a list of ISPF ‘FIND’ command and its options. These are useful for ISPF editor. Read More ⇢
-
DB2- Use of ‘COALESCE’ Function (1 of 2)
The “COALESCE” function is one of the frequently used functions in DB2. Before going into detail, I just want to describe it in layman terms. This function validates for NULL, and secondly, if NULL is there it assumes some value as we give in the function. Syntax: COALESCE(epression1,expression2) It is like decision maker. Its… Read More ⇢
-
Role of Small Talks to speak with new people
Questions and Small talks really boost your speaking skills with new people. Read More ⇢
-
SQL CAST Function Convert Numeric to Decimal
CAST function rules to convert NULL value as an integer of Char. Read More ⇢
-
COBOL: Importance of 7th Column
COBOL 7th column you can use for different purposes. There are five real uses and it is important. Read more. Read More ⇢
-
Why ‘PIC’ Clause Not Required for COBOL Comp, Comp-1, Comp-2
Comp variables popularly use in all mainframe technologies – COBOL/IMSDB/IMSDC/CICS. At word boundaries Comp-1 and Comp-2 are more efficient than comp-3 (takes less space). COMP Below is the range for “COMP” data type. COMP-1 and COMP-2 Let us take on “COMP-1”. It stores data internally as 1 word. It takes 4 bytes… Read More ⇢
Srinimf 