Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect Connect Series for ODBC User's Guide Release 7.1.6

Persisting a Result Set as an XML Data File

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect Connect Series for ODBC
    • What's new in this release?
    • Product Matrix
    • Product Platforms
    • About the Documentation Library
    • Contacting Technical Support
  • Quick Start Connect
    • Configuring and Connecting on Windows
      • Configuring a Data Source
      • Minimum Configuration Requirements (Windows)
      • Testing the Connection
    • Configuring and Connecting on UNIX and Linux
      • Environment Configuration
      • Test Loading the Driver
      • Configuring a Data Source
      • Minimum Configuration Requirements (UNIX/Linux)
      • Testing the Connection
  • Tutorials
    • The Example application
    • Microsoft Excel (Windows only)
  • General Information on Using Connect Drivers
    • About the Product
      • Support for Multiple Environments
    • Environment-Specific Information
      • For Windows Users
        • 32-Bit Drivers
        • 64-Bit Drivers
        • Setup of the Drivers
        • Driver Names
      • For UNIX and Linux Users
        • 32-Bit Drivers
        • 64-Bit Drivers
        • AIX
        • HP-UX 11 aCC
        • Linux
        • Oracle Solaris
        • Setup of the Environment and the Drivers
        • Driver Names
    • Using IP Addresses
    • Binding Parameter Markers
    • Driver Threading Information
    • Version String Information
      • getFileVersionString Function
    • Retrieving Data Type Information
    • Persisting a Result Set as an XML Data File
      • Using the Windows XML Persistence Demo Tool
      • Using the UNIX/Linux XML Persistence Demo Tool
    • Translators
    • Packet logging
  • Advanced Features
    • Using Failover
      • Connection Failover
      • Extended Connection Failover
      • Select Connection Failover
      • Guidelines for Primary and Alternate Servers
      • Using Client Load Balancing
      • Using Connection Retry
      • Summary of Failover-Related Options
        • A Connection String Example
        • An odbc.ini File Example
    • Using Security
      • Authentication
        • Kerberos Authentication
        • NTLM Authentication
        • Summary of Authentication-Related Options
          • Connection String Examples for Configuring Authentication
          • odbc.ini File Examples for Configuring Authentication
      • Data Encryption Across the Network
      • TLS/SSL Encryption
        • Certificates
        • TLS/SSL Server Authentication
          • Designating an OpenSSL Library
        • TLS/SSL Client Authentication
        • Summary of Data Encryption Related Options
          • Connection String Examples for Configuring Data Encryption
          • odbc.ini File Examples for Configuring Data Encryption
        • Generating TLS/SSL certificates using OpenSSL 3.5-compliant algorithms
    • Using DataDirect Connection Pooling
      • Creating a Connection Pool
      • Adding Connections to a Pool
      • Removing Connections from a Pool
      • Handling Dead Connections in a Pool
      • Connection Pool Statistics
      • Summary of Pooling-Related Options
    • Using DataDirect Bulk Load
      • Bulk Export and Load Methods
      • Exporting Data from a Database
      • Bulk Loading to a Database
      • The Bulk Load Configuration File
        • Bulk Load Configuration File Schema
        • Verification of the Bulk Load Configuration File
      • Sample Applications
      • Character Set Conversions
      • External Overflow Files
      • Summary of Related options for DataDirect Bulk Load
    • Using Bulk Load for Batch Inserts
      • Determining the Bulk Load Protocol
      • Summary of Related Options for Bulk Load or Batch Inserts
  • Configuring the Product on UNIX/Linux
    • Environment Variables
      • Library Search Path
      • ODBCINI
      • ODBCINST
      • DD_INSTALLDIR
    • The Test Loading Tool
    • Data Source Configuration Through the System Information (odbc.ini) File
      • Sample Default odbc.ini File
      • Translators
    • The demoodbc Application
    • DSN-less Connections
      • Sample odbcinst.ini File
    • File Data Sources
    • Password Encryption Tool (UNIX/Linux only)
    • UTF-16 Applications on UNIX and Linux
  • Drivers for 32-Bit and 64-Bit Platforms
    • The Progress OpenEdge Wire Protocol Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX odbc.ini File
        • Data Source Configuration through a GUI (OpenEdge)
        • Using a Connection String
        • Using a Logon Dialog Box (OpenEdge)
      • Connection Option Descriptions for OpenEdge Wire Protocol
        • Alternate Servers
        • Connection Retry Count
        • Connection Retry Delay
        • Crypto Protocol Version
        • CryptoLibName
        • Data Source Name
        • Database Name
        • Default Isolation Level
        • Description
        • Enable FIPS
        • Enable Timestamp with Timezone
        • Encryption Method
        • Failover Granularity
        • Failover Mode
        • Failover Preconnect
        • Fetch Array Size
        • Host Name
        • HostName In Certificate
        • IANAAppCodePage
        • Load Balancing
        • Login Timeout
        • OpenSSLConfigFile
        • OpenSSLProviderPath
        • Password
        • Port Number
        • Query Timeout
        • SSLLibName
        • TCP Keep Alive
        • Truststore
        • Truststore Password
        • Use Wide Character Types
        • User ID
        • Validate Server Certificate
      • Performance Considerations
      • Data Types
      • Unicode Support
      • Advanced Features
        • Failover
        • Security
      • Isolation and Lock Levels Supported
      • SQL Grammar Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
    • The Sybase Wire Protocol Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Data Source Configuration through a GUI (Sybase)
        • Using a Connection String
        • Using a Logon Dialog Box (Sybase)
      • Connection Option Descriptions for Sybase Wire Protocol
        • Alternate Servers
        • Application Name
        • Application Using Threads
        • Authentication Method
        • Batch Size
        • Bulk Binary Threshold
        • Bulk Character Threshold
        • Charset
        • Connection Cache Size
        • Connection Pooling
        • Connection Reset
        • Connection Retry Count
        • Connection Retry Delay
        • Crypto Protocol Version
        • CryptoLibName
        • Cursor Positioning for Raiserror
        • Data Source Name
        • Database List
        • Database Name
        • Description
        • Default Buffer Size for Long/LOB Columns (in Kb)
        • Distributed Transaction Model
        • Enable Bulk Load
        • Enable Describe Parameter
        • Enable FIPS
        • Enable Quoted Identifiers
        • Encryption Method
        • Failover Granularity
        • Failover Mode
        • Failover Preconnect
        • Fetch Array Size
        • Fetch TWFS as Time
        • Field Delimiter
        • GSS Client Library
        • HA Failover Server Connection Information/Network Address
        • Host Name In Certificate
        • IANAAppCodePage
        • Initialization String
        • Interfaces File
        • Language
        • Load Balance Timeout
        • Load Balancing
        • Login Timeout
        • Max Pool Size
        • Min Pool Size
        • Network Address
        • OpenSSLConfigFile
        • OpenSSLProviderPath
        • Packet Size
        • Password
        • Prepare Method
        • PRNGSeedFile
        • PRNGSeedSource
        • Query Timeout
        • Record Delimiter
        • Report Codepage Conversion Errors
        • Select Method
        • Server Name
        • Service Principal Name
        • SSLLibName
        • TCP Keep Alive
        • Tightly Coupled Distributed Transactions
        • Truncate Time Type Fractions
        • Truststore
        • Truststore Password
        • User Name
        • Validate Server Certificate
        • Workstation ID
        • XA Open String Parameters
      • Performance Considerations
      • Data Types
      • Unicode Support
      • Advanced Features
        • Failover
        • Security
          • Authentication
        • Connection Pooling
        • DataDirect Bulk Load
          • Bulk Copy Operations and Transactions
          • Limitations
      • Performance Considerations
      • Unexpected Characters
      • MTS Support
      • NULL Values
      • Persisting a Result Set as an XML Data File
      • Isolation and Lock Levels Supported
      • SQL Grammar Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
      • Using Arrays of Parameters
    • The Text Driver
      • Driver Requirements
      • Formats for Text Files
      • Configuring Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Data Source Configuration through a GUI (Text)
      • Using a Connection String
      • Connection Option Descriptions
        • Action for Undefined Tables
        • Allow Update And Delete
        • Application Using Threads
        • Cache Size
        • Century Boundary
        • Column Names in First Line
        • Data File Extension
        • Data Source Name
        • Database Directory
        • Decimal Symbol
        • Default Table Type
        • Delimiter Character
        • Description
        • Extension List
        • File Open Cache
        • IANAAppCodePage
        • Include Files with Matching Extensions
        • International Sort
        • Rows to Scan
        • Use Long Qualifiers
      • Defining Table Structure on Windows
      • Defining Table Structure on UNIX and Linux
      • Example of QETXT.INI
      • Date Masks
      • Data Types
      • Select Statement
      • Alter Table Statement
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
  • Drivers Only Available for 32-Bit Platforms
    • The Btrieve (Pervasive.SQL) Driver
      • Driver Requirements
      • Managing Databases
      • Transactions
      • Configuring and Connecting to Data Sources (Btrieve)
        • Data Source Configuration through a GUI (Btrieve)
          • Using a Connection String
        • Using a Connection String
      • Connection Option Descriptions
        • Action for Undefined Tables
        • Application Using Threads
        • Array Size
        • Data File Extension
        • Data Source Name
        • Database Directory
        • Default Logon ID
        • Description
        • File Open Cache
        • International Sort
        • Password
        • Use Long Qualifiers
      • Defining Table Structure
      • Data Types
      • Indexes
      • Column Names
      • Select Statement
        • Rowid Pseudo-Column
      • Alter Table Statement
      • Create and Drop Index Statements
        • Create Index
        • Drop Index
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
    • The dBASE Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Data Source Configuration through a GUI (dBase)
        • Data Source Configuration through a GUI (FoxPro)
        • Using a Connection String
      • Connection Option Descriptions
        • Application Using Threads
        • Cache Size
        • Create Type [dBASE]
        • Create Type [FoxPro]
        • Data File Extension
        • Data Source Name
        • Database Directory
        • Database Name
        • Description
        • Extension Case
        • File Open Cache
        • IANAAppCodePage
        • International Sort
        • Lock Compatibility
        • Locking
        • Use Long Names
        • Use Long Qualifiers
      • Defining Index Attributes on Windows
      • Defining Index Attributes on UNIX and Linux
      • Data Types
      • Column Names
      • Select Statement
        • Rowid Pseudo-Column
      • Alter Table Statement
      • Create and Drop Index Statements
        • Create Index
        • Drop Index
      • Pack Statement
      • SQL Statements for FoxPro 3.0 Database Containers
      • Locking
        • Levels of Database Locking
        • Limit on Number of Locks
        • How Transactions Affect Record Locks
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
    • The XML Driver
      • Driver Requirements
      • Supported Tabular Formats for XML Documents
      • Hierarchical-Formatted XML Document Support
        • Column Data Types
      • Defining Locations
      • Specifying Table Names in SQL Statements
      • Configuring and Connecting to Data Sources (XML)
        • Data Source Configuration through a GUI (XML)
        • Using a Logon Dialog Box (XML)
        • Using a Connection String
      • Connection Option Descriptions
        • Data Source Name
        • Description
        • Driver Options
        • International Sort Order
        • Location Names
        • Logging
        • Read Only
        • Report Codepage Conversion Errors
        • Schema Mode
        • Show Manufactured Schemas
        • Show Virtual Schemas
          • Configure Location Dialog Box Descriptions
        • Delete Linked Schema
        • Flush Every Change
        • Location
        • Location Name
        • Location Type
        • Max Rows to Scan
        • Password
        • Require User ID/Password
        • Resolve External References
        • Row Hint
        • Table Creation
        • Table Hint
        • User ID
        • Validate Schema
      • Using Hints for Tabular-Formatted XML Documents
        • Column Mode Identifier
      • Data Types
      • Unicode Support
      • Persisting a Result Set as an XML Data File
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
      • SQL Support
        • SQL Statements
        • Extensions to SQL Standards
        • Grammar Token Definitions
          • Regular Identifiers
          • Delimited Identifiers
          • Integer Numbers
          • Real Numbers
          • Character String Literals
          • GUID Literals
          • Hex Literals
          • Time and Date Literals
          • SQL Operators and Symbols
          • Keywords for the XML Driver
          • SQL Comments
  • The Connect XE Drivers
    • The Greenplum Wire Protocol Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Data Source Configuration through a GUI (Greenplum)
        • Using a Connection String
        • Using a Logon Dialog Box (Greenplum)
      • Accessing Greenplum data with Power BI
      • Greenplum Connection Option Descriptions
        • Alternate Servers
        • Application Using Threads
        • Authentication Method
        • Batch Mechanism
        • Connection Pooling
        • Connection Reset
        • Connection Retry Count
        • Connection Retry Delay
        • Crypto Protocol Version
        • CryptoLibName
        • Data Source Name
        • Database Name
        • Description
        • Enable FIPS
        • Enable Keyset Cursors
        • Enable SQLDescribeParam
        • Encryption Method
        • Extended Column MetaData
        • Failover Granularity
        • Failover Mode
        • Failover Preconnect
        • Fetch RefCursors
        • Fetch TSWTZ as Timestamp
        • Fetch TWFS as Time
        • GSS Client Library
        • Host Name
        • Host Name In Certificate
        • IANAAppCodePage
        • Initialization String
        • Keyset Cursor Options
        • Key Password
        • Keystore
        • Keystore Password
        • Load Balance Timeout
        • Load Balancing
        • Login Timeout
        • Max Char Size
        • Max Long Varchar Size
        • Max Pool Size
        • Min Pool Size
        • Max Varchar Size
        • OpenSSLConfigFile
        • OpenSSLProviderPath
        • Password
        • Port Number
        • Query Timeout
        • Report Codepage Conversion Errors
        • Service Principal Name
        • SSLLibName
        • TCP Keep Alive
        • Transaction Error Behavior
        • Truststore
        • Truststore Password
        • User Name
        • Validate Server Certificate
        • Unbounded Numeric Precision
        • Unbounded Numeric Scale
        • User Name
        • XML Describe Type
      • Performance Considerations
      • Data Types
        • Using the XML Data Type
      • Unicode Support
      • Advanced Features
        • Failover
        • Connection Pooling
        • Security
      • User-defined Functions' Results
      • Persisting a Result Set as an XML Data File
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
      • Using Arrays of Parameters
    • The Impala Wire Protocol Driver
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX odbc.ini File
        • Data Source Configuration through a GUI (Impala)
        • Using a Connection String
        • Using a Logon Dialog Box (Impala)
      • Connection Option Descriptions
        • Array Size
        • Authentication Method
        • Batch Mechanism
        • Crypto Protocol Version
        • CryptoLibName
        • Data Source Name
        • Database
        • Default Buffer Size for Long/LOB Columns (in Kb)
        • Default Order By Limit
        • Description
        • Enable FIPS
        • Enable SQLDescribeParam
        • Encryption Method
        • GSS Client Library
        • Host Name
        • Host Name In Certificate
        • Key Password
        • Key Store
        • Keystore Password
        • Login Timeout
        • Max Varchar Size
        • OpenSSLConfigFile
        • OpenSSLProviderPath
        • Password
        • Port Number
        • Proxy User
        • Remove Column Qualifiers
        • Service Principal Name
        • SSLLibName
        • String Describe Type
        • TCP Keep Alive
        • Transaction Mode
        • Trust Store Password
        • Truststore
        • Use Current Schema for Catalog Functions
        • User Name
        • Validate Server Certificate
      • Performance Considerations
      • Data Types
      • Advanced Features
        • Security
          • Apache Sentry
      • Materialized Views
      • Stored Procedures
      • Unicode Support
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Using Arrays of Parameters
      • Limitations on Cloudera Impala Functionality
    • The Driver for the Teradata Database
      • Driver Requirements
      • Configuring and Connecting to Data Sources
        • Data Source Configuration in the UNIX/Linux odbc.ini File
        • Using a Connection String
        • Data Source Configuration through a GUI (Teradata)
        • Using a Logon Dialog Box (Teradata)
      • Connection Option Descriptions
        • Account String
        • Authentication Password
        • Authentication UserId
        • DBCName List
        • DBCName or Alias
        • Default Database
        • Default Role
        • Description
        • Enable Data Encryption
        • Enable Extended Statement Information
        • Enable LOBs
        • Enable Reconnect
        • IANAAppCodePage
        • Integrated Security
        • Login Timeout
        • Map Call Escape To Exec
        • Maximum Response Buffer Size
        • Name
        • Password
        • Port Number
        • ProcedureWithPrintStmt
        • ProcedureWithSPLSource
        • Profile
        • Realm
        • Report Codepage Conversion Errors
        • Security Mechanism
        • Security Parameter
        • Session Character Set
        • Show Selectable Tables
        • TDUserName
        • UserID
      • Data Types
      • Unicode Support
      • Persisting a Result Set as an XML Data File
      • Isolation and Lock Levels Supported
      • SQL Support
      • ODBC Conformance Level
      • Number of Connections and Statements Supported
  • Supported SQL Statements and Extensions
    • SQL Statements for Flat-File Drivers
      • Select Statement
        • Select Clause
          • Aggregate Functions
        • From Clause
        • Where Clause
        • Group By Clause
        • Having Clause
        • Union Operator
        • Order By Clause
        • For Update Clause
        • SQL Expressions
          • Constants
          • Exponential Notation
          • Numeric Operators
          • Character Operators
          • Date Operators
          • Relational Operators
          • Logical Operators
          • Operator Precedence
          • Functions
      • Create and Drop Table Statements
        • Create Table
        • Drop Table
      • Insert Statement
      • Update Statement
      • Delete Statement
      • Reserved Keywords
    • SQL Functionality for the Impala Wire Protocol Driver
      • Data Definition Language (DDL)
      • Selecting Data With the Driver
        • Select List
          • Column Name Qualification
      • From Clause
      • Group By Clause
      • Having Clause
      • Order By Clause
      • For Update Clause
      • Set Operators
      • Subqueries
      • SQL Expressions
        • Constants
        • Numeric Operators
        • Character Operator
        • Relational Operators
        • Logical Operators
        • Functions
      • Restrictions
        • Insert and Update Restrictions
        • Stored Procedures
        • Views
        • Other Restrictions
  • Copyright
Table of Contents

Persisting a Result Set as an XML Data File

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: October 3, 2020
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Cloudera Impala 7.1
    • dBase 7.1
    • Flat files/Text 7.1
    • MySQL 7.1
    • Pervasive (Btrieve) 7.1
    • XML 7.1
    • Documentation

The driver allows you to persist a result as an XML data file with embedded schema. See Persisting a Result Set as an XML Data File for details about implementation.

TitleResults for “How to create a CRG?”Also Available inAlert