analytics/configuration/xqe/siebel.properties

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

# This properties file contains configuration attributes for Siebel.
# This file only overrides sql.properties.
# Use beyond compare to see content of both files.
#

#
# Product information.
#

#
# Delimiters, change as needed.
#
delimiters.catalogDelimiter="
delimiters.schemaDelimiter="
delimiters.tableDelimiter="
delimiters.columnDelimiter="

#
# Various limits.
#

#
# General settings.
#
general.nullsOrdering=false
general.nullsOrderingInWindowSpecification=false

#
# Various features.
#
supports.columnAliasing=false
supports.tableCorrelationNames=false
supports.expressionsInINPredicate=false
supports.expressionsInSelectList=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.correlatedSubqueries=false
supports.transactions=false
supports.withClauseInDerivedTable=false
supports.integerDivision=false
supports.derivedColumnLists=false
supports.orderByAlias=false
supports.orderByOrdinal=false
supports.orderByName=true
supports.scalarSubqueries=false
supports.charLiteralRoundTrip=false
supports.stitchJoins=false
supports.expressionsInGroupBy=false
supports.equiJoins=false
supports.thetaJoins=false
supports.crossProducts=false

#
# Grouping query optimization 
#
# Command.
#
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

#
# Clauses.
#
clauses.GroupBy=
clauses.Having=
clauses.With=
clauses.Distinct=
clauses.Top=
clauses.At=
clauses.Window=

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

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

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

#
# Comparison predicates.
#

#
# Various predicates.
#
predicates.Overlaps=
predicates.Like.escape=
predicates.LikeRegex=
predicates.Similar=
predicates.Similar.escape=
predicates.Exists=
predicates.All=
predicates.Any=
predicates.Some=
predicates.IsDistinctFrom=
predicates.IsNotDistinctFrom=

#Siebel supports LIKE expression.
#In Siebel a multi character match is obtained using * as the wild card character.
#In other words an % in LIKE clause needs to be pushed down as *
#In siebel Like pattern needs to be quoted as 'A'
#In Siebel a single character match is obtained using ? as the wild card character.
#In other words an _ in LIKE clause needs to be pushed down as ?

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

#
# Cast expression.
#
expressions.Cast[any,any]=

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

#
# 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=
olap.Min=
olap.Sum=
olap.Avg=
olap.Count=
olap.CountStar=
olap.StdDevSamp=
olap.StdDevPop=
olap.VarSamp=
olap.VarPop=
olap.Rank=
olap.DenseRank=
olap.PercentRank=
olap.CumeDist=
olap.PercentileCont=
olap.PercentileDisc=
olap.RowNumber=
olap.FirstValue=
olap.Lag[any]=
olap.Lag[any,any]=
olap.Lag[any,any,any]=
olap.Lag[any,any,any,any]=
olap.LastValue=
olap.Lead[any]=
olap.Lead[any,any]=
olap.Lead[any,any,any]=
olap.Lead[any,any,any,any]=
olap.NTile=
olap.NthValue[any,any]=
olap.NthValue[any,any,any]=
olap.NthValue[any,any,any,any]=
olap.Tertile=
olap.RatioToReport=
olap.Difference=

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

#
# Window specification
# A list of windows specifications that are supported by the DB
# P = PARTITION BY
# O = ORDER BY
# F = FRAME 
#
olap.Window.Specification[POF]=false
olap.Window.Specification[PO]=false
olap.Window.Specification[OF]=false
olap.Window.Specification[PF]=false
olap.Window.Specification[P]=false
olap.Window.Specification[O]=false
olap.Window.Specification[F]=false
olap.Window.Specification[]=false

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

#
# Aggregates.
#
aggregates.Max=
aggregates.Min=
aggregates.Sum[any]=
aggregates.Avg[any]=
aggregates.Count=
aggregates.CountStar=
aggregates.StdDevSamp=
aggregates.StdDevPop=
aggregates.VarSamp=
aggregates.VarPop=
aggregates.Rank=
aggregates.DenseRank=
aggregates.PercentRank=
aggregates.CumeDist=
aggregates.PercentileCont=
aggregates.PercentileDisc=
aggregates.XMLAgg=
aggregates.Grouping=

#
# Aggregates (distinct).
#
aggregates.Max.distinct=
aggregates.Min.distinct=
aggregates.Sum.distinct=
aggregates.Avg.distinct=
aggregates.Count.distinct=

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

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

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

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

#
# Literals.
#
literals.time_with_time_zone=false
literals.timestamp_with_time_zone=false
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.nchar=false
literals.nvarchar=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. 
# 3 parameters (int year, int month, int day) 
# 'MM/dd/yyyy'
literals.format.date='%2$02d/%3$02d/%1$04d'
# 4 parameters (int hour, int minute, int seconds, string fractional seconds)
# 'HH:mm:ss'
literals.format.time='%1$02d:%2$02d:%3$02d'
# 7 parameters (int year, int month, int day, int hours, int minute, int seconds, string fractional seconds)
# 'MM/dd/yyyy HH:mm:ss'
literals.format.timestamp='%2$02d/%3$02d/%1$04d %4$02d:%5$02d:%6$02d'

#
# Data types.
#
dataType.binary=false
dataType.blob=false
dataType.clob=false
dataType.boolean=false
dataType.time_with_time_zone=false
dataType.timestamp_with_time_zone=false
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.nchar=false
dataType.nvarchar=false
dataType.xml=false
dataType.period=false