- Blog
- Blog
- Homepage
- Homepage
-
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
-
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 PIC S9(9) BINARY. 05 SQLWARN.…
-
List of Mainframe User Companies Worldwide
http://www.sysed.com/tech_assessments/leader/mainframe_legacy_systems.asp
-
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
-
Best JCL Interview Questions – Splitting Input File
Sample JCL for SORT and more interview questions.
-
DB2 Functions POSSTR Alternative to LOCATE
LOCATE and POSSTR string functions in DB2
-
Here is The Permissible Length of DB2-Object-Names
The maximum limits that can be used in DB2 database a quick reference.
Srinimf 