#define INCL_BASE
   #define DBMSOS2
   #include <os2.h>
   #include <stdio.h>
   #include <sqlfront.h>
   #include <sqldb.h>

   DBPROCESS *dbproc;
   int msg_handler();
   int err_handler();
   static int timeout=FALSE;

   main()
   {
   LOGINREC  *login;

        login = dblogin();
        DBSETLUSER(login,"sa");
        dbproc = dbopen(login, "server");
        dbmsghandle(msg_handler);
        dberrhandle(err_handler);
        dbsettime(5);

        dbcmd(dbproc,"select command from sqlhelp");
        dbsqlexec(dbproc);
        timeout_processing();
        while( dbresults(dbproc) != NO_MORE_RESULTS )
        {
          while( dbnextrow(dbproc) != NO_MORE_ROWS )
          {
            .
            .
            .
          }
        }
   }
   int msg_handler(dbproc, msgno, msgstate, severity, msgtext)
   DBPROCESS   *dbproc;
   DBINT       msgno;
   int         msgstate;
   int         severity;
   char        *msgtext;
   {
       printf("SQL Server Message %ld, state %d, severity %d:\n%s\n",
               msgno, msgstate, severity, msgtext );
       return(DBNOSAVE);
   }
   int err_handler(dbproc, severity, dberr, oserr, dberrstr,
                   oserrstr)
   DBPROCESS   *dbproc;
   int         severity;
   int         dberr;
   int         oserr;
   char        *dberrstr;
   char        *oserrstr;
   {
       if( dberr==SQLETIME )      <--- test for timeout condition
         timeout=TRUE;
       else
       {          printf("DB-LIB Error %d,\n%s\n",dberr,dberrstr);
         if( oserr>0 )
           printf("OS Error %d,\n%s\n",oserr,oserrstr);
       }
       return(INT_CANCEL);
   }