In article <40u791$n2u@cssun.mathcs.emory.edu> phr@fmsc.com.au (Peter Harris) writes:
>
>Elisa,
>
>Yes SPL is a bit limited, but with a bit of thought you can usually
>achieve what is needed. While you do not have arrays, you can always
>manipulate temporary tables - these do not have to be sized and will
>probably sit in cache: they are not slow.
>
>On 16 Aug 1995, elisa wrote:
>
>> I have a problem about writing SQL Windows program.
>> Because most of work in my program is batch-job, I want to put the batch-job
>> in Informix stored procedure(we use Informix DB in the server site) in
>> order to reduce the network load. But the stored procedure is not allowed to
>> use two dimention array or pointer variables, I even can't complete my program.
>>
If you've got Informix 4GL, write a small SPL that fires up the 4GL
program and runs it.
eg:
SYSTEM "fglgo batchjob"
If you need args, pass them in a string to the SPL then cat it to the command.
eg
SYSTEM "fglgo batchjob " || commandargs clipped
No doubt SPL doesn't support CLIPPED either, but it probably won't matter.
I haven't checked this syntax, but something like this should work.
'Course, you have to have 4GL/ESQL on your server.
Peter Wiley