analytics/configuration/xqe/sfdc.properties

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

#
# SFDC does not allows Sub queries and aliases and expressions in queries.
#
#
# Various features.
#
supports.duplicateColumnsInSelectList=false
supports.duplicateColumnNamesInSelectList=false
supports.columnAliasing=false
supports.tableCorrelationNames=true
supports.expressionsInOrderBy=false
supports.expressionsInINPredicate=false
supports.expressionsInSelectList=false
supports.likeEscapeClause=false
supports.outerJoins=false
supports.fullOuterJoins=false
supports.limitedOuterJoins=false
supports.subqueriesInComparisons=false
supports.subqueriesInExists=false
supports.subqueriesInIns=false
supports.subqueriesInQuantifieds=false
supports.subqueriesInOnClause=false
supports.correlatedSubqueries=false
supports.scalarSubqueries=false
supports.stitchJoins=false
supports.equiJoins=false
supports.thetaJoins=false
supports.crossProducts=false
supports.orderByAlias=false
supports.orderByName=true
supports.orderByOrdinal=false
supports.expressionsInGroupBy=false
supports.derivedColumnLists=false
supports.integerDivision=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
commands.Call=

#
# Tables.
#
tables.derived=false
tables.lateral.derived=false
tables.joined=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.comparison=false
constructors.row.in=false
constructors.row.isDistinctFrom=false
constructors.row.inListToTable=false
#


# Clauses.
#
clauses.From=FROM
clauses.Where=WHERE
clauses.GroupBy=GROUP BY
clauses.Having=HAVING
clauses.With=
clauses.OrderBy=ORDER BY
clauses.Distinct=
clauses.Top=
clauses.At=
clauses.Window=

clauses.WithRecursive=
clauses.TableSampleSystem=
clauses.TableSampleBernoulli=
clauses.ForSystemTimeAsOf=
clauses.ForSystemTimeFrom=
clauses.ForSystemTimeBetween=


#
# SFDC does not allows joins. But only some inner joins (those that can be translated to relationship queries)
# Joins.
#
joins.Cross=
joins.Inner=
joins.LeftOuter=
joins.RightOuter=
joins.FullOuter=

#
# SFDC Does not allows set operators in query.
# 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=(NOT(%1$s))
operators.logical.Is=
operators.logical.IsNot=
operators.logical.IsJson=
operators.logical.IsNotJson=

#
# Since expressions are not allowed by SFDC hence below are disabled.
# Arithmetic operators.
#
operators.arithmetic.Add=
operators.arithmetic.Subtract=
operators.arithmetic.Multiply=
operators.arithmetic.Divide=
operators.arithmetic.Negate=
operators.arithmetic.UnaryPlus=
operators.arithmetic.Concat=


#
# Arithmetic operators.
#
operators.arithmetic.Add[any,any]=
operators.arithmetic.Subtract[any,any]=
operators.arithmetic.Multiply[any,any]=
operators.arithmetic.Divide[any,any]=
operators.arithmetic.Negate[any]=
operators.arithmetic.UnaryPlus[any]=
operators.arithmetic.Concat[any,any]=

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

#
# Various predicates.
#
predicates.In=%1$s IN ( %2$s )
predicates.Overlaps[any,any,any,any]=
predicates.IsNull=%1$s = NULL
predicates.IsNotNull=%1$s != NULL
predicates.Like=%1$s LIKE %2$s
predicates.Like.escape=
predicates.LikeRegex=
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.SearchedCase=
expressions.SimpleCase=
# NULLIF(%1$s, %2$s) is equivalent to CASE WHEN %1$s = %2$s THEN NULL ELSE %1$s END
expressions.NullIf=
expressions.Coalesce=
expressions.SearchedCase.compatibleResults=

#
# CAST Function ot supported by SFDC.
# Cast expression.
#
expressions.Cast[any,any]=
expressions.Cast[any,any,any]=


