MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2012

Re: Specifing program name when create a SQL trigger on V7R1



fixed

My 7.1 SQL Ref doesn't show a "PROGRAM NAME" clause for the CREATE TRIGGER...

But the online version here does...
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/db2/rbafzhctrigger.htm

Looks like this was/is added with a technical refresh...
https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=en#/wiki/IBM%20i%20Technology%20Updates/page/Support%20PROGRAM%20NAME%20on%20CREATE%20TRIGGER

Perhaps you don't have it?

Charles

On Tue, Oct 30, 2012 at 2:01 PM, Rich Herdman <rherdman@xxxxxxxxx> wrote:
While creating triggers in V7R1 using SQL, I am trying to use the "PROGRAM
NAME" parm listed in the V7R1 SQL Ref book to specify the short name of the
object and I cannot get it to work.


In my simplistic exmaple below:

create trigger trigger_test_1
after insert on trigtestf
for each row mode db2sql
update trigtestf set b = a+1, ts = current_timestamp
where b < 10


It creates a *PGM object named TRIGG00001.

However the CREATE TRIGGER documentation in the SQL Reference guide says

"*PROGRAM NAME **external-program-name*

Specifies the unqualified name of the program to be created for the
trigger. The

name must be the unqualified form of an
*external-program-name*. The qualifier

for the program name will be the same as the implicit or explicit qualifier
for
*

trigger-name
*".

If I am reading that correctly, adding the statement "PROGRAM NAME
TRIGTESTT" should make it create a *PGM object named TRIGTESTT instead of
the system-generated name TRIGG00001. It is not recognizing PROGRAM NAME
as a valid option.

Has anyone gotten this to work, or am I confused? Thanks!

*Rich Herdman*
rherdman@xxxxxxxxx
--
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.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact