RE: Another trigger question

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

I'm not aware of the DSPOPNQRYF command but from your description it sounds like it is doing a CRTDUPOBJ on the file to QTEMP.  When this is done the new object in QTEMP will also have the trigger attached.  It also appears that the command is doing a CLRPFM on the file in QTEMP, you are not allowed to do that on a file with a *delete trigger.  The DSPOPNQRY file command needs to do a RMVPFTRG on the file in QTEMP after the CRTDUPOBJ in order to work correctly.  You need to talk to whoever created this command.

 

Scott Mildenberger

-----Original Message-----
From: Terri Harteau [mailto:tshaw@felkerbrothers.com]
Sent: Wednesday, April 11, 2001 8:35 AM
To: RPG400-L@midrange.com
Subject: Another trigger question

Hi,

 

    Thanks for all the help on triggers. I got it doing pretty much what I want, without changing our packaged programs! One thing I noticed though, is I can no longer do DSPOPNQRYF on the file. When I set up the trigger, I specified our data library and add, change, and delete for the event. When I do DSPOPNQRYF, I get an error that it cannot clear my file in QTEMP.  Isn't the trigger specific to the library I specified? Why is it halting on QTEMP? I can still do interactive SQL, so I have a workaround, I'm just more used to using query.  Thanks for any help you can give me.

 

Terri Harteau
tshaw@felkerbrothers.com
Felker Brothers Corp.
------------------------------------------------------------------------------------------------------------------
Whoever said nothing is impossible never tried slamming a revolving door.
------------------------------------------------------------------------------------------------------------------