-
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 ⇢
-
Best JCL Interview Questions – Splitting Input File
Sample JCL for SORT and more interview questions. Read More ⇢
-
DB2 Functions POSSTR Alternative to LOCATE
LOCATE and POSSTR string functions in DB2 Read More ⇢
Srinimf 