Re: Dynamic SQL and Informix Online

Jonathan Leffler wrote: > Tim Friest wrote: > > > > I need to do a bunch of dynamic sql procedures... In the section > > on the prepare statement in the Informix Guide to SQL Syntax book > > there is a paragraph which states: > > <snip> > > > > What kind of memory is this? Is this memory used by the Online > > process, or space in the database, or...? > > Some is memory in the OnLine engine itself, and it will probably come > out of the shared memory budget. Some is memory in your program. > > > Is it swappable? > > Your program memory is swappable. The shared memory is probably > swappable, but it may depend on whether you've set the forced > residency flag on the shared memory. > > > How can I tell if I'm running low? > > Things stop working with out of memory errors? I would prefer to know before things stop working ;-) > > My program needs to create a bunch of dynamic functions and leave > > them around since they will be used repeatedly. > > What do you mean by dynamic functions? I meant that I could just prepare the procedures and keep them around,executing them when I needed them... > > The only other way I can think of to do this is to dynamically > > generate create procedure statements and run them... Is this a > > better solution? > > Well, at least I understand this solution and it will work, provided > that the software is resilient enough to handle multiple processes > all creating (and, presumably, destroying) the procedures, or is > coded to ensure that the procedures are not destroyed when they are > still in use. Until I know what you mean by dynamic functions, I > can't tell you whether this is the best method or not. > These procedures would only be used by my program, so that isn't a problem... I this will be the best solution, I'll just have to keep track of their names and parameters... -- Timothy Friest - Science Application International Corp (SAIC) Anchorage Alaska 907-272-7105