Solved

Using a trigger to call ksh script?

Posted on 2007-03-29
4
337 Views
Last Modified: 2008-02-01
Is there an easy way for to have a trigger call a unix ksh script?  I'd like this to happen when new data is "insert"ed in my table.  (Happens once in a blue moon...)
0
Comment
Question by:bganoush
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 500 total points
ID: 18819542
which version of udb?

not unless you write the trigger in a language liek c or java and can invoke the script that way...

what does the ksh script do?
0
 

Author Comment

by:bganoush
ID: 18819557

It calls a C program...

but nevermind I found another solution on here where I can use "xp_cmdshell" to run the script... that works too...

0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 18819672
? XP_CMDSHELL IN db2!
0
 

Author Comment

by:bganoush
ID: 18824289

Welll... that's what people are telling me.... ARRRGHH!!!
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
db2 connect on mac 3 525
iSeries DB2 - Query with Sub Query? 7 108
iBM i DB2 Administration Training 6 103
finding tables 2 38
November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question