#Licensed Materials - Property of IBM # #OCO Source Materials # #BI and PM: rdbmscert # #(C) Copyright IBM Corp. 2019, 2020 # #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. # # # Delimiters # # While a vendor may parse a statement with comments it may strip them out and the server not see them delimiters.commentBegin= delimiters.commentEnd= # delimiters.catalogDelimiter= # delimiters.schemaDelimiter= # delimiters.tableDelimiter= # delimiters.columnDelimiter= # delimiters.identifierQuoteString= # delimiters.searchStringEscape= # delimiters.catalogSeparator= # # Keywords # keywords.columnAlias=AS # Override sampling policy with a different one. # 1. tablesample accepting values such as BERNOULLI or SYSTEM # 2. rowsample accepting values such as NTH or RANDOM # sampling.tablesample= sampling.rowsample= # # 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 # # No support is provided for vendors who change how nulls sort based on data type. general.nullsAreSortedHigh=false general.nullsAreSortedLow=false general.nullsAreSortedAtStart=false general.nullsAreSortedAtEnd=false general.nullsOrdering=false general.nullsOrderingInWindowSpecification=false # supports.hints=false supports.constantsInWindows=false # Cursor options - appended to end of generated SELECT statement. general.cursorOptions= # # Various # supports.duplicateColumnsInSelectList=false supports.columnAliasing=true supports.tableCorrelationNames=true supports.expressionsInSelectList=false supports.expressionsInINPredicate=false supports.expressionsInOrderBy=false supports.literalsInSelectList=true supports.booleanExpressionsInSelectList=false supports.fieldsOfComplexTypeInSelectList=false supports.likeEscapeClause=false supports.outerJoins=false supports.fullOuterJoins=false supports.subqueriesInComparisons=false supports.subqueriesInExists=false supports.subqueriesInIns=false supports.subqueriesInQuantifieds=false supports.subqueriesInOnClause=false supports.subqueriesInCase=false supports.subqueriesInAggregate=false supports.correlatedSubqueries=false supports.correlatedSubqueriesInSelectList=false supports.correlatedSubqueriesInIns=false supports.scalarSubqueries=false supports.withClauseInDerivedTable=false supports.nestedWithClause=false supports.integerDivision=true supports.nestedOlap=false supports.derivedColumnLists=true supports.orderByAlias=false supports.orderByName=false supports.orderByOrdinal=false supports.blobsInGroupBy=false supports.blobsInOrderBy=false supports.transactions=false supports.emptyStringIsNull=false supports.expressionsInGroupBy=false supports.expressionsInOrderBy=false supports.expressionsInLikePattern=false supports.aliasInOrderByExpression=false supports.orderByUnrelated=false supports.groupByUnrelated=false supports.thetaJoins=true supports.equiJoins=true supports.crossProducts=true supports.multipleDistinctAggregates=false supports.recursiveWithClause=false supports.rowNumberNoOrderBy=false supports.parameterMarkers=false supports.constantsInWindows=false supports.orderByInDerivedTable=false supports.callProcedureInDerivedTable=false supports.orderByInDerivedTable=false #join condition supports.join.betweenInOnClause=false supports.join.inPredicateInOnClause=false supports.join.isNullInOnClause=false supports.join.likeInOnClause=false supports.join.notInOnClause=false supports.join.orInOnClause=false supports.join.subqueriesInOnClause=false supports.join.onlyEquiWithAnd=true supports.join.inner.limitedThetaJoins=false supports.join.outer.thetaJoins=false supports.join.full.thetaJoins=false supports.join.full.distinctJoins=false #isolation level support supports.isolationLevelReadUncommitted=false supports.isolationLevelReadCommitted=false supports.isolationLevelRepeatableRead=false supports.isolationLevelSerializable=false supports.constantsInCount=false supports.columnFiltersOnly=false supports.hanaInputParameters=false supports.mixedCaseIdentifiers=false supports.mixedCaseQuotedIdentifiers=false 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=true performance.predicatePushdown=false performance.semiJoin=false # RTC 377496 # Set this entry to F to avoid generation of predicates of the form # T1.C1 = T2.C1 OR ( T1.C1 IS NULL AND T2.C1 IS NULL ). Care must be # taken, however, since doing so may cause data integrity problems if # data contains null values. performance.generateEqualOrNull=true # # Commands # commands.Select=SELECT commands.Call= # # Tables # tables.joined=true tables.derived=false 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.isDistinctFrom=false constructors.row.inListToTable=false constructors.row.comparison=false constructors.row.in=false # # Clauses # clauses.From=FROM clauses.Where=WHERE clauses.GroupBy= clauses.Having= clauses.WithRecursive= clauses.With= clauses.OrderBy= clauses.Distinct= clauses.Top= clauses.At= clauses.Window= clauses.TableSampleSystem= clauses.TableSampleBernoulli= clauses.ForSystemTimeAsOf= clauses.ForSystemTimeFrom= clauses.ForSystemTimeBetween= # # Joins # joins.Cross=%1$s CROSS JOIN %2$s joins.Inner=%1$s INNER JOIN %2$s ON %3$s joins.LeftOuter= joins.RightOuter= joins.FullOuter= joins.RightNested= # # Set Operators # operators.set.Union= operators.set.Union.all= 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= operators.logical.Is= operators.logical.IsNot= operators.logical.IsJson= operators.logical.IsNotJson= # # Arithmetic and Character operators # # Division may return a precise type if expression not coerced to imprecise type operators.arithmetic.Add[any,any]= operators.arithmetic.Subtract[any,any]= operators.arithmetic.Multiply[any,any]= operators.arithmetic.Divide[any,any]= operators.arithmetic.UnaryPlus[any]= operators.arithmetic.Negate[any]= operators.arithmetic.Concat[any,any]= # # 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]= # # Predicates # predicates.Between[any,any,any]=%1$s BETWEEN %2$s AND %3$s predicates.In[any,any]= predicates.In[text,text]=%1$s IN ( %2$s ) predicates.In[date,date]=%1$s IN ( %2$s ) predicates.Overlaps[any,any,any,any]= predicates.IsNull= predicates.IsNotNull= predicates.Like= predicates.Like.escape= predicates.LikeRegex= predicates.LikeRegex.flag= predicates.Similar= predicates.Similar.escape= predicates.Exists= predicates.All= predicates.Any= predicates.Some= predicates.IsDistinctFrom[any,any]= predicates.IsNotDistinctFrom[any,any]= # # Period predicates. # predicates.PeriodOverlaps[any,any]= predicates.PeriodEquals[any,any]= predicates.PeriodContains[any,any]= predicates.PeriodPrecedes[any,any]= predicates.PeriodSucceeds[any,any]= predicates.PeriodImmediatelyPrecedes[any,any]= predicates.PeriodImmediatelySucceeds[any,any]= # # Expressions # expressions.ArrayElementRef.zeroBased=false # # Conditional expressions # expressions.SimpleCase= expressions.SearchedCase= # Minimum number of arguments for Coalesce function. expressions.Coalesce.minArgs=2 expressions.Coalesce= expressions.NullIf= # # Cast # expressions.Cast[any,any]= expressions.Cast[any,any,any]= # # Extract # expressions.Extract.YEAR[any]= expressions.Extract.MONTH[any]= expressions.Extract.DAY[any]= expressions.Extract.HOUR[any]= expressions.Extract.MINUTE[any]= expressions.Extract.SECOND[any]= expressions.Extract.TIMEZONE_HOUR[any]= expressions.Extract.TIMEZONE_MINUTE[any]= expressions.Extract.EPOCH[any]= # # Trim # expressions.Trim.BOTH[any]= expressions.Trim.BOTH[any,any]= expressions.Trim.LEADING[any]= expressions.Trim.LEADING[any,any]= expressions.Trim.TRAILING[any]= expressions.Trim.TRAILING[any,any]= # # 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.DenseRank[]= olap.CumeDist[]= olap.PercentileCont[any,any]= olap.PercentileDisc[any,any]= olap.PercentRank[]= olap.RatioToReport[any]= olap.Median[any]= olap.RowNumber[]= olap.Difference[any]= olap.FirstValue[any]= olap.LastValue[any]= olap.NTile[any]= olap.Tertile[]= 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=s # # 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]= aggregates.Min[any]= aggregates.Count[any]= aggregates.CountStar[]= aggregates.Sum[any]= aggregates.Avg[any]= 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.Median[any]= aggregates.Grouping[any]= aggregates.XMLAgg[any]= aggregates.ArrayAgg[any]= aggregates.ArrayAgg[any,any]= aggregates.Collect[any]= aggregates.ApproxCountDistinct[any]= # # Distinct aggregates # aggregates.Avg.distinct[any]= aggregates.Min.distinct[any]= aggregates.Max.distinct[any]= aggregates.Count.distinct[any]= aggregates.Sum.distinct[any]= # # 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]= # # JSON aggregates. # aggregates.JSONArrayAgg= aggregates.JSONObjectAgg= # # Character scalar functions # functions.CharLength[any]= functions.OctetLength[any]= functions.BitLength[any]= functions.Upper[any]= functions.Lower[any]= functions.Substring[any,any]= functions.Substring[any,any,any]= functions.Position[any,any]= functions.Index[any,any]= functions.Ascii[any]= functions.Translate[any,any]= functions.Normalize[any]= functions.Normalize[any,any]= functions.Normalize[any,any,any]= # # Regular expression functions. # functions.SubstringRegex[any,any,any,any,any]= functions.OccurrencesRegex[any,any,any,any]= functions.PositionRegex[any,any,any,any,any,any]= # # Numeric scalar functions # functions.Abs[any]= functions.Ceiling[any]= functions.Exp[any]= functions.Floor[any]= functions.Ln[any]= functions.Log10[any]= functions.Mod[any,any]= functions.Power[any,any]= functions.Random[]= functions.Random[any]= functions.Round[any]= functions.Round[any,any]= functions.Round[any,any,any]= functions.Sign[any]= functions.Sqrt[any]= functions.WidthBucket[any,any,any,any]= # # Array scalar functions # functions.Cardinality[any]= functions.TrimArray[any,any]= # # Trig Functions # functions.Arccos[any]= functions.Cos[any]= functions.Coshyp[any]= functions.Arcsin[any]= functions.Sin[any]= functions.Sinhyp[any]= functions.Arctan[any]= functions.Tan[any]= functions.Tanhyp[any]= # # Temporal value expressions # functions.CurrentDate[]=current_date functions.CurrentTime[]= functions.CurrentTime[numeric]= functions.CurrentTimestamp[]= 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=true functions.XMLQuery.EmptyHandlingOption.EMPTY_ON_EMPTY=true functions.XMLSerialize.DeclarationOption.INCLUDING_XMLDECLARATION=false functions.XMLSerialize.DeclarationOption.EXCLUDING_XMLDECLARATION=false # # JSON functions. # functions.JSONObject= functions.JSONArray= functions.JSONExists= functions.JSONQuery= functions.JSONTable= functions.JSONValue= # # Business functions. # functions.AddHours[any,any]= functions.AddMinutes[any,any]= functions.AddSeconds[any,any]= functions.AddFractionalSeconds[any,any]= functions.AddDays[any,any]= functions.AddDays[date,exact]=addDays(%1$s, %2$s) functions.AddWeeks[any,any]= functions.AddMonths[any,any]= functions.AddMonths[date,exact]=addMonths(%1$s, %2$s) functions.AddQuarters[any,any]= functions.AddYears[any,any]= functions.AddYears[date,exact]=addYears(%1$s, %2$s) functions.Age[any]= functions.FractionalSecondsBetween[any,any]= functions.SecondsBetween[any,any]= functions.MinutesBetween[any,any]= functions.HoursBetween[any,any]= functions.DaysBetween[any,any]= 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]= functions.FirstOfMonth[any]= functions.LastOfMonth[any]= 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=true literals.varchar=true literals.nvarchar=true literals.blob=false literals.clob=false literals.nclob=false literals.date=true literals.time=false literals.time_with_time_zone=false literals.timestamp=false 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.date=true literals.time=false literals.time_with_time_zone=false literals.timestamp=false literals.timestamp_with_time_zone=false literals.binary=false literals.boolean=false literals.xml=false literals.datalink=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='%1$s' literals.format.clob= 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='%s' literals.format.nvarchar='%s' literals.format.time= literals.format.time_with_time_zone= literals.format.timestamp= literals.format.timestamp_with_time_zone= literals.format.varchar='%s' literals.format.decimal='%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=true dataType.varchar=true dataType.nvarchar=true dataType.clob=false dataType.blob=false dataType.date=true dataType.time=false dataType.time_with_time_zone=false dataType.timestamp=false 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 # -> these properties are not symetrical # e.g. dataType.promotion[char,nvarchar]=true