SQLPOINTER)SQL_AUTOCOMMIT_ON,

                        SQL_NTS);

if (ret != SQL_SUCCESS)

{

/* handle error */

}

/* allocate a statement handle */

ret = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);

if (ret != SQL_SUCCESS)

{

/* handle error */

}

/* prepare the statement */

ret = SQLPrepare(hstmt, stmt, SQL_NTS);

if (ret != SQL_SUCCESS)

{

/* handle error */

}

/* bind parameter1 to the statement */

ret = SQLBindParameter(hstmt,

                           1,

                           SQL_PARAM_INPUT,

                           SQL_C_UBIGINT,

                           SQL_INT,

                           0,

                           0,

                           &wk_id,

                           0,

                           NULL);

if (ret != SQL_SUCCESS)

{

/* handle error */

}

ret = SQLBindCol(hstmt,

1,

SQL_C_UBIGINT,

&user_id,

0,

4);

/* execute the statement */

ret = SQLExecute(hstmt);

if (ret != SQL_SUCCESS)

{

208 

MySQL to DB2 UDB Conversion Guide