Hi everyone,
I have programm:
(1) dbcmd(dbproc,"procedure_name");
dbsetopt(dbproc,DBBUFFER,1000);
dbsqlexec(dbproc);
if (dbresults(dbproc) == SUCCEED)
while ((row_code = dbnextrow(dbproc)) != NO_MORE_ROWS)
......
(2) /* using data */
(3) ????????
(4) dbcmd(dbproc,"another_procedure");
dbsetopt(dbproc,DBBUFFER,200);
dbsqlexec(dbproc);
if (dbresults(dbproc) == ....
What to do in point (3) to completly free allocated memory
_before_ it cames to point (4) ?
Is
dbclropt(dbproc,DBBUFFER,"-1");
in point (3) enough?
vmstat (I have SunOS) reports more memory after program finished,
not while it is in point (3).
Przemek