-
Grouping Sets: How to Simplify SQL Query
THE GROUPING SETS option’s real usage is to make the union of two or more groups of rows into a single result set. Introduced in DB2V11. The best example given and explained to use it and improve your SQL Query. Grouping Sets in DB2 It is logically equivalent to the… Read More ⇢
-
What is EIB Storage Area in CICS
The EIB is also called executive interface block. The name tells that it is a interface to calling module. So the every action will be updated in EIB fields in CICS. I have given the most frequently used fields to execute CICS programs for your ready reference. Read More ⇢
-
Writing Transaction File to Master File in COBOL- 8 Tips
COBOL-Master file-Transaction file. Many interviews these questions are asked in COBOL, transaction file and master file. Easy ideas I have given for your sure success in your interviews. MASTER FILE Master files contain the entire data of a particular application. For example, a master file may contain the entire data… Read More ⇢
-
SQL Before Drop a Column Here are The Conditions to Check
ALTER statement we can use in DB2 SQL query to drop a column. ALTER TABLE table_nameDROP COLUMN column_name But, there are lot other conditions involved, which column we can drop or not. The containing table space is not a universal table space. The table is a created global temporary table.… Read More ⇢
-
How to Write SQL to Create Global Variables
Global variables new additions in Db2 v11 and how to create them read today. Read More ⇢
-
How to Understand Cashback Rewards Program Quickly
Benefit to cardholders if they use cashback rewards program. How this program works explained. Read More ⇢
-
DB2 SQL Query Performance Tuning (3 of 3)
SQL performance tuning tips for database developers. Read more. Read More ⇢
-
DB2 INSERT’s Performance and What is Newly Added
In DB2, performance affects on the size of the index. When you create an index, it is useful to exclude one or more values from being indexed – such as values that will never be used in a SQL query. For example NULL, blank, and 0. Improvement in Performance DB2… Read More ⇢
-
What are Array functions Read today
Array functions in Db2 explained with how to use. Read More ⇢
Srinimf 