RE: Trigger question -- MIDRANGE-L

You could test if you are in batch or interactive before calling your interactive programs.

RTVJOBA TYPE(&INTERACTIV) /* when var is '1' it is interactive else it is batch /**/

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Jones Simon
Sent: Thursday, June 12, 2008 11:22 AM
To: Midrange Systems Technical Discussion
Subject: RE: Trigger question

Yes, I thought it would be a bad idea,

The only reason I'm looking at it this way is that it is a process which
needs to run whenever a certain field is changed - only one field, but
changed in a lot of places. The alternative (unless anyone has any
better ideas) is a change to quite a few programs, which I was hoping to
avoid but had a feeling that I wouldn't be able to...

Thanks for the reply though, I shall not be investigating the trigger
option any further on this one!

Simon

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Wilt, Charles
Sent: 12 June 2008 16:09
To: Midrange Systems Technical Discussion
Subject: RE: Trigger question

This is a _very_ bad idea.

Besides the fact that a trigger program could be fire within a batch
job, the real problem is that the
trigger program in invoked by the DB code deep in the OS. I doubt that
you'd even be able to call a
program that uses a display file even when the trigger is fired in an
interactive job.

Even if you could...I'd strongly advise against it. That's just not the
way triggers are designed to
work.

How did you plan to handle the need for additional info when the job is
batch?

Charles Wilt
--
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Jones Simon
Sent: Thursday, June 12, 2008 10:47 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Trigger question

Hello all,

I have a trigger program which calls after an update to a database

file,

that works fine.

A requirement has come up where some of the processing which is done

the trigger program will need some user input by way of an interactive
screen. Instead of adding this screen to the trigger program I was
looking at adding a call to a new program from the trigger program.

I'm

trying to work out if this will cause any problems - the trigger

program

will be active for the duration of the time that the screen is

displayed

and processed.

The obvious problem I've though of is the danger of trying to open the
display file in a batch job, but we can cater for this. But what I

cant

work out is if this call to an intractive program will cause any

issues

within the trigger program.

My initial thoughts are that this is likely to be a bad idea, but I'm
not really sure why!

Hopefully I've made that clear

Simon