The Db2 Portal Blog

News, views, and items of interest on IBM's Db2 database management system and mainframes.

Tuesday, May 29, 2007

INSTEAD OF Triggers [DB2 9 for z/OS]

›
DB2 9 for z/OS introduces a new type of trigger: the INSTEAD OF trigger. The primary usage of INSTEAD OF triggers is to enable views that wo...
Thursday, May 24, 2007

LOB Enhancements [DB2 9 for z/OS]

›
IBM focused their attention on improving DB2’s ability to store and manage LOB data in Version 9. As anyone who has tried to use LOBs in a p...
Monday, May 21, 2007

New OLAP Capabilities [DB2 9 for z/OS]

›
DB2 9 for z/OS offers several new SQL improvements focused on improving OLAP functionality. The OLAP functions provide the ability to return...
5 comments:
Tuesday, May 15, 2007

Implicitly Hidden Columns [DB2 9 for z/OS]

›
Another nice new feature deep in the bowels of DB2 9 for z/OS is the ability to hide columns from the SELECT * statement. As far back as any...
2 comments:
Monday, May 14, 2007

Index on Expressions [DB2 9 for z/OS]

›
DB2 9 for z/OS offers, for the first time, the ability to create an index on data that is not technically in the table. At this point, you m...
8 comments:
‹
›
Home
View web version

About Me

My photo
Craig S. Mullins
Sugar Land, Texas, United States
Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher/editor for The Database Site.

Craig has been named by IBM as a Gold Consultant and an IBM Champion for Analytics. He has been named as one of the Top 200 Thought Leaders in Big Data and Analytics by AnalyticsWeek magazine.

Craig has over three decades of experience in all facets of database systems development and has worked with Db2 since V1. You may know Craig from his popular books: Db2 Developer's Guide (covering IBM's mainframe RDBMS)... A Guide to Db2 Performance for Application Developers (how to write efficient Db2 programs) and... Database Administration: The Complete Guide to DBA Practices and Procedures (a guide to heterogenous DBA).
View my complete profile
Powered by Blogger.