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

Parameter metadata support

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

Parameter metadata support

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 SQL Server driver supports returning parameter metadata as described in this section.

Contents
  • Insert, Update, and Delete statements
  • Select statements
  • Stored procedures
TitleResults for “How to create a CRG?”Also Available inAlert