Re: Trigger Information

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® 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.