Re: Triggers prevent requested operation

We do the same thing. I use Extractor/400 to bring the files over from
production into a temporary library, but before I copy them back to the
development library from the temporary library, I disable the trigger.
After the copy completes, the trigger is re-enabled:

http://code.midrange.com/index.php?id=847ff25a64

Francis Lapeyre
IS Dept. Programmer/Analyst
Stewart Enterprises, Inc.
E-mail: flapeyre@xxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Captain Jerry
Sent: Tuesday, April 24, 2007 8:13 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Triggers prevent requested operation

*Thanks Jonathan,*
**
*Actually Simon's suggestion is the way I'll have to go, because I don't
want the Trigger to fire for every Delete of a Clear. It happens when
Ops.
does their weekly refresh of the file from Production to Development.
(Actually, now I'm wondering why I need the Triggers on Development at
all?) Still thinking!*
**
*Jerry*


On 4/24/07, Jonathan Mason <jonathan.mason@xxxxxxxxxxxxxxxx> wrote:
>
> Hi Jerry
>
> Alternatively if you want the *DELETE trigger to run for each record
you
> could use SQL to delete every record in the file:
>
> DELETE FROM library/file
>
> Hope it helps
>
> Jonathan
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Captain Jerry
> Sent: 24 April 2007 05:31
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Triggers prevent requested operation
>
> Hmmmm... Thanks Simon.... I'm going to have to think about this.
> Jerry
>
>
> On 4/23/07, Simon Coulter <shc@xxxxxxxxxxxxxxxxx> wrote:
> >
> >
> > On 24/04/2007, at 12:54 PM, Captain Jerry wrote:
> >
> > > I have a Trigger on a file which fires on a Delete Record. All's
> well,
> > > unless I do a Clear Physical File Member (CLRPFM) ~ The Trigger
> > > doesn't like
> > > that.
> >
> > It's not the TRIGGER that doesn't like it--it's the SYSTEM. The
> > presumption is that IF you added a *DELETE trigger then you probably
> > want it to fire for every record deletion. Because CLRPFM does not
> > DELETE records but rather truncates the data space there is no
physical
> > delete operation thus the trigger won't fire. If the trigger isn't
> > fired how can the trigger program perform whatever action you desire
> > when a delete occurs. Nett result is that some operations are not
> > allowed on a file that has a trigger.
> >
> > >
> > > #3 is my problem. How can I get around this? There must be a
trick,
> > > but I
> > > can't find one.
> >
> > You can't CLEAR a file with a *DELETE trigger so do what the message
> > help text tells you and remove the trigger, clear the file, and add
the
> > trigger back again. NOTE: I am not recommending this
practice--simply
> > telling you how you can accomplish it.
> >
> >
> > Regards,
> > Simon Coulter.
> > --------------------------------------------------------------------
> > FlyByNight Software OS/400, i5/OS Technical Specialists
> >
> > http://www.flybynight.com.au/
> > Phone: +61 3 9899 0985 Mobile: +61 0411 091 400 /"\
> > Fax: +61 3 9899 0985 \ /
> > X
> > ASCII Ribbon campaign against HTML E-Mail / \
> > --------------------------------------------------------------------
> >
> >
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L)
mailing
> list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
> >
>
>
> --
> Sci-Fi Movie Survival Tips...
>
> #21 Never mate with an alien, No matter how hot it is.
> #22 If you discover that you can fly, Don't do it in commercial
airspace.
> #23 If you can see bits of flesh caught in it's teeth, You're standing
too
> close.
> #24 If a giant asteroid is heading for Earth, Duck and cover won't
help.
> #25 When building a robot don't give it a brain, And if you do don't
give
> it
> a weapon.
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>


--
Sci-Fi Movie Survival Tips...

#21 Never mate with an alien, No matter how hot it is.
#22 If you discover that you can fly, Don't do it in commercial
airspace.
#23 If you can see bits of flesh caught in it's teeth, You're standing
too
close.
#24 If a giant asteroid is heading for Earth, Duck and cover won't help.
#25 When building a robot don't give it a brain, And if you do don't
give it
a weapon.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.