DataDirect Connect for ODBC User's Guide and Reference

rc = SQLExecDirect (hstmt, "SELECT first_name, last_name,
ssn, address, city, state, zip FROM emp", SQL_NTS);
// fetchdata
...
rc = SQLExecDirect (hstmt, "UPDATE EMP SET ADDRESS = ?
WHERE first_name = ? and last_name = ? and ssn = ? and
address = ? and city = ? and state = ? and zip = ?",
SQL_NTS);
// fairly complex query