DataDirect Connect for ODBC User's Guide and Reference

SQLSetStmtAttr (hstmt, SQL_ATTR_CURSOR_TYPE,
SQL_CURSOR_STATIC, SQL_IS_INTEGER)
Driver only supports XML persistence when using
driver’s static cursors.
SQLExecDirect (hstmt, "SELECT * FROM GTABLE", SQL_NTS)
SQLSetStmtAttr (hstmt, SQL_PERSIST_AS_XML,
"C:\temp\GTABLE.XML", SQL_NTS)