Triggers vs stored procedures

[rob@xxxxxxxxx]

I don't think that one is better than the other.  They both have their 
place.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"jt" <jt@xxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
02/25/2004 12:15 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
SQL Result Sets and triggers






Interesting...  This may be a better question for M-L Tech list, but:  Is
there much difference between, and any advantage to, stored procedures vs.
triggers???  And, iirc, I saw a post on this list to the effect that
triggers were a technique that "is no longer in favor", but I don't know 
why
it wouldn't be.

| -----Original Message-----
| [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of CWilt@xxxxxxxxxxxx
| Sent: Wednesday, February 25, 2004 11:20 AM
| Subject: RE: SQL Result Sets
|
|
| Rob,
|
| May be hard to believe, but the standard iSeries DB2 manuals.
|
| I keep PDF versions of:
| SQL Reference
| SQL Programming Concepts
| SQL Programming with Host Languages
|
| and just added the Redbook (mentioned in a post here)
| Stored Procedures, Triggers, and UDF on DB2 UDB for iSeries.
|
| I hit them often for my own questions. Luckily, I have a pretty
| good recall
| for stuff that I simply read on the way to my own answers.
|
| In this case, I remembered seeing  the "dynamic results sets xx"  clause
| during the many times I've looked at stored procedures.  Wasn't a big 
deal
| to open the PDF and copy-paste the example.
|
|
| HTH,
| Charles



_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.