-
How to Use Fetch First ‘n’ Rows Best Examples
SQL Query On How to Use Fetch SELECT LASTNAME, FIRSTNAME, EMPNO, SALARYFROM EMPORDER BY SALARY DESCFETCH FIRST 20 ROWS ONLY; How To use FETCH FIRST n ROWS ONLY within a subquery. SELECT * FROM EMPWHERE EMPNO IN (SELECT RESPEMP FROM PROJECTORDER BY PROJNO FETCH FIRST 3 ROWS ONLY) Query transformations become… Read More ⇢
-
DB2 PLAN_Bind Real Concept
DB2 PLAN bind to execute DB2 programs in more than one sub system Read More ⇢
-
DB2 Sub-system Vs. Instance: Top Differences
DB2 Subsystem In DB2 S/390, a DB2 subsystem provides a separate DB2 environment similar to a DB2 ULWO instance. Several DB2 S/390 subsystems can be installed in the same machine logical partition (LPAR), and they can only communicate with each other through the Distributed Data Facility (DDF). (Data sharing provides… Read More ⇢
-
SQL: Truncate Vs Delete in DB2
These 5 key differences in DB2 for TRUNCATE and DELETE help to understand much better of their functionality. A good refresher for DB2 developers. Read More ⇢
-
Mainframe: How to Read a Tape File
Tape files in mainframe are not readable. So this sample JCL you can use to copy to DASD file and you can read. Read More ⇢
-
Sample SQL Query: How to Define Identity-Column
Here are ideas on how to identity-column on a table. Identity column on a new table An identity column provides a way for DB2 to automatically generate a unique numeric value for each row that is added to the table. When creating a table where you know that you need… Read More ⇢
-
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… Read More ⇢
-
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. Read More ⇢
-
Srinimf.Jobthread
Srinimf.Jobthread. Read More ⇢
Srinimf 