-
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 Read More ⇢
-
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… Read More ⇢
-
DB2 SQL Join: Here are Best Practices
Top performance tuning tips you need to follow while writing SQL queries using JOINS. Read more. 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 Read More ⇢
-
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. Read More ⇢
-
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 Read More ⇢
-
COBOL – SQLCA is Not Mandatory- Why
SQLCA – Also called SQL communication is area, is not mandatory in COBOL Program. 01 SQLCA. 05 SQLCAID PIC X(8). 05 SQLCABC PIC S9(9) BINARY. 05 SQLCODE PIC S9(9) BINARY. 05 SQLERRM. 49 SQLERRML PIC S9(4) BINARY. 49 SQLERRMC PIC X(70). 05 SQLERRP PIC X(8). 05 SQLERRD OCCURS 6 TIMES… Read More ⇢
-
List of Mainframe User Companies Worldwide
http://www.sysed.com/tech_assessments/leader/mainframe_legacy_systems.asp Read More ⇢
-
How to Rank the Output Using Over Partition By DB2 SQL
How to rank the data in the output using partition by statement in DB2 SQL query Read More ⇢
Srinimf 