- Blog
- Blog
- Homepage
- Homepage
-
How to Write SQL Queries Efficiently in DB2
Many times the three tables could all be coded with inner joins, which would run more efficiently. Outer joins are not inefficient, but if they bring in extra exception rows, and a subsequent inner join then gets rid of those extra rows, was processing not needed. SQL Join Query Ideas to Write Efficiently Also, make…
-
Super Package, Complex Package and Participating Package
The different packages available in changeman which is mainframe version control tool. Explained well and in a way easy to understand.
-
Srinimf.Jobthread
Srinimf.Jobthread.
-
Database Challenge-Show Your Knowledge
Test your knowledge on various databases and get yourself confidence quickly.
-
DB2: List of Top Table Spaces Quick Tutorial
Revolving Table spaces all information you need to know.
-
Intertest – CICS Programs Debugger
CA InterTest for CICS is an interactive testing and debugging product for CICS applications written in COBOL, PL/1, and Assembler. You can download free user guides here.
-
DB2: How to get Timestamp from Sysdummy1
The best SQL query to select Timestamp from sysdummy1 table. Read more with example.
-
IBM Debugger Complete Tutorial
IBM debugger tool commands and setup for Mainframe projects. You can use it for debugging purpose.
-
DB2: Here is All About Explain Plan
Tutorial on explain plan in DB2. Covers the use of Explain in tuning the performance.
-
Teradata Real Database to Practice Online
The best resources that available to learn and practice teradata Quickly.
-
SQL: GROUP BY Preferable than DISTINCT Why
We should not use DISTINCT in SQL query, it takes more up. Select distict ename,enum from emp where ename=’krishna’ and enum=1000 The alternative way is: Select ename,enum from emp where ename=’krishna’ and enum=1000 group by ename,enum
-
DB2 v11 SQL: Remove Duplicates Enhancement
Enhanced duplicate removal: – Lots of queries require duplicate removal: e.g. DISTINCT, GROUP BY, etc. – Dup elimination via sorting can be expensive – New techniques: Index duplicate removal, early out Index duplicate removal: One feature that the IDUG team has been investigating is improvements to Unique/DISTINCT and GROUP BY processing. This is an enhancement…
Srinimf 