RE: Retrieve SQL Trigger Source

["Leibowitz, Larry" <Larry.Leibowitz@xxxxxxxxxxxxxxx>]

Great! Got it (see below)...

 

Now how can I find the program that gets called below: CALL CCSPROD .
ATS_NEW_RECORD

 

I am pretty sure I know which CLP Program it is, but how can I find out
if it's the ATS_NEW_RECORD? 

 

 

CREATE TRIGGER CCSPROD.ATS_NEW_APPL  

      AFTER INSERT ON CCSPROD.CCPYARDI  

      REFERENCING NEW AS NROW  

      FOR EACH ROW  

      MODE DB2SQL  

      BEGIN ATOMIC DECLARE CPERSON CHAR ( 9 ) ; SET "SQLP_L2" . CPERSON
= QSYS2 . CAST ( NROW . HMYPERSON AS CHAR ( 9 ) ) ; CALL CCSPROD .
ATS_NEW_RECORD ( "SQLP_L2" . CPERSON ) ; END  ;

 

 

 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Friday, September 28, 2007 3:16 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Retrieve SQL Trigger Source

 

Short answer, use iNav's Generate SQL feature. 

 

Long answer follows :)

 

Start System i Navigator (aka iNav) and expand the LPAR you want to go
to. 

Expand (Databases)->(LPAR name aka system aka database

name)->(Schemas)->(find library where trigger is; if not there
right-click

on Schemas and click on "Select schemas to display" and add your

library)->(expand that library)->(Triggers)->(right-click on the trigger
of

interest and select "Generate SQL")->(click on Generate)->(you'll see
Run

SQL Script window with the source of the SQL trigger).

 

Elvis

 

RPG & DB2 Summit | Minneapolis | October 1-4

Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The
Ugly

October 16 

2007 System i Fall Technical Conference | Orlando | November 4-7

Celebrating 10-Years of SQL Performance Excellence on IBM System i,
eServer

iSeries and the server affectionately known as the AS/400 

 

-----Original Message-----

Subject: Retrieve SQL Trigger Source

 

How can I retrieve the source for the following object?

 

 

 

Object              Type        Attribute      Text                    

 

ATS_N00001    *PGM        CLE            SQL TRIGGER ATS_NEW_APP