Re: Stored Procedures

["Chanh Le" <Chanh_Le@xxxxxxxxxxxxxxx>]

Wrote:
<I can't tell you how many times I've been told that you could use Java for
SP's
and triggers.  That was one of the primary deciding points to our selection
of
an AS/400.  The scariest part of the whole thing was finding out how many
AS/400
developers and sales people at IBM (and everywhere else) don't know what a
stored proc or trigger is.>

Following is my personal opinion not from my company.
(it might not be correct)

I guess AS/400 is a database machine, therefore, all programs on AS/400 are
stored procedures.  So AS/400 community simply call them as "programs"
because there no other type of program.  Instead of storing applications in
an application sever (a shared drived) and "stored procedures" on a
database server (another shared drive).   Everything is stored in one place
- AS/400.

For programs attached to table called as triggers, it seems not widely
accepted.  I think it does not work correctly for mass I/O.   And for big
tables shared by multiple departments, triggers will impact the perfommence
of machine.  Finally, because of the static process of triggers, a table is
no longer flexible for maintenance, unless maintaining it in weekend when
no application running - dropping, modifying table, and put it back.
Triggers would be perfect for personal or very small group database.




+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---