Re: Informix stored procedure

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. As for pointer variables (or lack of), I do not wish do seem flippant but think of it as a positive; you do not have any pointers that can vanish into black holes. A missused pointer is a very destructive thing. There are an awful lot of people using 4gl applications out there, and 4gl does not have pointers. Regards Pete. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ Pete Harris Financial Market Software Consultants~ ~ phr@fmsc.com.au 109 Pitt St Sydney NSW 2000 ~ ~ Australia ~ ~ ~ ~ Disclaimers Apply ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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. > > Is anyone there can help me to solve the problem. THANX! > > Elisa >