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
