Below is why I think it is a bad idea:
For an interactive update, if you happen to need to create a new
application to update multi rows in this file and the trigger's input
value are always the same for this new multi row update application, it
would be bad for trigger to request user to enter the same info over and
over again. Of course, this a just me trying to predict future.
For a batch update, I see two choices for you. One is error out by
sending escape message from the trigger. But the trigger has already
updated the file, so this option is not quite right. The other option
is to have trigger sends a inquiry message to the user and get the input
info that way. The problem with this option is that how do you handle
batch update that done thru ODBC/JDBC (Which is a batch program. But
could be a interactive java program that fire the ODBC request)? Also,
do you really want to stop the batch job every time it updates this
file?
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jones Simon
Sent: Thursday, June 12, 2008 9: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 by
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
Volvo Information Technology is a Division of Volvo Group UK Limited,
Registered in England No: 2190944, Registered office: Wedgnock Lane,
Warwick, CV34 5YA The information in this email and in any attachments
is confidential and may be privileged. If you are not the intended
recipient, please destroy this message, delete any copies held on your
systems and notify the sender immediately. You should not retain, copy
or use this email for any purpose, nor disclose all or any part of its
contents to any other person.
--
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.
midrange.com
