Running a unix script from an SPR

[tlohan]

Hi,

I've created an SPR that selects objects and values from various tables. If these variables exceed certain thresholds I then need to call a script on my unix box and pass these parameters to it. Currently I'm using the SYSTEM command like below:

SYSTEM "/LOCAL/bin/myscript -a "||objectid||" -b 'This is a bit of text' -c .......

Unfortunately I'm outputting a lot of data in this line and am getting Informix complaining that the call to SYSTEM is greater than 255 characters.

Is there any other way around this?

 

[mberni]

Hi!
Why dont't you split this into two systemcalls?

One to write into a file and the second to read from this file into your script.