Foreign Table Triggers...

markjde

Active Member
I have a foreign table that resides on the Enterprise server which is going
to be populated via an ODBC connection using a process outside of OW. What
I would like to do is launch a UBE in OW to process the new records into OW
tables.

What is the best method for doing this, I realize that if I add a trigger to
the table any records added through the ODBC connection will not result in
the trigger being executed. What other solutions do I have to ensure a real
time result?

Mark Smith

B7332 SP11, Intel NT4, SQL 7.0
markjde@hotmail.com
 

sean_gilbert

Well Known Member
I have heard that the forthcoming XPI for OneWorld will provide agents that can
monitor external tables for changes.

Maybe Microsoft has some type of agent that can monitor SQL7 tables and upon any
adds execute the LaunchUBE command


Sean Gilbert
PricewaterhouseCoopers
1550 Ampère, Suite 401
Boucherville, QC J4B 7L4
Tel: 514.201.5001 x3619
Fax: 450.655.0163


|--------+---------------------------->
| | markjde |
| | <markjde@hotmail.c|
| | om> |
| | Sent by: |
| | owner-jdeowdevml@j|
| | delist.com |
| | |
| | |
| | 01/05/2001 07:10 |
| | PM |
| | Please respond to |
| | jdeowdev |
| | |
|--------+---------------------------->
>----------------------------------------------------------------------------|
| |
| To: jdeowdevml@jdelist.com |
| cc: |
| Subject: Foreign Table Triggers... ~~0:3452 |
>----------------------------------------------------------------------------|




I have a foreign table that resides on the Enterprise server which is going
to be populated via an ODBC connection using a process outside of OW. What
I would like to do is launch a UBE in OW to process the new records into OW
tables.

What is the best method for doing this, I realize that if I add a trigger to
the table any records added through the ODBC connection will not result in
the trigger being executed. What other solutions do I have to ensure a real
time result?

Mark Smith

B7332 SP11, Intel NT4, SQL 7.0
markjde@hotmail.com




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=3452

*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************



----------------------------------------------------------------
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please
contact the sender and delete the material from any computer.
 

aloksahai

Member
Other solution is you can put a Schedule UBE get executed. It will not get trigger when records changed but it will get on specific time.
Alok


______________________________________________________
123India.com - India's Premier Portal
Get your Free Email Account at http://www.123india.com
 

f_blettner

Member
You can use the subsystem UBE to do that.

> -----Message d'origine-----
> De: markjde [SMTP:markjde@hotmail.com]
> Date: samedi 6 janvier 2001 01:10
> À: jdeowdevml@jdelist.com
> Objet: Foreign Table Triggers... ~~0:3452
>
> I have a foreign table that resides on the Enterprise server which is
> going
> to be populated via an ODBC connection using a process outside of OW.
> What
> I would like to do is launch a UBE in OW to process the new records into
> OW
> tables.
>
> What is the best method for doing this, I realize that if I add a trigger
> to
> the table any records added through the ODBC connection will not result in
> the trigger being executed. What other solutions do I have to ensure a
> real
> time result?
>
> Mark Smith
>
> B7332 SP11, Intel NT4, SQL 7.0
> markjde@hotmail.com
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Nu
> mber=3452
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
 
Top