analytics/configuration/xqe/odata.properties

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

#
# Product information.
#
product.name=

#
# Delimiters.
#
delimiters.identifierQuoteString=
delimiters.searchStringEscape=
delimiters.catalogSeparator=

#
# Various limits.
#
limits.maxBinaryLiteralLength=0
limits.maxCharLiteralLength=0
limits.maxColumnNameLength=0
limits.maxColumnsInGroupby=0
limits.maxColumnsInIndex=0
limits.maxColumnsInOrderBy=0
limits.maxColumnsInSelect=0
limits.maxColumnsInTable=0
limits.maxConnections=0
limits.maxCursorNameLength=0
limits.maxIndexLength=0
limits.maxSchemaNameLength=0
limits.maxProcedureNameLength=0
limits.maxCatalogNameLength=0
limits.maxRowSize=0
limits.maxStatementLength=0
limits.maxStatements=0
limits.maxTableNameLength=0
limits.maxTablesInSelect=0
limits.maxUserNameLength=0
limits.defaultTransactionIsolation=

#
# General settings.
#
general.nullsAreSortedHigh=false
general.nullsAreSortedLow=false
general.nullsAreSortedAtStart=false
general.nullsAreSortedAtEnd=false
general.nullsOrdering=false

#
# Various features.
#
supports.expressionsInSelectList=false
supports.integerDivision=false
supports.charLiteralRoundTrip=false
supports.fieldsOfComplexTypeInSelectList=false

# Disable joins
supports.outerJoins=false
supports.fullOuterJoins=false
supports.stitchJoins=false
supports.equiJoins=false
supports.thetaJoins=false
supports.crossProducts=false
#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

#
# Command.
#
commands.Select=select

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

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

#
# Clauses.
#
clauses.From=
clauses.Where=$filter
clauses.GroupBy=
clauses.Having=
clauses.With=
clauses.OrderBy=$orderby
clauses.Distinct=
clauses.Top=$top=%1$s
clauses.Top.Position=top.distinct
clauses.At=
clauses.Window=

#
# Joins.
#
joins.Cross=
joins.Inner=
joins.LeftOuter=
joins.RightOuter=
joins.FullOuter=

#
# Set operators.
#
operators.set.Union=
operators.set.Intersect=
operators.set.Intersect.all=
operators.set.Except=
operators.set.Except.all=

#
# Logical operators.
#
operators.logical.And[any,any]=%1$s and %2$s
operators.logical.Or[any,any]=%1$s or %2$s
operators.logical.Not[any]=not( %1$s )
operators.logical.Is=
operators.logical.IsNot=


#
# Logical operators.
#
operators.logical.And=%1$s and %2$s
operators.logical.Or=%1$s or %2$s
operators.logical.Not=not ( %1$s )

#
# Arithmetic operators.
#
operators.arithmetic.Add[any,any]=(%1$s add %2$s)
operators.arithmetic.Subtract[any,any]=(%1$s sub %2$s)
operators.arithmetic.Multiply[any,any]=(%1$s mul %2$s)
operators.arithmetic.Divide[any,any]=(%1$s div %2$s)
operators.arithmetic.Negate[any]=
operators.arithmetic.UnaryPlus[any]=
operators.arithmetic.Concat[any,any]=concat(%1$s, %2$s)

#
# Group By Operators
#
operators.groupBy.Rollup=
operators.groupBy.Cube=
operators.groupBy.GroupingSets=

#
# Comparison predicates.
#
predicates.comparison.LessThan[any,any]=%1$s lt %2$s
predicates.comparison.LessThanOrEquals[any,any]=%1$s le %2$s
predicates.comparison.Equals[any,any]=%1$s eq %2$s
predicates.comparison.NotEquals[any,any]=%1$s ne %2$s
predicates.comparison.GreaterThan[any,any]=%1$s gt %2$s
predicates.comparison.GreaterThanOrEquals[any,any]=%1$s ge %2$s

