analytics/configuration/xqe/ca_idms.properties

# Licensed Materials - Property of IBM
# IBM Cognos Products: OQP
# (C) Copyright IBM Corp. 2005, 2018
# US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM corp.

# This properties file contains default configuration attributes for all
# relational data sources.  Any data source that is different must override
# the value in their own properties file.
#
# The #define values in comments are the values used by UDA to initialize
# their dbInfo data structure.  We are using this as a starting point for
# the XQE default values.  At some point these can be removed from this file.
#


# 
# Delimiters
# 
delimiters.commentBegin=
delimiters.commentEnd=
# delimiters.catalogDelimiter=
# delimiters.schemaDelimiter=
# delimiters.tableDelimiter=
# delimiters.columnDelimiter=
# delimiters.identifierQuoteString=
# delimiters.searchStringEscape=
# delimiters.catalogSeparator=

# 
# Keywords
# 
keywords.columnAlias=AS

# 
# Limits
# 
# Normally these values would be derived from the JDBC driver DatabaseMetadata
# limits.maxBinaryLiteralLength=
# limits.maxCharLiteralLength=
# limits.maxColumnNameLength=
# limits.maxColumnsInGroupBy=
# limits.maxColumnsInIndex=
# limits.maxColumnsInOrderBy=
# limits.maxColumnsInSelect=
# limits.maxColumnsInTable=
# limits.maxConnections=
# limits.maxCursorNameLength=
# limits.maxIndexLength=
# limits.maxSchemaNameLength=
# limits.maxProcedureNameLength=
# limits.maxCatalogNameLength=
# limits.maxRowSize=
# limits.maxStatementLength=
# limits.maxStatements=
# limits.maxTableNameLength=
# limits.maxTablesInSelect=
# limits.maxUserNameLength=
# limits.defaultTransactionIsolation=
# limits.maxLengthInClause

# 
# General
# 

# 
# Null ordering
# 
general.nullsAreSortedHigh=true
general.nullsAreSortedLow=false
general.nullsAreSortedAtStart=false
general.nullsAreSortedAtEnd=false
# Unable to specificy how nulls order on a cursor.
general.nullsOrdering=false
# Unable to specify ordering in a window
general.nullsOrderingInWindowSpecification=false

# supports.hints=false
supports.constantsInWindows=false

# Cursor options - appended to end of generated SELECT statement.
general.cursorOptions=

# 
# Various
# 
supports.duplicateColumnsInSelectList=true
supports.columnAliasing=true
supports.tableCorrelationNames=true
supports.expressionsInSelectList=true
supports.expressionsInINPredicate=true
supports.expressionsInOrderBy=false
supports.booleanExpressionsInSelectList=false
supports.fieldsOfComplexTypeInSelectList=false
supports.likeEscapeClause=true
supports.outerJoins=false
supports.fullOuterJoins=true
supports.subqueriesInComparisons=true
supports.subqueriesInExists=true
supports.subqueriesInIns=true
supports.subqueriesInCase=false
supports.correlatedSubqueries=true
supports.correlatedSubqueriesInSelectList=false
supports.correlatedSubqueriesInIns=true
supports.scalarSubqueries=true
supports.withClauseInDerivedTable=false
supports.nestedWithClause=false
supports.integerDivision=true
supports.nestedOlap=false
supports.derivedColumnLists=false
supports.orderByAlias=true
supports.orderByName=true
supports.orderByOrdinal=true
supports.blobsInGroupBy=false
supports.blobsInOrderBy=false
supports.emptyStringIsNull=false
# Does not support group by ordinal
# Does not support group by alias
supports.expressionsInGroupBy=false
supports.expressionsInOrderBy=false
supports.aliasInOrderByExpression=false
supports.orderByUnrelated=true
supports.groupByUnrelated=false
supports.thetaJoins=true
supports.equiJoins=true
supports.crossProducts=true
supports.multipleDistinctAggregates=true
supports.recursiveWithClause=false
supports.rowNumberNoOrderBy=false
supports.parameterMarkers=true
supports.constantsInWindows=false
supports.orderByInDerivedTable=false
supports.constantsInCount=false
supports.join.subqueriesInOnClause=true
#casting with formatting pattern support
supports.formatters.string_to_date=false
supports.formatters.string_to_time=false
supports.formatters.string_to_time_with_time_zone=false
supports.formatters.string_to_timestamp=false
supports.formatters.string_to_timestamp_with_time_zone=false

