On the iSeries, limited support for INSTEAD OF triggers was delivered by PTF SI16101 for i5/OS V5R3 systems. Unfortunately, data manipulation against multi-table views involving Joins or Unions was not yet supported, limiting their usefulness to single table views. This limitation has been lifted in V5R4.
The examples shown in this story were originally developed on DB2 UDB for Windows V8.2.1 and required very little modification to run on the iSeries. It's good to see the iSeries continue to receive the enhancements that other versions of DB2 have
Tuesday, March 14, 2006
- Yahoo! Mail: Revenge of the Oddpost
- Creating an as400 Query
- Javalobby - Java J2EE Programming Forums - Coldtags suite 2.1: 210+ custom JSP tags
- Free Iseries Accounts Available
- How do you re-enable the user id for STRSST when it has been disabled?
- Other as400 tips sites
- Differences between iseries as400 API QMHLJOBL and QGYOLJBL
- AS400 PRTF - Report Layout Utility
- What is QZHQSSRV job?
- as400 Iseries Tips