Solved

Using a trigger to call ksh script?

Posted on 2007-03-29
4
345 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Find out which object is not saved 2 214
Connect SQL Developer to zO/S DB2 database 6 381
RPG Free Parital key and move replacement 3 132
Modify select statment 10 67
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 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