# 
# Grouping query optimization
# 
# If the RDBMS has costing/execution issues with group by or distinct consider these transforms
performance.convertGroupByToDistinct=false
performance.convertDistinctToGroupBy=false

# V5 master-detail optimization when allRows optimization is specified
v5.master-detail.transform=false
performance.convertHavingToWhere=false
performance.transitiveClosure=false
performance.predicatePushdown=false
performance.semiJoin=false

# 
# Commands
# 
commands.Select=SELECT
commands.Call= 

# 
# Tables
# 
tables.joined=true
tables.derived=true
tables.lateral.derived=false

# 
# Constructors
# 
constructors.table=false
constructors.row=false
constructors.array=false
constructors.period=false
constructors.map=false

# 
# Constructors - context overrides.
# 
constructors.row.simpleCase=false
constructors.row.between=false
constructors.row.inListToTable=false


# 
# Clauses
# 
clauses.From=FROM
clauses.Where=WHERE
clauses.GroupBy=GROUP BY
clauses.Having=HAVING
clauses.WithRecursive=
clauses.With= 
clauses.OrderBy=ORDER BY
clauses.Distinct=DISTINCT
clauses.Top= 
clauses.Limit= 
clauses.FetchFirst= 
clauses.At=
clauses.Window= 
clauses.TableSampleSystem=
clauses.TableSampleBernoulli=
clauses.ForSystemTimeAsOf=
clauses.ForSystemTimeFrom=
clauses.ForSystemTimeBetween=

# 
# Joins
# 
# Does not support nested outer joins
# Has Inner table restriction
# Has one outer join restriction
# Has left nested join restriction
# Does not allow on condition to use set functions
# Does not allow non equi joins in full outer join
# Has two sided join filter restriction
joins.Cross=%1$s CROSS JOIN %2$s
joins.Inner=%1$s INNER JOIN %2$s ON %3$s

# Due to IDMS nested joins issues these have to be disabled
#joins.LeftOuter=%1$s LEFT OUTER JOIN %2$s ON %3$s
#joins.RightOuter=%1$s RIGHT OUTER JOIN %2$s ON %3$s
#joins.FullOuter=%1$s FULL OUTER JOIN %2$s ON %3$s
joins.LeftOuter=
joins.RightOuter=
joins.FullOuter=
joins.RightNested=%1$s

# 
# Set Operators
# 
# One or more set operations does not follow ISO data type combination rules. Can effect set operations, CASE, COALESCE...
operators.set.Union=%1$s UNION %2$s
operators.set.Union.all=%1$s UNION ALL %2$s
operators.set.Intersect= 
operators.set.Intersect.all= 
operators.set.Except= 
operators.set.Except.all= 

# 
# Logical Operators
# 
operators.logical.And=%1$s AND %2$s
operators.logical.Or=%1$s OR %2$s
operators.logical.Not=NOT ( %1$s )
operators.logical.Is=
operators.logical.IsNot=

# 
# Arithmetic and Character operators
# 
# Division may return a precise type if expression not coerced to imprecise type
operators.arithmetic.Add[any,any]=%1$s + %2$s
operators.arithmetic.Subtract[any,any]=%1$s - %2$s

# IDMS will not allow you to mix approximates and precise in subtraction
operators.arithmetic.Subtract[float,any]=
operators.arithmetic.Subtract[any,float]=
operators.arithmetic.Subtract[double,any]=
operators.arithmetic.Subtract[any,double]=

