MX Release 3.2 (H06.25+, J06.14+)

printf("No Data Fetched!\n");

break;

}

else

{

printf("c1 :: %d\n", value);

}}

st = SQLExecDirect(hstmt1,(SQLCHAR*)"drop table

GGTest",SQL_NTS);

if (st != SQL_SUCCESS)

{

printf("Error in drop table : GGTest\n");

odbc_Error(henv,hdbc1,hstmt1);

}

else

printf("\nTable GGTEST dropped!\n");

st = SQLEndTran(SQL_HANDLE_DBC,(SQLHANDLE)hdbc,SQL_ROLLBACK);

if (hstmt)

SQLFreeStmt(hstmt,SQL_CLOSE);

if (hstmt1)

SQLFreeStmt(hstmt,SQL_CLOSE);

SQLDisconnect(hdbc);

SQLFreeHandle(SQL_HANDLE_DBC, hdbc);

SQLDisconnect(hdbc1);

SQLFreeHandle(SQL_HANDLE_DBC, hdbc1);

SQLDisconnect(hdbc2);

SQLFreeHandle(SQL_HANDLE_DBC, hdbc2);

SQLFreeHandle(SQL_HANDLE_ENV, henv);

return 0;

}

Execution and Testing of Sample ODBC Application 57