# Licensed Materials - Property of IBM # IBM Cognos Products: OQP # (C) Copyright IBM Corp. 2005, 2018 # 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.callProcedureInDerivedTable=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 # # Clauses. # clauses.GroupBy=GROUP BY clauses.Having= clauses.With= clauses.Top= clauses.At= clauses.Window= clauses.ForSystemTimeAsOf= clauses.ForSystemTimeFrom= clauses.ForSystemTimeBetween= # # Joins. # joins.Cross= 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=%1$s && %2$s operators.logical.Or=%1$s || %2$s operators.logical.Not=!( %1$s ) # # Arithmetic operators. # operators.arithmetic.Concat[any,any]= # # Group By Operators # operators.groupBy.Rollup= operators.groupBy.Cube= operators.groupBy.GroupingSets= # # Comparison predicates. # # # Various predicates. # predicates.Between[any,any,any]= predicates.In[any,any]= predicates.Overlaps[any,any,any,any]= predicates.IsNull=!BOUND(%1$s) predicates.IsNotNull=BOUND(%1$s) predicates.Like.escape= predicates.LikeRegex=REGEXP(%1$s, %2$s) predicates.LikeRegex.flag= predicates.Similar= predicates.Similar.escape= predicates.Exists= predicates.All= predicates.Any= predicates.Some= predicates.IsDistinctFrom[any,any]=%1$s <> %2$s && BOUND(%1$s) && BOUND(%2$s) predicates.IsNotDistinctFrom[any,any]=%1$s = %2$s || (!BOUND(%1$s) && !BOUND(%2$s)) # # 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]= 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.EPOCH[any]= # # Trim expression. # expressions.Trim.BOTH[text]= 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]= # # 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.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.ApproxCountDistinct[any]= # # Aggregates (distinct). # # # 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[text]= functions.CharLength[clob]= functions.OctetLength[text]= functions.BitLength[text]= functions.Upper[clob]= functions.Lower[clob]= functions.Substring[text,numeric,numeric]= functions.Substring[clob,numeric,numeric]= functions.Position[text,text]= functions.Position[text,clob]= functions.Index[text,text]= functions.Index[clob,text]= functions.Ascii[numeric]= functions.Translate[text,text,text]= # # 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.Mod[numeric,numeric]= functions.Round[numeric,numeric]= functions.Round[numeric,numeric,numeric]= functions.Sign[numeric]= functions.WidthBucket[numeric,numeric,numeric,numeric]= # # Trigonometric functions. # functions.Arctan[numeric]= functions.Coshyp[numeric]= functions.Sinhyp[numeric]= functions.Tan[numeric]= functions.Tanhyp[numeric]= # # 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_month,numeric]= functions.AddMonths[datetime,numeric]= functions.AddYears[interval_year_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[intervaldt,numeric]= functions.AddHours[time,numeric]= functions.AddHours[timestamp,numeric]= functions.AddMinutes[intervaldt,numeric]= functions.AddMinutes[time,numeric]= functions.AddMinutes[timestamp,numeric]= functions.AddSeconds[intervaldt,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]= # # Literals. # literals.binary=false literals.blob=false literals.clob=false literals.boolean=false literals.date=true literals.time=true literals.time_with_time_zone=true literals.timestamp=true literals.timestamp_with_time_zone=true literals.interval_day=true literals.interval_day_to_hour=true literals.interval_day_to_minute=true literals.interval_day_to_second=true literals.interval_hour=true literals.interval_hour_to_minute=true literals.interval_hour_to_second=true literals.interval_minute=true literals.interval_minute_to_second=true literals.interval_second=true literals.interval_year=true literals.interval_year_to_month=true literals.interval_month=true 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 # # 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='%s' # colon separated values for TRUE, FALSE and UNKNOWN literals.format.boolean=TRUE:FALSE:UNKOWN # 3 parameters (int year, int month, int day) literals.format.date={d '%1$04d-%2$02d-%3$02d'} # 4 parameters (int hour, int minute, int seconds, string fractional seconds) literals.format.time={t '%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={t '%1$02d:%2$02d:%3$02d%4$.4s%7$c%5$02d:%6$02d'} # 7 parameters (int year, int month, int day, int hours, int minute, int seconds, string fractional seconds) literals.format.timestamp={ts '%1$04d-%2$02d-%3$02d %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=INTERVAL %3$s'%1$d' DAY(%2$d) # 4 parameters (int day, int hour, int leading precision, char sign) literals.format.interval_day_to_hour=INTERVAL %4$s'%1$d %2$02d' DAY(%3$d) TO HOUR # 5 parameters (int day, int hour, int minute, int leading precision, char sign) literals.format.interval_day_to_minute=INTERVAL %5$s'%1$d %2$02d:%3$02d' DAY(%4$d) 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=INTERVAL %8$s'%1$d %2$02d:%3$02d:%4$02d%5$.10s' DAY(%6$d) TO SECOND(%7$d) # 3 parameters (int hour, int leading precision, char sign) literals.format.interval_hour=INTERVAL %3$s'%1$d' HOUR(%2$d) # 4 parameters (int hour, int minute, int leading precision, char sign) literals.format.interval_hour_to_minute=INTERVAL %4$s'%1$d:%2$02d' HOUR(%3$d) 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=INTERVAL %7$s'%1$d:%2$02d:%3$02d%4$.10s' HOUR(%5$d) TO SECOND(%6$d) # 3 parameters (int minute, int leading precision, char sign) literals.format.interval_minute=INTERVAL %3$s'%1$d' MINUTE(%2$d) # 6 parameters (int minute, int seconds, string fractional seconds, int leading precision, int fractional precision, char sign) literals.format.interval_minute_to_second=INTERVAL %6$s'%1$d:%2$02d%3$.10s' MINUTE(%4$d) TO SECOND(%5$d) # 5 parameters (int seconds, string fractional seconds, int leading precision, int fractional precision, char sign) literals.format.interval_second=INTERVAL %5$s'%1$02d%2$.10s' SECOND(%3$d,%4$d) # 3 parameters (int year, int leading precision, char sign) literals.format.interval_year=INTERVAL %3$s'%1$d' YEAR(%2$d) # 4 parameters (int year, int month, int leading precision, char sign) literals.format.interval_year_to_month=INTERVAL %4$s'%1$d-%2$02d' YEAR(%3$d) TO MONTH # 3 parameters (int month, int leading precision, char sign) literals.format.interval_month=INTERVAL %3$s'%1$d' MONTH(%2$d) # 1 parameter (string) literals.format.char='%s' # 1 parameter (string) literals.format.nchar=N'%s' # 1 parameter (string) literals.format.varchar='%s' # 1 parameter (string) literals.format.nvarchar=N'%s' # # Data types. # dataType.binary=true dataType.blob=true dataType.clob=true dataType.boolean=true dataType.date=true dataType.time=true dataType.time_with_time_zone=true dataType.timestamp=true dataType.timestamp_with_time_zone=true dataType.interval_day=true dataType.interval_day_to_hour=true dataType.interval_day_to_minute=true dataType.interval_day_to_second=true dataType.interval_hour=true dataType.interval_hour_to_minute=true dataType.interval_hour_to_second=true dataType.interval_minute=true dataType.interval_minute_to_second=true dataType.interval_second=true dataType.interval_year=true dataType.interval_year_to_month=true dataType.interval_month=true 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=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.=CCL datatype name # all spaces need to be replaced with an underscore (_) # datasource.type.string=varchar(2048)