operators.arithmetic.Subtract[any,datetime]=
operators.arithmetic.Subtract[datetime,any]= 
operators.arithmetic.Multiply[any,any]=%1$s * %2$s
operators.arithmetic.Divide[any,any]=%1$s / %2$s

# IDMS will not allow you to mix approximates and precise in division
operators.arithmetic.Divide[float,any]=
operators.arithmetic.Divide[any,float]=
operators.arithmetic.Divide[double,any]=
operators.arithmetic.Divide[any,double]=

operators.arithmetic.UnaryPlus[any]= 
operators.arithmetic.Negate[any]=-%1$s
operators.arithmetic.Concat[any,any]=%1$s || %2$s


# 
# Grouping Operators
# 
operators.groupBy.Rollup= 
operators.groupBy.Cube= 
operators.groupBy.GroupingSets= 

# 
# Comparison Predicates
# 
predicates.comparison.Equals[any,any]=%1$s = %2$s
predicates.comparison.GreaterThan[any,any]=%1$s > %2$s
predicates.comparison.GreaterThanOrEquals[any,any]=%1$s >= %2$s
predicates.comparison.LessThan[any,any]=%1$s < %2$s
predicates.comparison.LessThanOrEquals[any,any]=%1$s <= %2$s
predicates.comparison.NotEquals[any,any]=%1$s <> %2$s

# 
# Predicates
# 
predicates.Between[any,any,any]=%1$s BETWEEN %2$s AND %3$s
# Does not support aggregate in In predicate
predicates.In[any,any]=%1$s IN ( %2$s )
predicates.Overlaps[any,any,any,any]= 
# Does not support value expression in Is Null
predicates.IsNull=
predicates.IsNotNull=
# Does not support value expression in Like
predicates.Like=
predicates.Like.escape=
predicates.LikeRegex=
predicates.LikeRegex.flag=
predicates.Similar= 
predicates.Similar.escape= 
predicates.Exists=EXISTS %1$s
predicates.All=ALL %1$s
predicates.Any= 
predicates.Some=SOME %1$s
predicates.IsDistinctFrom[any,any]=(%1$s IS NULL AND %2$s IS NOT NULL) OR (%1$s IS NOT NULL AND %2$s IS NULL) OR %1$s <> %2$s
predicates.IsNotDistinctFrom[any,any]=%1$s = %2$s OR (%1$s IS NULL AND %2$s IS NULL)

# 
# Expressions
# 

# 
# Conditional expressions
# 
expressions.SimpleCase=
expressions.SearchedCase=
expressions.Coalesce=COALESCE(%1$s)
#expressions.Coalesce[timestamp,date]=
#expressions.Coalesce[date,timestamp]= 
expressions.NullIf= 

# 
# Cast
# 
# Cannot cast from null value to Float
expressions.Cast[any,any]=CAST(%1$s AS %2$s)
expressions.Cast[smallint,float]=
expressions.Cast[smallint,varchar]=
expressions.Cast[integer,float]=
expressions.Cast[integer,varchar]=
expressions.Cast[long,float]=
expressions.Cast[long,varchar]=
expressions.Cast[decimal,float]=
expressions.Cast[decimal,char]=
expressions.Cast[decimal,varchar]=
expressions.Cast[float,float]=
expressions.Cast[float,char]=
expressions.Cast[float,varchar]=
expressions.Cast[double,float]=
expressions.Cast[double,char]=
expressions.Cast[double,varchar]=
expressions.Cast[float,decimal]=
expressions.Cast[char,decimal]=
expressions.Cast[char,float]=
expressions.Cast[char,varchar]=
expressions.Cast[varchar,float]=
expressions.Cast[date,varchar]=
expressions.Cast[time,char]=
expressions.Cast[time,varchar]=
expressions.Cast[time,timestamp]=
expressions.Cast[timestamp,char]=
expressions.Cast[timestamp,varchar]=
# 
# Extract
# 
expressions.Extract.YEAR[any]=YEAR(%1$s)
expressions.Extract.MONTH[any]=MONTH(%1$s)
expressions.Extract.DAY[any]=DAY(%1$s)
expressions.Extract.HOUR[any]=HOUR(%1$s)
expressions.Extract.MINUTE[any]=MINUTE(%1$s)
expressions.Extract.SECOND[any]= 
expressions.Extract.TIMEZONE_HOUR[any]=
expressions.Extract.TIMEZONE_MINUTE[any]=

# 
# Trim
# 
expressions.Trim.BOTH[any]=TRIM(TRAILING FROM (TRIM(LEADING FROM %1$s)))
expressions.Trim.BOTH[any,any]=
expressions.Trim.LEADING[any]=TRIM(LEADING FROM %1$s)
expressions.Trim.LEADING[any,any]=TRIM(LEADING %1$s FROM %2$s)
expressions.Trim.TRAILING[any]=TRIM(TRAILING FROM %1$s)
expressions.Trim.TRAILING[any,any]=TRIM(TRAILING %1$s FROM %2$s)

# 
# Windowed aggregates (SQL/OLAP).
# 
olap.Max[any]= 
olap.Min[any]= 
olap.Sum[any]= 
olap.Avg[any]= 
olap.Count[any]= 
olap.CountStar[]=
olap.StdDevPop[any]= 
olap.StdDevSamp[any]= 
olap.VarPop[any]= 
olap.VarSamp[any]= 
olap.Rank[]=
olap.Rank[any,any]=
olap.DenseRank[]=
olap.PercentRank[]=
olap.CumeDist[]=
olap.PercentileCont[any,any]=
olap.PercentileDisc[any,any]=
olap.RatioToReport[any]=
olap.RowNumber[]=
olap.Difference[any]=
olap.FirstValue[any]=
olap.LastValue[any]=
olap.NTile[any]=
olap.Lag[any]=
olap.Lag[any,any]=
olap.Lag[any,any,any]=
olap.Lag[any,any,any,any]=
olap.Lead[any]=
olap.Lead[any,any]=
olap.Lead[any,any,any]=
olap.Lead[any,any,any,any]=
olap.NthValue[any,any]=
olap.NthValue[any,any,any]=
olap.NthValue[any,any,any,any]= 
olap.Collect[any]= 

# 
# Window clause
# 
olap.Window= 
olap.PartitionBy=
olap.OrderBy= 

# 
# Window specification
# 
olap.Window.Specification[POF]=false
olap.Window.Specification[PF]=false
olap.Window.Specification[OF]=false
olap.Window.Specification[PO]=false
olap.Window.Specification[P]=false
olap.Window.Specification[O]=false
olap.Window.Specification[F]=false
olap.Window.Specification[]=false

# 
# Olap Distinct
# 
olap.Min.distinct[any]= 
olap.Max.distinct[any]= 
olap.Sum.distinct[any]= 
olap.Avg.distinct[any]= 
olap.Count.distinct[any]= 

# 
# Aggregates
# 
aggregates.Max[any]=MAX(%1$s)
aggregates.Min[any]=MIN(%1$s)
aggregates.Count[any]=COUNT(%1$s)
aggregates.CountStar[]=COUNT(*)
aggregates.Sum[any]=SUM(%1$s)
# Avg may return a precise type if expression not coerced to imprecise type
aggregates.Avg[any]=AVG(%1$s)
# IDMS has an issue with divisions mixing types involving float and double. problem 4931 
aggregates.Avg[float]=
aggregates.Avg[double]=
aggregates.StdDevPop[any]=
aggregates.StdDevSamp[any]=
aggregates.VarPop[any]=
aggregates.VarSamp[any]=
aggregates.Rank[any,any]=
aggregates.DenseRank[any,any]=
aggregates.PercentRank[any,any]=
aggregates.CumeDistH[any,any]=
aggregates.PercentileDisc[any,any]= 
aggregates.PercentileCont[any,any]= 
aggregates.Grouping[any]=
aggregates.XMLAgg=
aggregates.ArrayAgg[any]= 
aggregates.ArrayAgg[any,any]= 
aggregates.Collect[any]=
aggregates.ApproxCountDistinct[any]=

# 
# Distinct aggregates
# 
aggregates.Avg.distinct[any]= 
aggregates.Min.distinct[any]=MIN(DISTINCT %1$s)
aggregates.Max.distinct[any]=MAX(DISTINCT %1$s)
aggregates.Count.distinct[any]=COUNT(DISTINCT %1$s)
aggregates.Sum.distinct[any]=SUM(DISTINCT %1$s)

# 
# Linear regression aggregates
# 
aggregates.Corr[any,any]=
aggregates.CovarPop[any,any]=
aggregates.CovarSamp[any,any]=
aggregates.RegrAvgX[any,any]=
aggregates.RegrAvgY[any,any]=
aggregates.RegrCount[any,any]=
aggregates.RegrIntercept[any,any]=
aggregates.RegrR2[any,any]=
aggregates.RegrSlope[any,any]=
aggregates.RegrSXX[any,any]=
aggregates.RegrSXY[any,any]=
aggregates.RegrSYY[any,any]=

# 
# Character scalar functions
# 

# IDMS will return 0 and not null when null input provided
functions.CharLength[any]=CHAR_LENGTH(%1$s)
functions.OctetLength[any]=OCTET_LENGTH(%1$s)
functions.Upper[any]=UPPER(%1$s)
functions.Lower[any]=LOWER(%1$s)
functions.Substring[any,any]=SUBSTRING(%1$s FROM CAST(%2$s as INTEGER))
# IDMS will fail is the length is pushed inside a function such as CAST
functions.Substring[any,any,any]=SUBSTRING(%1$s FROM CAST(%2$s as INTEGER) FOR %3$s)
functions.SubstringR[any,any]=
functions.SubstringR[any,any,any]=
functions.Position[any,any]=POSITION(%1$s IN %2$s)
functions.Index[any,any]=
functions.Ascii[any]=
functions.Translate[any,any]= 
functions.Normalize[any,]= 
functions.Normalize[any,any]= 
functions.Normalize[any,any,any]= 

# 
# Numeric scalar functions
# 
functions.Abs[any]=ABS(%1$s)
functions.Ceiling[any]=CEILING(%1$s)
functions.Exp[any]=EXP(%1$s)
functions.Floor[any]=FLOOR(%1$s)
functions.Ln[any]= 
functions.Log10[any]=LOG10(%1$s)
functions.Mod[any,any]=MOD(%1$s, %2$s)
functions.Power[any,decimal]=POWER(%1$s, %2$s)
functions.Power[any,smallint]= 
functions.Power[any,long]=POWER(%1$s, %2$s)
functions.Power[any,integer]= 
functions.Round[any]=
functions.Round[any,any]=ROUND(%1$s, %2$s)
functions.Round[any,any,any]=
functions.Sign[any]=SIGN(%1$s)
functions.Sqrt[any]=SQRT(%1$s)
functions.WidthBucket[any,any,any,any]=

# 
# Array scalar functions
# 
functions.Cardinality[any]=
functions.TrimArray[any,any]=

# 
# Trig Functions
# 
functions.Arccos[any]=ACOS(%1$s)
functions.Cos[any]=COS(%1$s)
functions.Coshyp[any]=COSH(%1$s)
functions.Arcsin[any]=ASIN(%1$s)
functions.Sin[any]=SIN(%1$s)
functions.Sinhyp[any]=SINH(%1$s)
functions.Arctan[any]=ATAN(%1$s)
functions.Tan[any]=TAN(%1$s)
functions.Tanhyp[any]=TANH(%1$s)

