-
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 ⇢
-
Mainframe ISPF Commands(3 Of 5)
21) I am not able to delete a dataset that resides on a tape. A. Yes. You cannot delete/rename a tape dataset. Only you can uncatalog it. ISPF Editor 22) How do I see only those lines that contain a particular string? A. Type ‘X all’ then ‘F all ‘search-string’… Read More ⇢
-
IMS DB Interview Questions for Beginners
IMS DB low complex interview questions for less experienced developers. Read More ⇢
-
5 More Frequently Asked DB2 SQL Queries
Frequently asked SQL queries you need to know. Useful for SQL developer interviews. Read More ⇢
-
Mainframe ISPF Commands(2 Of 5)
In my series of posts, I am giving best ISPF tips to improve productivity. Across the companies following these tips.Mainframe+cobol+db2+jobs+USA+India+UK+ . Read my part-1 tips, if you missed. 11) How do I find out which base cluster does an alternate index file belong to? A. Display information in file aid for the… Read More ⇢
Srinimf 