Re: Informix stored procedure

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