Unix Technical Forum

Calling AIX shell script from a trigger

This is a discussion on Calling AIX shell script from a trigger within the DB2 forums, part of the Database Server Software category; --> Hello: My question is the following: I want to create a trigger that, if row is updated on table, ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 02:07 PM
FM
 
Posts: n/a
Default Calling AIX shell script from a trigger

Hello:

My question is the following:

I want to create a trigger that, if row is updated on table, executes
an AIX Shell Script.
DB2 version: 8.2

Is there a possibility to do this?

Thanks in advance for your help.

Felix

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 02:07 PM
Knut Stolze
 
Posts: n/a
Default Re: Calling AIX shell script from a trigger

FM wrote:

> Hello:
>
> My question is the following:
>
> I want to create a trigger that, if row is updated on table, executes
> an AIX Shell Script.
> DB2 version: 8.2
>
> Is there a possibility to do this?


Yes, you can do that via external routines. Have a look here:
http://tinyurl.com/2b2cqs The function "systemCall" does exactly that.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:27 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com