Part 1: Getting Started : Using The Product : Persisting a Result Set as an XML Data File

Persisting a Result Set as an XML Data File
The DataDirect Connect Series for ODBC drivers allow you to persist a result set as an XML data file with embedded schema. To implement XML persistence, a client application must do the following:
1.
SQLSetStmtAttr (hstmt, SQL_ATTR_CURSOR_TYPE, SQL_CURSOR_STATIC, SQL_IS_INTEGER)
A result set can be persisted as an XML data file only if the result set is generated using STATIC cursors. Otherwise, the following error is returned:
Driver only supports XML persistence when using driver’s static cursors.
2.
SQLExecDirect (hstmt, "SELECT * FROM GTABLE", SQL_NTS)
3.
SQLSetStmtAttr (hstmt, SQL_PERSIST_AS_XML, "C:\temp\GTABLE.XML", SQL_NTS)
A statement attribute is available to support XML persistence, SQL_PERSIST_AS_XML. A client application must call SQLSetStmtAttr with this attribute as an argument. See the following table for the definition of valid arguments for SQLSetStmtAttr.
A client application can choose to persist the data at any time that the statement is in an executed or cursor-positioned state. At any other time, the driver returns the following message:
Function Sequence Error
Using the Windows XML Persistence Demo Tool
Using the UNIX/Linux XML Persistence Demo Tool

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.