DBLibrary: DBBUFFER

DBLibrary: DBBUFFER

Post by Rafal Maj » Sat, 03 Aug 1996 04:00:00



Hi,

I have programm:

(1) dbfcmd(dbproc, "procedure_name");
    dbsetopt(dbproc,DBBUFFER,10);
    dbsqlexec(dbproc);
    if (dbresults(dbproc) == SUCCEED)
      while ((row_code = dbnextrow(dbproc)) != NO_MORE_ROWS)
        ;

(2) /* .
       .
      using data
       .
       .
    */

(3)

(4) dbfcmd(dbproc,"another_procedure");
    dbsetopt(dbproc,DBBUFFER,200);
    dbsqlexec(dbproc);
    if(dbresults(dbproc)== ......

What to do in point (3) to completly free allocated memory
_before_ I came to point (4) ?

Is
  dbclropt(dbproc,DBBUFFER, "-1");
enough?
I use Sybase 4.*

Przemek

 
 
 

1. DBLibrary: DBBUFFER

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

2. Is this a bug in ADO?

3. DB-Lib: DBBUFFER

4. creating a large datatype (over 8000 characters)

5. Looking for DBLibrary function

6. Job Announcement (Richmond, VA)

7. dblibrary help: dbsqlexec...

8. Indexing for SQL complient Views on Unidata v4

9. dblibrary for c: DBSQLEXEC won't wait....

10. I have problems to connect SQLServer2k with DbLibrary

11. HELP NEEDED FOR RETRIEVAL OF DECIMAL VALUES USING DBLIBRARY