- Blog
- Blog
- Homepage
- Homepage
-
RDBMS: Schema Vs Instance Top Differences
Schema in RDBMS A schema is a collection of named database objects. Schemas provide a way to logically classify objects such as tables, views, triggers, routines, or packages. A schema name is used as the first part of a two-part object name. For example, if the EMPLOYEE table is created under the schema name JENNIFER,…
-
DB2 V11- Analytics and Bigdata Features
DB2 11 also boasts new features for supporting big data and analytical processing. Probably the biggest is the ability to support Hadoop access. DB2 11 can be used to enable applications to easily and efficiently access Hadoop data sources using the generic table UDF capability to create a variable shape of UDF output table. Doing…
-
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 most important for complex queries,…
-
DB2 PLAN_Bind Real Concept
DB2 PLAN bind to execute DB2 programs in more than one sub system
-
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 another way that DB2 subsystems…
-
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.
-
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.
-
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 to uniquely identify each row…
-
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 to Write Efficiently Also, make…
-
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.
-
Srinimf.Jobthread
Srinimf.Jobthread.
-
Database Challenge-Show Your Knowledge
Test your knowledge on various databases and get yourself confidence quickly.
Srinimf 