Re: Running scripts within SQL

Hi,

not knowing oracle and their "@", I'm not sure what
exactly you are trying to achieve ...:

- running a shell script locally (on client machine)?:

Depends on the client you use as it is interpreting
the SQL. E.g. with dbaccess you can use the '!', like
in the following 3-line SQL script "hello.sql":

select name from sysdatabases;
! echo "Hello, world\!"
select name from sysdatabases;

which you then run with the command:

dbaccess sysmaster hello.sql

- running a shell script on the server machine?:

I think you can do that by using a stored procedure
and the "system ..." command.
Of course the shell script must be present on the
server machine.

Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management

IBM Deutschland GmbH
Chairman of the Supervisory Board: Hans Ulrich Märki
Board of Management: Martin Jetter (Chairman), Rudolf Bauer, Christian
Diedrich, Christoph Grandpierre, Matthias Hartmann, Thomas Fell, Michael
Diemer
Corporate Seat: Stuttgart, Germany; Reg.-Gericht: Amtsgericht Stuttgart,
HRB-Nr.: 14 562 WEEE-Reg.-Nr. DE 99369940

informix-list-bounces@xxxxxxxx wrote on 23.10.2007 15:04:31:

Hello all,

Quick question for you here,

If I am running a piece of SQL, is it possible to run a script from
within the SQL.....in oracle I know you would use the "@" so what
would you use in Informix?

Thanks in advance.

Cheers,

Howard

_______________________________________________
Informix-list mailing list
Informix-list@xxxxxxxx
http://www.iiug.org/mailman/listinfo/informix-list

.

Relevant Pages

  • Completely Daft Question
    ... I have written and applicaiton in VB (yuck but that's what the client ... wants) and part of the application involves importing and processing ... For that I turned to php;-) for all its processing power as a shell script. ...
    (php.general)
  • Chmod from Runtime.Exec
    ... I have a interesting situation where I'm trying to run a shell script ... test.sh from my web application (I have already informed my client of ... I'm trying to do a simple chmod 777 before I try to execute the shell ...
    (comp.lang.java.programmer)
  • Re: Windows/Linux Script question
    ... > I'd like to know if the following scenario is possible: ... > Create a shell script on a Linux PC which accepts arguments which will ... One for server and one for client. ...
    (comp.os.linux.questions)
  • writer essentially submits Blanches ending
    ... Informix working to convert a large Sybase app, ... to write a shell script that scrambles the names ... Why is transfer of Salomon proprietary source to a vendor's site the last ... [snip of 247 lines] ...
    (sci.med.cardiology)
  • aim slides Youssef Mohammed al-Durahs objection
    ... Informix working to convert a large Sybase app, ... to write a shell script that scrambles the names ... Why is transfer of Salomon proprietary source to a vendor's site the last ...
    (rec.music.classical.recordings)