Re: FREE (cursor)

The shared memory that is being used is on the server side. This is the issue with later INET drivers. The default behavior is to NOT free up memory. If you program is not going to hang around very long, then it is not an issue. -d At 12:39 AM 8/19/97 +0000, SaTriGuy wrote: }>Could someone explain the advantages/disadvantages of issuing a CLOSE }>cursor statement and then issuing a FREE cursor statement?. IF the }cursor }>has been prepared, will the FREE statement require it to be prepared }>again? }> }> } }Basically, the Free statement will free up the "entire" query that is in }shared memory. If the same statement is "re-prepared" there is an }implicit free. The biggest advantage --- If the cursor is freed, then all }memory associated with the prepare/declare is freed. If the cursor is }only closed, then the basic parts of the statment hang arround. } }Madison Pruet } }