Re: Stored queries under INFORMIX 4.00 or INFORMIX 4.10

In article <1992Nov4.162232.28445@walter.cray.com> n2976@cray.com writes: >Does anybody know if INFORMIX 4.00 or INFORMIX 4.10 supports stored queries? > >If not what about 5.00? What about any INFORMIX product? > We do not support stored queries (I think what you really want here are stored query plans, no?) What 5.0 brings, though, is stored procedures. This allows you to put your sql into a stored procedure. That query is optimized at procedure create time, and the query plan stored with the procedure. That query plan will be used whenever that procedure is called (it would only be reoptimized if the underlying table's structure should change). This gives you the same basic effect as a stored query plan. It does require that you call the procedure rather than issue the sql statement directly, but procedures can be used just like a statement (e.g. you can declare cursors against them, they can return sets of rows, etc.). Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney