- Blog
- Blog
- Homepage
- Homepage
-
DB2 Fetch ideas on how to optimize result
DB2 fetch top rules you need to know while using it in your SQL queries.
-
How to make Mentor Networking in current Company
Make network of mentors to advance in career and to achieve your aspirations or goals
-
JCL- Sort ‘PD’ to ‘ZD’ with Length Calculation
The best method to calculate length during conversion of PD to ZD in JCL DFSORT. Highly useful and time saving tip and useful for all mainframe developers.
-
DB2 SQL Functions Count Vs Count_Big
How to use count and count_big in SQL. Explained with examples and differences.
-
SQL CAST Function: How to Convert CHAR to VARCHAR
Cast function in SQL useful to covert one data-type to other,
-
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.
-
ISPF Find Commands
Here is a list of ISPF ‘FIND’ command and its options. These are useful for ISPF editor.
-
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 uses are many. Usage-1: CASE WHEN…
-
Role of Small Talks to speak with new people
Questions and Small talks really boost your speaking skills with new people.
-
SQL CAST Function Convert Numeric to Decimal
CAST function rules to convert NULL value as an integer of Char.
-
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 of space. For Comp-2, the…
Srinimf 