#
# Various predicates.
#
predicates.Between[any,any,any]=%1$s ge %2$s and %1$s le %3$s
predicates.In[any,any]=
predicates.Overlaps[any,any,any,any]=
predicates.IsNull=
predicates.IsNotNull=
predicates.Like.escape=
predicates.LikeRegex=
predicates.LikeRegex.flag=
predicates.Similar=
predicates.Similar.escape=
predicates.Exists=
predicates.All=
predicates.Any=
predicates.Some=
predicates.IsDistinctFrom=
predicates.IsNotDistinctFrom=

#
# 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.SearchedCase=
expressions.SimpleCase=
expressions.NullIf=
expressions.Coalesce=
#
# Cast expression.
#

#
# Extract expression.
#
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]=second(%1$s)
expressions.Extract.TIMEZONE_HOUR[any]=
expressions.Extract.TIMEZONE_MINUTE[any]=
expressions.Extract.EPOCH[any]=

#
# Trim expression.
#
expressions.Trim.BOTH[text]=trim(%1$s)
expressions.Trim.LEADING[text]=
expressions.Trim.TRAILING[text]=
expressions.Trim.BOTH[text,text]=
expressions.Trim.LEADING[text,text]=
expressions.Trim.TRAILING[text,text]=

#
# Windowed aggregates (SQL/OLAP).
#
olap.Max[any]=
olap.Min[any]=
olap.Sum[any]=
olap.Avg[any]=
olap.Count[any]=
olap.CountStar[]=
olap.StdDevSamp[any]=
olap.StdDevPop[any]=
olap.VarSamp[any]=
olap.VarPop[any]=
olap.Rank[]=
olap.DenseRank[]=
olap.PercentRank[]=
olap.CumeDist[]=
olap.PercentileCont[any,any]=
olap.PercentileDisc[any,any]=
olap.Median[any]=
olap.RowNumber[]=
olap.FirstValue[any]=
olap.LastValue[any]=
olap.NTile[any]=
olap.Tertile[]=
olap.RatioToReport[any]=
olap.Difference[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=

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

#
# Aggregates.
#
aggregates.Max[any]=
aggregates.Min[any]=
aggregates.Sum[any]=
aggregates.Avg[any]=
aggregates.Count[any]=
aggregates.CountStar[]=
aggregates.StdDevSamp[any]=
aggregates.StdDevPop[any]=
aggregates.VarSamp[any]=
aggregates.VarPop[any]=
aggregates.Rank[any,any]=
aggregates.DenseRank[any,any]=
aggregates.PercentRank[any,any]=
aggregates.CumeDistH[any,any]=
aggregates.PercentileCont[any,any]=
aggregates.PercentileDisc[any,any]=
aggregates.Median[any]=
aggregates.XMLAgg=
aggregates.Grouping[any]=
aggregates.ArrayAgg[any]=
aggregates.ArrayAgg[any,any]=
aggregates.Collect[any]=
aggregates.ApproxCountDistinct[any]=

#
# Aggregates (distinct).
#
aggregates.Max.distinct[any]=
aggregates.Min.distinct[any]=
aggregates.Sum.distinct[any]=
aggregates.Avg.distinct[any]=
aggregates.Count.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]=length(%1$s)
functions.OctetLength[any]=
functions.BitLength[any]=
functions.Upper[any]=toupper(%1$s)
functions.Lower[any]=tolower(%1$s)
functions.Substring[any,any]=substring(%1$s,%2$s)
functions.Substring[any,any,any]=substring(%1$s,%2$s,%3$s)
functions.Position[any,any]=indexof(%2$s,%1$s)
functions.Index[any,any]=indexof(%1$s,%2$s)
functions.Ascii[any]=
functions.Translate[any,any]=

#Substring function to negative START value to parse the input string from its rightmost end.
functions.SubstringR[any,any]=
functions.SubstringR[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]=ceiling(%1$s)
functions.Exp[any]=
functions.Floor[any]=floor(%1$s)
functions.Ln[any]=
functions.Log10[any]=
functions.Mod[any,any]=%1$s mod %2$s
functions.Power[any,any]=
functions.Random[]=
functions.Random[any]=
functions.Round[any]=round(%1$s)
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]=

#
# Trigonometric functions.
#
functions.Arccos[any]=
functions.Arcsin[any]=
functions.Arctan[any]=
functions.Cos[any]=
functions.Coshyp[any]=
functions.Sin[any]=
functions.Sinhyp[any]=
functions.Tan[any]=
functions.Tanhyp[any]=

