USER MANUALS

Data Source Configuration Properties

The configuration properties of a JDBC or an ODBC data source, also called source configuration, specify certain characteristics of the underlying source such as the operations they support.

The Execution Engine uses this information to know which operations are supported by the source, in order to push down to the data source as much processing as possible to optimize response times and minimize traffic through the network.

Note

Usually, users do not need to change these settings since Virtual DataPort automatically uses suitable configurations for most common data sources.

You can define them in the “Source configuration” tab of the data source or by adding them to the statement CREATE DATASOURCE.

The table below lists the properties you can configure in the SOURCECONFIGURATION clause of the data sources. On the left column, you have the name of each property; on the right column, the label of this property in the administration tool, in the tab “Source configuration” of the data source. To find the meaning of a property, go to the section Data Source Configuration Properties of the Administration Guide.

Properties of the SOURCECONFIGURATION clause of data sources

Property Name in SOURCECONFIGURATION Clause

Property Name in the Administration Tool (Source configuration tab)

ALLOWFORUPDATE

Allow for UPDATE clause

ALLOWLITERALASPARAMETER

Allow literal as parameter

DELEGATEAGGREGATEFUNCTIONS

Delegate aggregate functions list

DELEGATEALLOPERATORS

Delegate all operators

DELEGATEANALYTICFUNCTIONSLIST

Delegate analytic functions list

DELEGATEARRAYLITERAL

Delegate array literal

DELEGATE_BINARY_ORDERBY_COLLATION

Delegate binary ORDER BY collation

DELEGATECOMPOUNDFIELDPROJECTION

Delegate compound field projection

DELEGATEFETCH

Delegate FETCH clause

DELEGATEGROUPBY

Delegate GROUP BY clause

DELEGATEHAVING

Delegate HAVING clause

DELEGATEINNERJOIN

Delegate INNER JOIN

DELEGATEINTERSECTION

Delegate INTERSECT

DELEGATEINVALIDNUMBERLITERALSASNULL

Delegate invalid number literals as NULL

DELEGATEJOIN

Delegate JOIN

DELEGATELEFTFUNCTION

Delegate left function

DELEGATELEFTLITERAL

Delegate left literal

DELEGATELITERALEXPRESSION

Delegate literal expression

DELEGATEMINUS

Delegate MINUS

DELEGATEMIXEDAGGREGATEEXPRESSION

Delegate mixed literal expression

DELEGATENATURALOUTERJOIN

Delegate natural OUTER JOIN

DELEGATENOTCONDITION

Delegate NOT condition

DELEGATEOFFSET

Delegate OFFSET clause

DELEGATE_OFFSET_RESTRICTION

Delegate OFFSET clause restriction

DELEGATEOPERATORSLIST

Delegate operators list

DELEGATEORCONDITION

Delegate OR condition

DELEGATEORDERBY

Delegate ORDER BY

DELEGATE_ORDERBY_COLLATION_MODIFIER

Delegate ORDER BY collation modifier

DELEGATEPROJECTION

Delegate projection

DELEGATEREGISTERLITERAL

Delegate register literal

DELEGATERIGHTFIELD

Delegate right field

DELEGATERIGHTFUNCTION

Delegate right function

DELEGATERIGHTLITERAL

Delegate right literal

DELEGATESCALARFUNCTIONS

Delegate scalar functions list

DELEGATESELECTDISTINCT

Delegate SELECT DISTINCT

DELEGATESELECTION

Delegate selection

DELEGATESUBQUERY

Delegate subquery

DELEGATEUNION

Delegate UNION

NESTEDJOINWITHBLOCKSSTRATEGY

Nested join optimization syntax

SUPPORTSAGGREGATEFUNCTIONSOPTIONS

Supports modifier in aggregate function

SUPPORTSBATCHINSERT

Supports batch inserts

SUPPORTSBRANCHOUTERJOIN

Supports branch OUTER JOIN

SUPPORTSCLOBINBATCH

Supports CLOBs in batch inserts

SUPPORTSEQOUTERJOINOPERATOR

Supports Eq OUTER JOIN

SUPPORTSEXPLICITCROSSJOIN

Supports explicit CROSS JOIN

SUPPORTSFULLEQOUTERJOIN

Supports full Eq OUTER JOIN

SUPPORTSFULLNOTEQOUTERJOIN

Supports full NotEq OUTER JOIN

SUPPORTSFUSINGINUSINGANDNATURALJOIN

Supports fusing in USING and natural JOIN

SUPPORTSGROUPBYLITERALASPARAMETER

Supports GROUP BY literals as parameters

SUPPORTSJOINONCONDITION

Supports JOIN ON Condition

SUPPORTSNATURALJOIN

Supports NATURAL JOIN

SUPPORTS_ORDERBY_BINARY_COLLATION

Supports binary ORDER BY collation

SUPPORTSORDERBYEXPRESSION

Supports ORDER BY expressions

SUPPORTSRIGHTDEEPJOIN

Supports right deep n-joins

SUPPORTSPREPAREDSTATEMENT

Supports prepared statements

SUPPORTSUSINGJOIN

Supports USING JOIN
Example: command to change the “source configuration” of a JDBC data source
ALTER DATASOURCE JDBC ds_jdbc_athenda_prod
SOURCECONFIGURATION (
      SUPPORTSORDERBYEXPRESSION = false
    , DELEGATENATURALOUTERJOIN = false);