# 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