#
# Datetime value functions.
#
functions.CurrentDate=
functions.CurrentTime=
functions.CurrentTimestamp=
functions.LocalTime=
functions.LocalTimestamp=
functions.CurrentTime[numeric]=
functions.CurrentTimestamp[numeric]=
functions.LocalTime[numeric]=
functions.LocalTimestamp[numeric]=

#
# XML functions.
#
functions.XMLAttributes=
functions.XMLComment=
functions.XMLConcat=
functions.XMLDocument=
functions.XMLElement=
functions.XMLExists=
functions.XMLForest=
functions.XMLParse=
functions.XMLPI=
functions.XMLNamespaces=
functions.XMLQuery=
functions.XMLSerialize=
functions.XMLTable=
functions.XMLText=
functions.XMLTransform=
functions.XMLValidate=

#
# JSON functions.
#
functions.JSONArray=
functions.JSONExists=
functions.JSONObject=
functions.JSONQuery=
functions.JSONTable=
functions.JSONValue=

#
# Business date functions.
#
functions.AddDays[interval_day_time,numeric]=
functions.AddDays[datetime,numeric]=
functions.AddMonths[interval_year_to_month,numeric]=
functions.AddMonths[datetime,numeric]=
functions.AddYears[interval_year_to_month,numeric]=
functions.AddYears[datetime,numeric]=
functions.DaysToEndOfMonth[datetime]=
functions.DaysBetween[datetime,datetime]=
functions.MonthsBetween[datetime,datetime]=
functions.YearsBetween[datetime,datetime]=
functions.Age[datetime]=
functions.FirstOfMonth[datetime]=
functions.LastOfMonth[datetime]=
functions.MakeTimestamp[numeric,numeric,numeric]=
functions.DayOfYear[datetime]=
functions.DayOfWeek[datetime,numeric]=
functions.WeekOfYear[datetime]=

#
# Mappings used for transformation purposes only.
#
functions.AddHours[interval_day_time,numeric]=
functions.AddHours[time,numeric]=
functions.AddHours[timestamp,numeric]=
functions.AddMinutes[interval_day_time,numeric]=
functions.AddMinutes[time,numeric]=
functions.AddMinutes[timestamp,numeric]=
functions.AddSeconds[interval_day_time,numeric]=
functions.AddSeconds[time,numeric]=
functions.AddSeconds[timestamp,numeric]=
functions.HoursBetween[datetime,datetime]=
functions.MinutesBetween[datetime,datetime]=
functions.SecondsBetween[datetime,datetime]=

#
# FDS functions.
#
functions.cast_smallint[any]=
functions.cast_integer[any]=
functions.cast_float[any]=
functions.cast_real[any]=
functions.cast_double[any]=
functions.cast_double_precision[any]=
functions.cast_decimal[any]=
functions.cast_decimal[any,any]=
functions.cast_decimal[any,any,any]=
functions.cast_numeric[any]=
functions.cast_numeric[any,any]=
functions.cast_numeric[any,any,any]=
functions.cast_date[any]=
functions.cast_time[any]=
functions.cast_timestamp[any]=
functions.cast_char[any]=
functions.cast_char[any,any]=
functions.cast_varchar[any]=
functions.cast_varchar[any,any]=

#
# Table functions.
#

