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