Computer Problems? Computing.Net has over
1,000,000 posts about all things technology related! Over 90% answered within 24 hours!
Click here to start participating now! Also, be sure to check out the
New User Guide .
unix script from a stored procedure
Name: Jernand
Date: December 1, 2004 at 08:44:23 Pacific
OS: hp-ux
CPU/Ram: 320
Comment: Hi,
I wud like to execute a unix script from a stored procedure at some step. please advise on how to do this.
thanks for your help.
Regards,
Sponsored Link
Response Number 1 Response Number 2
Name: Jernand
Date: December 10, 2004 at 09:23:03 Pacific
Reply: Hi,
stored on the same unix server.
Regards,
0
Response Number 3
Name: nails
Date: December 10, 2004 at 13:36:23 Pacific
Reply: Jern:
Are you asking how you call a shell script from an Informix Stored Procedure? (I know you've asked Informix questions before)
If you are, here's an example SP:
CREATE PROCDURE my_sp()
Here's two things to keep in mind:
1) You can call any executable, not just a shell script. Make sure your script has the PATH variable or any other required environmental variable set.
2) The Informix SP language is braindead. You can't return and data from the called script.
Regards,
Nails
0
Response Number 4
Name: Jernand
Date: December 13, 2004 at 15:57:10 Pacific
Reply: Thanks a lot Nail..I appreciate it.
Regards,
0
Response Number 5
Reply: > Stored where?
> stored on the same unix server.
LOL
Serves me right. I should have asked "Stored in what?"
0
Related Posts
Response Number 6
Name: Jernand
Date: January 10, 2005 at 12:02:35 Pacific
Reply: stored on a file.
Regards,
0
Sponsored Link
Post Locked
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
Go to Unix Forum Home
Sponsored links
Results for: unix script from a stored procedure
Run a Unix Script from VB or ASP Summary : Hi there, could I run a Unix Script from VB or ASP page ??? Thanks in advanced !!! ... www.computing.net/answers/unix/run-a-unix-script-from-vb-or-asp-/4384.html
How to call unix script from pl/sql Summary : Can any one guide me how to call unix shell scripts from pl/sql procedures. ... www.computing.net/answers/unix/how-to-call-unix-script-from-plsql/7767.html
Executing Oracle stored procedures from Summary : I have a situation where I want to execute three Oracle stored procedures in parallel from a UNIX script. From my current testing I can't execute the stored procedure in parallel - only in sequence. I... www.computing.net/answers/unix/executing-oracle-stored-procedures-from-/2342.html
From the Geek Dictionary Bye - FTP command to exit the programSee More
0 
