# 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