- Blog
- Blog
- Homepage
- Homepage
-
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…
-
DB2 SQL Join: Here are Best Practices
Top performance tuning tips you need to follow while writing SQL queries using JOINS. Read more.
-
Teradata best utility Active Load
These methods exercise such Teradata Database features as queue tables and triggers, and use FastLoad, MultiLoad, TPump, standalone utilities, and Teradata Parallel Transporter
-
M204 – Model 204 Database
The complete tutorial for M204 also called model 204 database. Model 204 is a database management system for IBM and compatible mainframe computers, “born” 1965 October 13, and first deployed in 1972.
-
How to Use Multiple Joins in SQL: Best Example
Here is the best example of writing an SQL query with multiple JOIN statements. SQL Query with multiple Join Statements Related
Srinimf 