DBLibrary: DBBUFFER

DBLibrary: DBBUFFER

Post by Rafal Maj » Sun, 18 Aug 1996 04:00:00



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

 
 
 

1. DBLibrary: DBBUFFER

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

2. home made security sql problem.

3. DB-Lib: DBBUFFER

4. Backup Process is Ingres

5. Looking for DBLibrary function

6. Remote DataBase Update - Best Way

7. dblibrary help: dbsqlexec...

8. systypes, user data types

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