DataDirect Connect for ODBC User's Guide and Reference

...
rc = SQLSpecialColumns (hstmt, ..... ’emp’, ...);
...
rc = SQLExecDirect (hstmt, "SELECT first_name, last_name,
ssn, address, city, state, zip, ROWID FROM emp",
SQL_NTS);
// fetch data and probably "hide" ROWID from the user
...
rc = SQLExecDirect (hstmt, "UPDATE emp SET address = ?
WHERE ROWID = ?",SQL_NTS);
// fastest access to the data!