-
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 ⇢
-
COBOL Performance Tuning-Part:1
COBOL performance tuning tips and ideas to apply today Read More ⇢
-
ISPF- Commands Pack ON/OFF – Part 2
ISPF commands/macros are popular while editing files/programs/jcls in PDS members, Endevor and Changeman. In my previous lot I have given some commands. PACK- This is one of the most important profile command. I will give more details on it. Pack OFF ==> It decompress the data. So this will not a problem. The data will… Read More ⇢
-
Soft skills: How to Improve Communication Among Team
Here are the top ideas, which you practice that help your communication among the team. Read More ⇢
-
Cobol- Signed Number and Memory
This is very interesting. one day my old colleague went for an interview. He was asked-tell something about signed numbers. The field we define when sign is involved is PIC S9(2). We can enter two digit negative value. For example, -24. Developer has to remember is, in the file, the signed numbers we… Read More ⇢
Srinimf 