# 
# Temporal value expressions
# 

functions.CurrentDate[]=CURDATE()
functions.CurrentTime[]=CURTIME()
functions.CurrentTime[numeric]=
functions.CurrentTimestamp[]=NOW()
functions.CurrentTimestamp[numeric]= 
functions.LocalTime[]=
functions.LocalTime[numeric]= 
functions.LocalTimestamp[]=
functions.LocalTimestamp[numeric]= 

# 
# XML Functions
# 
functions.XMLAttributes= 
functions.XMLComment= 
functions.XMLConcat= 
functions.XMLDocument= 
functions.XMLElement= 
functions.XMLExists= 
functions.XMLForest= 
functions.XMLNamespaces= 
functions.XMLParse= 
functions.XMLPI=
functions.XMLQuery= 
functions.XMLSerialize= 
functions.XMLTable= 
functions.XMLText= 
functions.XMLTransform= 
functions.XMLValidate= 
functions.XMLElement.ContentOption.NULL_ON_NULL=false
functions.XMLElement.ContentOption.EMPTY_ON_NULL=false
functions.XMLForest.ContentOption.NULL_ON_NULL=false
functions.XMLForest.ContentOption.EMPTY_ON_NULL=false
functions.XMLParse.DocumentOrContent.DOCUMENT=false
functions.XMLParse.DocumentOrContent.CONTENT=false
functions.XMLParse.WhitespaceOption.STRIP_WHITESPACE=false
functions.XMLParse.WhitespaceOption.PRESERVE_WHITESPACE=false
functions.XMLQuery.EmptyHandlingOption.NULL_ON_EMPTY=false
functions.XMLQuery.EmptyHandlingOption.EMPTY_ON_EMPTY=false
functions.XMLSerialize.DeclarationOption.INCLUDING_XMLDECLARATION=false
functions.XMLSerialize.DeclarationOption.EXCLUDING_XMLDECLARATION=false

# 
# Business functions.
# 
functions.AddHours[any,any]=(%1$s + (%2$s) HOURS)
functions.AddMinutes[any,any]=(%1$s + (%2$s) MINUTES)
functions.AddSeconds[any,any]=(%1$s + (%2$s) SECONDS)
functions.AddFractionalSeconds[any,any]=
functions.AddDays[any,any]=(%1$s + (%2$s) DAYS)
functions.AddWeeks[any,any]=(%1$s + (%2$s * 7) DAYS)
functions.AddMonths[any,any]=
functions.AddQuarters[any,any]=
functions.AddYears[any,any]=(%1$s + (%2$s) YEARS)
functions.Age[any]=
functions.FractionalSecondsBetween[any,any]=
functions.SecondsBetween[any,any]=
functions.MinutesBetween[any,any]=
functions.HoursBetween[any,any]=
functions.DaysBetween[any,any]=days(%1$s) - days(%2$s)
functions.WeeksBetween[any,any]=
functions.MonthsBetween[any,any]=
functions.QuartersBetween[any,any]=
functions.YearsBetween[any,any]=
functions.DayOfWeek[any,any]=
functions.DayOfYear[any]=
functions.DaysToEndOfMonth[any]=(DAY((((%1$s - ((DAY(%1$s)) DAYS)  + 1 DAYS)) + 1 MONTH - 1 DAYS))- DAY(%1$s))
functions.FirstOfMonth[any]=(%1$s - ((DAY(%1$s)) DAYS)  + 1 DAYS)
functions.LastOfMonth[any]=(((%1$s - ((DAY(%1$s)) DAYS)  + 1 DAYS)) + 1 MONTH - 1 DAYS)
functions.MakeTimestamp[any,any,any]=
functions.WeekOfYear[any]=
functions.YMDIntBetween[any,any]=

# 
# Table functions
# 
functions.Unnest=

# 
# Literals
# 
literals.smallint=true
literals.decimal=true
literals.float=true
literals.char=true
literals.nchar=false
literals.varchar=true
literals.nvarchar=false
literals.blob=false
literals.clob=false
literals.nclob=false
literals.date=true
literals.time=true
literals.time_with_time_zone=false
literals.timestamp=true
literals.timestamp_with_time_zone=false
literals.interval_year=false
literals.interval_month=false
literals.interval_year_to_month=false
literals.interval_day=false
literals.interval_hour=false
literals.interval_minute=false
literals.interval_second=false
literals.interval_day_to_hour=false
literals.interval_day_to_minute=false
literals.interval_day_to_second=false
literals.interval_hour_to_minute=false
literals.interval_hour_to_second=false
literals.interval_minute_to_second=false
literals.binary=false
literals.boolean=false
literals.xml=false
literals.array=false
literals.perioddate=false

# Literal format specifications. Formats are compatible with String.format().
# Values for default behaviour are listed.
# Only char, temporal and string types can be overridden.
# Fractional seconds are presented as a string of up to 10 characters: '.' followed by 9 character
# 0-padded string representing nanoseconds or empty.
literals.format.boolean=
literals.format.char='%s'
literals.format.clob='%s'
literals.format.date=DATE('%1$04d-%2$02d-%3$02d')
literals.format.interval_day=
literals.format.interval_day_to_hour=
literals.format.interval_day_to_minute=
literals.format.interval_day_to_second=
literals.format.interval_hour=
literals.format.interval_hour_to_minute=
literals.format.interval_hour_to_second=
literals.format.interval_minute=
literals.format.interval_minute_to_second=
literals.format.interval_month=
literals.format.interval_second=
literals.format.interval_year=
literals.format.interval_year_to_month=
literals.format.nchar=
literals.format.nvarchar=
literals.format.time=TIME('%1$02d:%2$02d:%2$02d%4$.10s')
literals.format.time_with_time_zone=
literals.format.timestamp=TIMESTAMP('%1$04d-%2$02d-%3$02d %4$02d:%5$02d:%6$02d%7$.10s')
literals.format.timestamp_with_time_zone=
literals.format.varchar='%s'
# 
# DataTypes
# 
dataType.smallint=true
dataType.integer=true
dataType.long=true
dataType.decimal=true
dataType.float=true
dataType.double=true
dataType.char=true
dataType.nchar=false
dataType.varchar=true
dataType.nvarchar=false
dataType.clob=false
dataType.blob=false
dataType.date=true
dataType.time=true
dataType.time_with_time_zone=false
dataType.timestamp=true
dataType.timestamp_with_time_zone=false
dataType.interval_year=false
dataType.interval_month=false
dataType.interval_year_to_month=false
dataType.interval_day=false
dataType.interval_hour=false
dataType.interval_minute=false
dataType.interval_second=false
dataType.interval_day_to_hour=false
dataType.interval_day_to_minute=false
dataType.interval_day_to_second=false
dataType.interval_hour_to_minute=false
dataType.interval_hour_to_second=false
dataType.interval_minute_to_second=false
dataType.boolean=false
dataType.binary=false
dataType.xml=false
dataType.perioddate=false
dataType.array=false
dataType.struct=false
dataType.map=false
dataType.json=false

# 
# Collation
# 
# Collation Sequence SQL (SQL statement for retrieving the collation sequence)
# This statement returns a single row and single column containing the collation sequence
collation.sequence.sql=
# Datbase Encoding SQL. This statement retrieves the charset name for the non-unicode character data.
# This statement returns a single row and single column with the charset name for use in a java.nio.CharsetEncoder.
database.charset.sql=

# 
# dataType.comparable
# 
# Used to indicate that some data types that are comparable locally may not by the database
# e.g. dataType.comparable[varchar,nvarchar]=false

# 
# dataType.promotion
# 
# Used to indicate what direction the promotion needs to occur
# <lhs> -> <rhs> these properties are not symetrical
# e.g. dataType.promotion[char,nvarchar]=true