SQL Triggers

[CENTRINO]

Is it possible to write pure sql triggers for Iseries instead of RPG COBOL
etc.?

what licpgms should be needed?

We are on V5R4M0

Thanks in advance.
--
.

[CRPence]

On 31-Jan-2012 02:08 , CENTRINO wrote:
> Is it possible to write pure sql triggers for Iseries instead of RPG
> COBOL etc.?

At the InfoCenter link below, to get a list of many links to some
documentation, search: SQL CREATE TRIGGER
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp

_i [DB2 UD for iSeries] Triggers i_
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/sqlp/rbafydb2triggers.htm

_i [i5/OS] SQL triggers i_
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/sqlp/rbafysqltrig.htm

_i CREATE TRIGGER i_
"
The CREATE TRIGGER statement defines a trigger at the current server.
Invocation

This statement can be embedded in an application program or issued
interactively. It is an executable statement that can be dynamically
prepared.

...

"

> what licpgms should be needed?
>
> We are on V5R4M0
>

AFaIK, only the OS. Since some prior release, a requirement to have
the product for the C compiler was removed as a requirement to create
SQL routines and triggers; with that, I believe the separate
pre-requisite for the SQL pre-compiler support would also have been
dropped so not even the ST1 [Db2 for i5/OS SQL pre-compiler and
interactive SQL] product is not required. And IIRC, by v5r4, the
RUNSQLSTM script processor was even moved into the OS from the ST1;
there is also the iNav database run SQL scripts, and other means to
perform dynamic SQL statement(s) [e.g. QM, REXX, DB2 CLP in QSHell].

Regards, Chuck