Using database triggers to run OneWorld UBEs

vap

Active Member
Dear List,

I suggest that we collect explanations, on how to start OneWorld UBEs from
database triggers in all three databases that OneWorld runs on, and add this
information to the tips and technique forum. I'm not so sure about how to do
it (I don't have access to forum, just mailing list), so I can't read the
FAQ, but I guess Zoltan will know. Or maybe Eric will read this (a side
question, sorry for asking, but is Eric reading the list, or just
maintaining it? Sorry again for asking, but I really wonder.). I already
have a piece of information to share, which was kindly provided by Franck
BLETTNER (I guess he does not know how to add it to tips forum as well). It
goes after my signature, because I just quote it. Could someone reply with
AS/400 and Oracle samples?

Regards,
Vladimir Ponomarev

!Important Part!
---Extract from original mail by Franck BLETTNER

It's a sample to execute a batch with an SQL server Trigger.

CREATE TRIGGER <name> on CRPDTA.F0101
FOR insert, update, delete AS
exec master..xp_cmdshell 'cd d:\oneworld\ddp\B7332\system\bin32', no_output
exec master..xp_cmdshell 'd:\oneworld\ddp\B7332\system\bin32\runube JDE JDE
CRP733 R014021 XJDE0001 QB7332 "Batch" "Hold" "\\server\printer" ',
no_output
 
If your doing in Oracle you usually write a dameon to monitor a directory
for a file or flag. Then use the trigger to write the file/flag out to the
directory using the UTL_FILE package. When the program picks up the file, it
processes it and removes it.

Regards,
Ethan Post
Oracle DBA
 
If your doing in Oracle you usually write a dameon to monitor a directory
for a file or flag. Then use the trigger to write the file/flag out to the
directory using the UTL_FILE package. When the program picks up the file, it
processes it and removes it.

Regards,
Ethan Post
Oracle DBA
 
Back
Top