int OpenDataBase(void)
{
     int i_ret = 0;

     EXEC SQL CONNECT TO test_db;
     if(sqlca.sqlcode == 0){
          i_ret = 1;
     }
     return i_ret;
}

int CloseDataBase(void)
{
 int i_ret = !0;

 EXEC SQL disconnect all;
 if(sqlca.sqlcode == 0){
      i_ret = 0;
 }
  return i_ret;
}

int main()
{
    OpenDataBase();
    CloseDataBase();
}