#
# Delimiters.
#
delimiters.tableDelimiter="
delimiters.columnDelimiter=
delimiters.searchStringEscape=


#
# Max columns in Group by and Order By can be 32.
# Max statement length of SFDC Query can be 1000 characters.
# Various limits.
#
limits.maxColumnsInGroupby=32
limits.maxColumnsInOrderBy=32
limits.maxStatementLength=10000


#
# Extract expression.
#
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.TIMEZONE_HOUR[any]=
expressions.Extract.TIMEZONE_MINUTE[any]=
expressions.Extract.EPOCH[any]=

#
# Trim expression.
#
expressions.Trim.BOTH[any]=
expressions.Trim.LEADING[any]=
expressions.Trim.TRAILING[any]=
expressions.Trim.BOTH[any,any]=
expressions.Trim.LEADING[any,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.PercentRank[]=
olap.CumeDist[]=
olap.PercentileCont[any,any]=
olap.PercentileDisc[any,any]=
olap.Median[any]=
olap.RatioToReport[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= 

# 
# 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.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.CumeDist[any,any]=
aggregates.PercentileCont[any,any]=
aggregates.PercentileDisc[any,any]=
aggregates.Median[any]=
aggregates.XMLAgg=
aggregates.Grouping[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]=

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

#
# 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.Round[any]=
functions.Round[any,any]=
functions.Round[any,any,any]=
functions.Sign[any]=
functions.Sqrt[any]=
functions.WidthBucket[any,any,any,any]=
functions.Random[]=
functions.Random[any]=


functions.Translate[any,any]=
functions.Normalize[any]= 
functions.Normalize[any,any]= 
functions.Normalize[any,any,any]= 


functions.SubstringR[any,any]=
functions.SubstringR[any,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]=
functions.SecondsBetween[any,any]=
functions.MinutesBetween[any,any]=
functions.HoursBetween[any,any]=

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


#
# Business date functions.
#
functions.AddDays[any,any]=
functions.AddMonths[any,any]=
functions.AddYears[any,any]=
functions.Age[any]=
functions.DayOfWeek[any,any]=
functions.DayOfYear[any]=
functions.DaysBetween[any,any]=
functions.DaysToEndOfMonth[any]=
functions.FirstOfMonth[any]=
functions.LastOfMonth[any]=
functions.MakeTimestamp[any,any,any]=
functions.MonthsBetween[any,any]=
functions.WeekOfYear[any]=
functions.YearsBetween[any,any]=
functions.YMDIntBetween[any,any]=


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

#
# Regular expression functions.
#
functions.SubstringRegex[any,any,any,any,any]=
functions.OccurrencesRegex[any,any,any,any]=
functions.PositionRegex[any,any,any,any,any,any]=

# 
# Array scalar functions
# 

functions.Cardinality[any]=
functions.TrimArray[any,any]=

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

functions.AddHours[any,any]=
functions.AddMinutes[any,any]=
functions.AddSeconds[any,any]=
functions.AddFractionalSeconds[any,any]=
functions.AddWeeks[any,any]=
functions.AddMonths[any,any]=
functions.AddQuarters[any,any]=
functions.Age[any]=
functions.FractionalSecondsBetween[any,any]=
functions.DaysBetween[any,any]=
functions.WeeksBetween[any,any]=
functions.MonthsBetween[any,any]=
functions.QuartersBetween[any,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.binary=false
literals.blob=false
literals.clob=false
literals.boolean=true
literals.date=true
literals.time=true
literals.time_with_time_zone=false
literals.timestamp=false
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=true
literals.varchar=true
literals.nvarchar=true
literals.xml=false

#
# Data types.
#
dataType.binary=false
dataType.blob=false
dataType.clob=false
dataType.boolean=true
dataType.date=true
dataType.time=true
dataType.time_with_time_zone=false
dataType.timestamp=false
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=true
dataType.varchar=true
dataType.nvarchar=true
dataType.xml=true
dataType.period=true