SJavadia
Active Member
List,
We have a table which we would like to put a trigger on. every time a record
is added to this table we would like it to call a OneWorld Master BSFN. we
have tried the RUNUBE from CLP, Then in UBE we call the desired function but
it seems to be very slow in our case, 2 min for 2 records.
We are now trying to Run the BSFN directly by a AS400 DB2 trigger every time
a record is written to the file on AS400. The natural thing to do is use a
OW trigger but we found that the OW trigger is not very reliable and it also
seems that it does not recognise any records written to the file by any
other way than OW (i.e. A CL or RPG programme) so the trigger doesn't
execute.
Has anyone experienced this before? or you may have done something similar
which may help us?
Any help is very much appreciated,
Thanks,
Shahroz.
OW B7332, SP 11.1, NT, AS400 4.4
Shahroz Javadian
OneWorld AP
[email protected]
00 44 1926 318745
----------------------------------------------------------------------------
--------------------------
The contents of this e-mail are confidential and it is intended for the
recipient at the e-mail address to which it has been addressed. This e-mail
may not be disclosed to or used by anyone other than the addressee nor may
it be copied or forwarded to third parties without the express permission of
Calor. Calor disclaim all liability for any statements made by the sender
which do not directly concern the business of Calor and Calor denies any
contracts purported to be concluded on behalf of Calor by means of an e-mail
communication.
Neither Calor nor the sender accepts any responsibility or liability for
viruses and it is the responsibility of the recipient to scan this e-mail
and any attachments to satisfy itself that the e-mail is virus free.
If this e-mail is received in error, please contact Calor
(HTTP:\\www.calorgas.co.uk) on (0)1926 330088 quoting the name of the sender
and the addressee and then both delete it from your system and from your
deleted items folder.
----------------------------------------------------------------------------
--------------------------
We have a table which we would like to put a trigger on. every time a record
is added to this table we would like it to call a OneWorld Master BSFN. we
have tried the RUNUBE from CLP, Then in UBE we call the desired function but
it seems to be very slow in our case, 2 min for 2 records.
We are now trying to Run the BSFN directly by a AS400 DB2 trigger every time
a record is written to the file on AS400. The natural thing to do is use a
OW trigger but we found that the OW trigger is not very reliable and it also
seems that it does not recognise any records written to the file by any
other way than OW (i.e. A CL or RPG programme) so the trigger doesn't
execute.
Has anyone experienced this before? or you may have done something similar
which may help us?
Any help is very much appreciated,
Thanks,
Shahroz.
OW B7332, SP 11.1, NT, AS400 4.4
Shahroz Javadian
OneWorld AP
[email protected]
00 44 1926 318745
----------------------------------------------------------------------------
--------------------------
The contents of this e-mail are confidential and it is intended for the
recipient at the e-mail address to which it has been addressed. This e-mail
may not be disclosed to or used by anyone other than the addressee nor may
it be copied or forwarded to third parties without the express permission of
Calor. Calor disclaim all liability for any statements made by the sender
which do not directly concern the business of Calor and Calor denies any
contracts purported to be concluded on behalf of Calor by means of an e-mail
communication.
Neither Calor nor the sender accepts any responsibility or liability for
viruses and it is the responsibility of the recipient to scan this e-mail
and any attachments to satisfy itself that the e-mail is virus free.
If this e-mail is received in error, please contact Calor
(HTTP:\\www.calorgas.co.uk) on (0)1926 330088 quoting the name of the sender
and the addressee and then both delete it from your system and from your
deleted items folder.
----------------------------------------------------------------------------
--------------------------