Re: Triggers :)

["Al Barsa, Jr." <barsa2@xxxxxxx>]

At 06:18 PM 3/3/98 -0500, you wrote:
>Hello All,
>Database triggers are truly a fabulous thing,  If you're a programmer
>and you haven't looked into triggers, you are doing yourself a
>disservice (Softcopy CD IBM DB2 Database Programming has some good
>sample trigger programs).
>I would like to know what V?R?M? release they became available on the
>AS400?
>Also does anyone know if the trigger concept is just an IBM idea or is
>it a function that's also offered on any manufactured computer system?
>All replies appreciated.

Triggers were not invented on the AS/400.  They existed elsewhere in other
databases (but don't asked me where).  They were added to the AS/400 in
V3R1, when DB2/400 was significantly upgraded to be the most compliant of
any of the DB2 databases to the DB2 standards.

In V3R1, PTF's help a lot with the functionality.  BTW, the minimum release
that ANYONE should be running now-a-days is V3R2 or V3R7.  I'm at V4R2.

Al



Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406





Private mail should be sent to barsa@ibm.net
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---