Hi Kishore This is something I've read about but never done.
First, when you say ".. after an insert" it sound like a trigger. Second, "... some [external] task" sound like a user defined function. I've read about those objects in the excellent book by Don Chamberlin. Calling a function from a trigger. Also some disturbing ideas assault me. For example the DB motor waiting for an external task to complete and holding locks on some critical objects while the external task is waiting an operator inervention (Yes / No / Cancel). The operator is out for lunch. Anything you do must be guaranteed to return in a fraction of a secod, or should start an asyncronous task and release DB2. Maybe using MQ. Good luck Juan Lanus TECNOSOL kishore lingamallu wrote: > > > Hi > > Is it possible to kick an executable or a Java program after an > insertion of a record into table? > I heard that it is possible but I don't where can I find material. > Please point me to the location where can I fine the info, if somebody > has implemented please share if you can. > > So the basic idea is to perform some external task after an insert > statements happens on table. Please give me your suggestions. > > Thank You > > Kish > > > > > _________________________________________________________________ > Get your FREE download of MSN Explorer at > http://explorer.msn.com/intl.asp > > > ===== > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > For other info (and scripts), see > http://people.mn.mediaone.net/scottrmcleod > > > ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
