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 for JDBC for Microsoft SQL Server User's Guide Release 6.0.0

Inserting/updating XML data

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 for JDBC for Microsoft SQL Server Driver
    • What's new in this release?
    • Requirements
    • Installing and setting up the driver
    • Data source and driver classes
    • Connection URL examples
    • Data types
      • getTypeInfo
    • Driver specifications
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Tutorials
    • Interactive SQL
    • Tableau
    • DbVisualizer
      • Adding a driver
      • Connecting and executing SQL statements
  • Configuring and connecting
    • Setting the classpath
    • Connecting using the JDBC Driver Manager
      • Passing the connection URL
    • Connecting using data sources
      • How data sources are implemented
      • Creating data sources
        • Example data source
      • Calling a data source in an application
      • Testing a data source connection
    • Authentication
      • User ID/password authentication
      • Access token authentication
      • Microsoft Entra ID authentication
      • Kerberos authentication
        • Kerberos authentication requirements
        • The JAAS login configuration file
        • Constrained delegation
      • NTLM authentication
        • NTLM authentication requirements
        • Configuring NTLM authentication without specifying user credentials (Windows Only)
        • Configuring NTLM authentication by specifying user credentials
    • TLS/SSL encryption
      • Using TLS/SSL with Microsoft SQL Server
      • Configuring TLS/SSL encryption
      • Always Encrypted
        • Enabling Always Encrypted
        • Using keystore providers
        • Caching column encryption keys
        • Enabling parameter metadata discovery
        • Connection string example
      • FIPS (Federal Information Processing Standard)
    • Connecting to named instances
    • Azure Synapse Analytics and Analytics Platform System
    • Support for Microsoft Fabric
    • IP addresses
    • Failover
      • Specifying primary and alternate servers
      • Specifying connection retry
      • Configuring failover with Microsoft Cluster Server
      • Always On Availability Groups
    • Performance considerations
  • Additional features and functionality
    • Returning and inserting/updating XML data
      • Returning XML data
        • Returning XML data as character data
        • Returning XML data as binary data
      • Inserting/updating XML data
        • Inserting/updating XML as character data
        • Inserting/updating XML as binary data
    • DML with results
    • Parameter metadata support
      • Insert, Update, and Delete statements
      • Select statements
      • Stored procedures
    • ResultSet metadata support
    • Snapshot isolation level
    • Scrollable cursors
    • Server-side updatable cursors
    • JTA support: installing stored procedures
    • Distributed transaction cleanup
      • Transaction timeout
      • Explicit transaction cleanup
    • Large object (LOB) support
    • Batch Inserts and Updates
    • Rowset support
    • Auto-generated keys support
    • Null values
    • DataDirect Bulk Load
      • Using a DDBulkLoad object
        • Exporting data to a CSV file
        • Loading data from a ResultSet object
        • Loading data from a CSV file
        • Specifying the bulk load operation
        • Logging
      • CSV files
        • Bulk load configuration file
        • Bulk load configuration file schema
        • Character set conversions
        • External overflow files
        • Discard file
    • Inserts into IDENTITY columns for data replication
  • Connection property descriptions
    • AccessToken
    • AccountingInfo
    • ActiveDirectoryPrincipalID
    • ActiveDirectoryPrincipalSecret
    • AEKeyCacheTTL
    • AEKeystoreClientSecret
    • AEKeystoreLocation
    • AEKeystorePrincipalId
    • AEKeystoreSecret
    • AlternateServers
    • AlwaysReportTriggerResults
    • ApplicationIntent
    • ApplicationName
    • AuthenticationMethod
    • BulkLoadBatchSize
    • BulkLoadOptions
    • CatalogOptions
    • ClientHostName
    • ClientUser
    • CodePageOverride
    • ColumnEncryption
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CryptoProtocolVersion
    • DatabaseName
    • DateTimeInputParameterType
    • DateTimeOutputParameterType
    • DescribeInputParameters
    • DescribeOutputParameters
    • Domain
    • EnableBulkLoad
    • EnableCancelTimeout
    • EnableReplicationUser
    • EncryptionMethod
    • FailoverGranularity
    • FailoverMode
    • FailoverPreconnect
    • FetchTSWTZAsTimestamp
    • FetchTWFSasTime
    • GSSCredential
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • JDBCBehavior
    • LoadBalancing
    • LoginConfigName
    • LoginTimeout
    • LongDataCacheSize
    • MaxPooledStatements
    • MultiSubnetFailover
    • NetAddress
    • PacketSize
    • Password
    • PortNumber
    • ProgramID
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • QueryTimeout
    • RegisterStatementPoolMonitorMBean
    • ResultSetMetaDataOptions
    • SelectMethod
    • ServerName
    • ServicePrincipalName
    • SnapshotSerializable
    • SpyAttributes
    • StringInputParameterType
    • StringOutputParameterType
    • SuppressConnectionWarnings
    • TransactionMode
    • TruncateFractionalSeconds
    • TrustStore
    • TrustStorePassword
    • User
    • UseServerSideUpdatableCursors
    • ValidateServerCertificate
    • XATransactionGroup
    • XMLDescribeType
Table of Contents

Inserting/updating XML data

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: June 5, 2018
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Microsoft SQL Server 6.0
    • Documentation

The driver can insert or update XML data as character or binary data.

Contents
  • Inserting/updating XML as character data
  • Inserting/updating XML as binary data
TitleResults for “How to create a CRG?”Also Available inAlert