Re: Trigger Information

Thanks Vern.  I found the way <but for the life of me can't remember right
now) PRTTRGPGM is one I used but I think it just listed the trigger names,
there was another one <geez old timers kicking in its only been 4 hrs since
I did it, oh wait we did have an 1.5 hr power outage at home...thats it I
wasn't on a UPS and data did not get saved first  :)

and from my initial galnce at these CLE stuff - it's not any prettier than
the other triggers (RPGLE) ........thats from an "application coding" point
of view not system or its implementationOn 7/18/06, vhamberg@xxxxxxxxxxx <
vhamberg@xxxxxxxxxxx> wrote:

Mark

Birgitta's post explained some of the CLE stuff - CLE is an ILE C program.
These are created by the system when you create an SQL trigger. From chapter
10 of the redbook on stored procedures, triggers, and user defined
functions:
For an SQL Trigger, the program performing the tests and actions is
written using SQL statements.
and
When a trigger is created, SQL creates a temporary source file that will
contain C source code with embedded SQL statements. A program object is then
created using the CRTSQLCI and CRTPGM commands. The SQL options used to
create the program are the options that are in effect at the time the CREATE
TRIGGER statement is executed. The program is created with activation group
ACTGRP(*CALLER).
At V5R1, an Internal C Compiler is shipped with the system. This provides
an internal API-style interface to the C Compiler. The API interface is
shipped with the system in an SQCC component. Each supported parameter of
the API interface has the same function as the V4R5 Native C/400(r) compiler.
The internal compiler allows customers to create SQL Triggers without having
to purchase the C Compiler, even if the user does not have the ILE C product
installed.
HTH
Vern
-------------- Original message --------------
From: "Mark Allen" <scprideandms@xxxxxxxxx>

> Thanks all, got a semi-decent handle on it now except for those pesky
CLE
> SQL triggers......still have not found what the heck they do or where
they
> got created from.....joy joy joy
>
> On 7/18/06, rob@xxxxxxxxx wrote:
> >
> > SELECT * FROM qsys2/systrigger WHERE EVENT_OBJECT_SCHEMA
='YourLibHere'
> >
> > Rob Berendt
> > --
> > Group Dekko Services, LLC
> > Dept 01.073
> > PO Box 2000
> > Dock 108
> > 6928N 400E
> > Kendallville, IN 46755
> > http://www.dekko.com
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.