Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

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;
}
60 Sample ODBC Application