Re: FREEing the cursor, etc

In article <34CF5145.6E54@bellsouth.net>, W. H. SMITH <carlson1@bellsouth.net> writes >I saw a message out here somewhere concerning upgrading Informix, >particularly 4GL, where it showed differences between older and newer >versions. > >One of the differences was quite clear when we converted (returning the >correct number of parameters) > >The other recommendation was not so clear (Freeing the cursor / prepared >statement). > >My understanding of 4GL was that the cursor / prepared statements were >FREEd when the cursor was closed. Is there something I'm missing? > >John Carlson >Informix DBA >WH Smith, Inc. I believe this changed in 4.1 / 6.0, now you need to free the cursor and free the prepared statement. I think 4.1 meant you had to free one and that would automatically free the other. In 6.x you must free both of them separately. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care