#
# Literals.
#
literals.binary=true
literals.blob=false
literals.clob=false
literals.boolean=true
literals.date=false
literals.time=true
literals.time_with_time_zone=false
literals.timestamp=true
literals.timestamp_with_time_zone=true
literals.interval_day=false
literals.interval_day_to_hour=false
literals.interval_day_to_minute=false
literals.interval_day_to_second=false
literals.interval_hour=false
literals.interval_hour_to_minute=false
literals.interval_hour_to_second=false
literals.interval_minute=false
literals.interval_minute_to_second=false
literals.interval_second=false
literals.interval_year=false
literals.interval_year_to_month=false
literals.interval_month=false
literals.smallint=true
literals.integer=true
literals.long=true
literals.float=true
literals.double=true
literals.decimal=true
literals.char=true
literals.nchar=false
literals.varchar=true
literals.nvarchar=false
literals.xml=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. 
#
# 1 parameter (string)
literals.format.clob=
# colon separated values for TRUE, FALSE and UNKNOWN
literals.format.boolean=true:false
# 3 parameters (int year, int month, int day)
literals.format.date=
# 4 parameters (int hour, int minute, int seconds, string fractional seconds)
literals.format.time='%1$02d:%2$02d:%3$02d%4$.4s'
# 7 parameters (int hour, int minute, int seconds, string fractional seconds, int tz hour, int tz minute, char tz sign)
literals.format.time_with_time_zone=
# 7 parameters (int year, int month, int day, int hours, int minute, int seconds, string fractional seconds)
literals.format.timestamp=datetime'%1$04d-%2$02d-%3$02dT%4$02d:%5$02d:%6$02d%7$.10s'
# 10 parameters (int year, int month, int day, int hours, int minute, int seconds, string fractional seconds, int tz hour, int tz minute, char tz sign)
literals.format.timestamp_with_time_zone={ts '%1$04d-%2$02d-%3$02d %4$02d:%5$02d:%6$02d%7$.10s%10$c%8$02d:%9$02d'}
# 3 parameters (int day, int leading precision, char sign)
literals.format.interval_day=
# 4 parameters (int day, int hour, int leading precision, char sign)
literals.format.interval_day_to_hour=
# 5 parameters (int day, int hour, int minute, int leading precision, char sign)
literals.format.interval_day_to_minute=
# 8 parameters (int day, int hour, int minute, int seconds, string fractional seconds, int leading precision, int fractional precision, char sign)
literals.format.interval_day_to_second=
# 3 parameters (int hour, int leading precision, char sign)
literals.format.interval_hour=
# 4 parameters (int hour, int minute, int leading precision, char sign)
literals.format.interval_hour_to_minute=
# 7 parameters (int hour, int minute, int seconds, string fractional seconds, int leading precision, int fractional precision, char sign)
literals.format.interval_hour_to_second=
# 3 parameters (int minute, int leading precision, char sign)
literals.format.interval_minute=
# 6 parameters (int minute, int seconds, string fractional seconds, int leading precision, int fractional precision, char sign)
literals.format.interval_minute_to_second=
# 5 parameters (int seconds, string fractional seconds, int leading precision, int fractional precision, char sign)
literals.format.interval_second=
# 3 parameters (int year, int leading precision, char sign)
literals.format.interval_year=
# 4 parameters (int year, int month, int leading precision, char sign)
literals.format.interval_year_to_month=
# 3 parameters (int month, int leading precision, char sign)
literals.format.interval_month=
# 1 parameter (string)
literals.format.char='%s'
# 1 parameter (string)
literals.format.nchar=
# 1 parameter (string)
literals.format.varchar='%s'
# 1 parameter (string)
literals.format.nvarchar=

#
# Data types.
#
dataType.binary=true
dataType.blob=false
dataType.clob=false
dataType.boolean=true
dataType.date=false
dataType.time=true
dataType.time_with_time_zone=false
dataType.timestamp=true
dataType.timestamp_with_time_zone=true
dataType.interval_day=false
dataType.interval_day_to_hour=false
dataType.interval_day_to_minute=false
dataType.interval_day_to_second=false
dataType.interval_hour=false
dataType.interval_hour_to_minute=false
dataType.interval_hour_to_second=false
dataType.interval_minute=false
dataType.interval_minute_to_second=false
dataType.interval_second=false
dataType.interval_year=false
dataType.interval_year_to_month=false
dataType.interval_month=false
dataType.smallint=true
dataType.integer=true
dataType.long=true
dataType.float=true
dataType.double=true
dataType.decimal=true
dataType.char=true
dataType.nchar=false
dataType.varchar=true
dataType.nvarchar=false
dataType.xml=false
dataType.period=false

#
# 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=

#
# Support for SQL data types that are not defined in the JDBC 3.0 standard
# datasource.type.<datasource specific name>=CCL datatype name
# all spaces need to be replaced with an underscore (_)
#
datasource.type.string=varchar(2048)