Re: Another trigger question

["Terri Harteau" <tshaw@xxxxxxxxxxxxxxxxxx>]

Hi,
    Until now, I thought DSPOPNQRYF was an IBM utility. It's always been on
our system, and works great! It looks like its a *CMD object in QGPL that I
can't find any source for.  It does perform a CRTDUPOBJ before it displays.
Thanks for the help, I would have never considered this happening.
    I might try to create a source for it. It does come in handy. Maybe I
can make the sort function work again. It no longer worked after we went to
the RISC box.

Terri Harteau
tshaw@felkerbrothers.com
Felker Brothers Corp.
----------------------------------------------------------------------------
--------------------------------------
Whoever said nothing is impossible never tried slamming a revolving door.
----------------------------------------------------------------------------
--------------------------------------
----- Original Message -----
From: Buck Calabro <Buck.Calabro@commsoft.net>
To: Terri Harteau <tshaw@felkerbrothers.com>
Sent: Wednesday, April 11, 2001 9:58 AM
Subject: RE: Another trigger question


> DSPOPNQRYF sounds like a utility you got from somewhere, but I'd bet that
it
> does a CRTDUPOBJ to make a copy of the file in QTEMP.  The duplicate in
> QTEMP will have the same trigger program as the original.  Find the source
> and do a RMVPFTRG from the QTEMP version and you should be all set.  Don't
> forget to monitor for "no trigger on file..."
>
> Buck
>
> > -----Original Message-----
> > From: Terri Harteau
> > Sent: Wednesday, April 11, 2001 10: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
>

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---