unix script from a stored procedure

Computing.Net > Forums > Unix > unix script from a stored procedure

unix script from a stored procedure

Original Message

Name: Jernand
Date: December 1, 2004 at 08:44:23 Pacific
Subject: unix script from a stored procedure
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,
Jern

Report Offensive Message For Removal

Response Number 1

Name: WilliamRobertson
Date: December 6, 2004 at 05:42:16 Pacific

Reply: (edit)

Stored where?

Report Offensive Follow Up For Removal

Response Number 2

Name: Jernand
Date: December 10, 2004 at 09:23:03 Pacific

Reply: (edit)

Hi,
stored on the same unix server.
Regards,
Jern

Report Offensive Follow Up For Removal

Response Number 3

Name: nails
Date: December 10, 2004 at 13:36:23 Pacific

Reply: (edit)

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()
system("/path/to/any/executable");
END PROCEDURE;
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

Report Offensive Follow Up For Removal

Response Number 4

Name: Jernand
Date: December 13, 2004 at 15:57:10 Pacific

Reply: (edit)

Thanks a lot Nail..I appreciate it.
Regards,
Jern

Report Offensive Follow Up For Removal

Response Number 5

Name: WilliamRobertson
Date: December 17, 2004 at 16:30:03 Pacific

Reply: (edit)

> Stored where?
> stored on the same unix server.
LOL
Serves me right. I should have asked "Stored in what?"

Report Offensive Follow Up For Removal


Run a Unix Script from VB or ASP How to call unix script from pl/sql Executing Oracle stored procedures from calling a script from pl/sql shell script	help redoing unix script student db Compile stored procedures How do you delete SCO UNIX from a harddisk How can I read unix tapes from windows DOS script from UNIX

Response Number 6

Name: Jernand
Date: January 10, 2005 at 12:02:35 Pacific

Reply: (edit)

stored on a file.
Regards,
Jern

Report Offensive Follow Up For Removal

freebsd pcmcia modem card

How to use 'sed' on windo...

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: unix script from a stored procedure

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Have you ever used OpenOffice?

Poll Finishes In 6 Days.
Discuss in The Lounge

backup question

novell hacking

DualMonitor Only Works In Safe Mode

cannot install win xp home

Microsoft Outlook problem

All Posts Awaiting Replies