# Licensed Materials - Property of IBM # IBM Cognos Products: XQE # (C) Copyright IBM Corp. 2009, 2021 # US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. # # General settings. # general.nullsAreSortedHigh=false general.nullsAreSortedLow=false general.nullsAreSortedAtStart=false general.nullsAreSortedAtEnd=false general.nullsOrdering=false # # Various features. # supports.duplicateColumnsInSelectList=true supports.columnAliasing=false supports.tableCorrelationNames=false 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.subqueriesInCase=false supports.correlatedSubqueries=false supports.transactions=false supports.withClauseInDerivedTable=false supports.integerDivision=false supports.nestedOlap=false supports.derivedColumnLists=false supports.orderByAlias=false supports.orderByName=false supports.orderByOrdinal=false supports.orderByUnrelated=false supports.blobsInGroupBy=false supports.blobsInOrderBy=false supports.scalarSubqueries=false supports.charLiteralRoundTrip=true supports.crossProducts=false supports.implicitTypeConversion=false supports.orderByUnrelated=false supports.groupByUnrelated=false supports.schemasInDataManipulation=true #classic stack compatibility supports.nonStandardDatetimeComparison=false supports.multipleDistinctAggregates=false supports.hints=false supports.rowNumberNoOrderBy=false supports.sqlserverWindowBehaviour=false supports.literalsInSelectList=false supports.join.subqueriesInOnClause=false # Indicates whether inner joins require at least one equijoin predicate. # A INNER JOIN B ON A.C1 = B.C1 AND A.C2 > B.C2 is fine, but A INNER JOIN B ON A.C2 > B.C2 is not. supports.join.inner.limitedThetaJoins=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=CALL # # Tables. # tables.derived=false tables.joined=false # # Constructors. # constructors.table=false constructors.row=false # # Clauses. # clauses.From=FROM clauses.Where=WHERE clauses.GroupBy= clauses.Having= clauses.With= clauses.OrderBy= clauses.Distinct= clauses.Top= clauses.At= clauses.Window= # # Joins. # joins.Cross= joins.Inner= joins.LeftOuter= joins.RightOuter= joins.FullOuter= joins.RightNested= # # 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= operators.logical.Or= operators.logical.Not= # # 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.Concat[any,any]= # # Group By Operators # operators.groupBy.Rollup= operators.groupBy.Cube= operators.groupBy.GroupingSets= # # Comparison predicates. # predicates.comparison.LessThan[any,any]= predicates.comparison.LessThanOrEquals[any,any]= predicates.comparison.Equals[any,any]= predicates.comparison.NotEquals[any,any]= predicates.comparison.GreaterThan[any,any]= predicates.comparison.GreaterThanOrEquals[any,any]= predicates.comparison.In[any]= predicates.comparison.Overlaps[any,any,any,any]= # # Various predicates. # predicates.Between[any,any,any]= predicates.IsNull= predicates.IsNotNull= predicates.Like= predicates.Like.escape= predicates.Exists= predicates.All= predicates.Any= predicates.Some= predicates.IsDistinctFrom[any,any]= predicates.IsNotDistinctFrom[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= # # Cast expression. # turn off ALL combinations and overrides. # expressions.Cast[any,any]= expressions.Cast[binary,binary]= expressions.Cast[blob,blob]= expressions.Cast[clob,binary]= expressions.Cast[clob,clob]= expressions.Cast[clob,boolean]= expressions.Cast[clob,date]= expressions.Cast[clob,time]= expressions.Cast[clob,time_with_time_zone]= expressions.Cast[clob,timestamp]= expressions.Cast[clob,timestamp_with_time_zone]= expressions.Cast[clob,interval_day]= expressions.Cast[clob,interval_day_to_hour]= expressions.Cast[clob,interval_day_to_minute]= expressions.Cast[clob,interval_day_to_second]= expressions.Cast[clob,interval_hour]= expressions.Cast[clob,interval_hour_to_minute]= expressions.Cast[clob,interval_hour_to_second]= expressions.Cast[clob,interval_minute]= expressions.Cast[clob,interval_minute_to_second]= expressions.Cast[clob,interval_second]= expressions.Cast[clob,interval_year]= expressions.Cast[clob,interval_year_to_month]= expressions.Cast[clob,interval_month]= expressions.Cast[clob,decimal]= expressions.Cast[clob,double]= expressions.Cast[clob,float]= expressions.Cast[clob,float]= expressions.Cast[clob,integer]= expressions.Cast[clob,long]= expressions.Cast[clob,smallint]= expressions.Cast[clob,char]= expressions.Cast[clob,nchar]= expressions.Cast[clob,nvarchar]= expressions.Cast[clob,varchar]= expressions.Cast[clob,xml]= expressions.Cast[boolean,boolean]= expressions.Cast[date,clob]= expressions.Cast[date,date]= expressions.Cast[date,timestamp]= expressions.Cast[date,timestamp_with_time_zone]= expressions.Cast[date,char]= expressions.Cast[date,nchar]= expressions.Cast[date,nvarchar]= expressions.Cast[date,varchar]= expressions.Cast[time,clob]= expressions.Cast[time,time]= expressions.Cast[time,time_with_time_zone]= expressions.Cast[time,timestamp]= expressions.Cast[time,timestamp_with_time_zone]= expressions.Cast[time,char]= expressions.Cast[time,nchar]= expressions.Cast[time,nvarchar]= expressions.Cast[time,varchar]= expressions.Cast[time_with_time_zone,clob]= expressions.Cast[time_with_time_zone,time]= expressions.Cast[time_with_time_zone,time_with_time_zone]= expressions.Cast[time_with_time_zone,timestamp]= expressions.Cast[time_with_time_zone,timestamp_with_time_zone]= expressions.Cast[time_with_time_zone,char]= expressions.Cast[time_with_time_zone,nchar]= expressions.Cast[time_with_time_zone,nvarchar]= expressions.Cast[time_with_time_zone,varchar]= expressions.Cast[timestamp,clob]= expressions.Cast[timestamp,date]= expressions.Cast[timestamp,time]= expressions.Cast[timestamp,time_with_time_zone]= expressions.Cast[timestamp,timestamp]= expressions.Cast[timestamp,timestamp_with_time_zone]= expressions.Cast[timestamp,char]= expressions.Cast[timestamp,nchar]= expressions.Cast[timestamp,nvarchar]= expressions.Cast[timestamp,varchar]= expressions.Cast[timestamp_with_time_zone,clob]= expressions.Cast[timestamp_with_time_zone,date]= expressions.Cast[timestamp_with_time_zone,time]= expressions.Cast[timestamp_with_time_zone,time_with_time_zone]= expressions.Cast[timestamp_with_time_zone,timestamp]= expressions.Cast[timestamp_with_time_zone,timestamp_with_time_zone]= expressions.Cast[timestamp_with_time_zone,char]= expressions.Cast[timestamp_with_time_zone,nchar]= expressions.Cast[timestamp_with_time_zone,nvarchar]= expressions.Cast[timestamp_with_time_zone,varchar]= expressions.Cast[interval_day,clob]= expressions.Cast[interval_day,interval_day]= expressions.Cast[interval_day,interval_day_to_hour]= expressions.Cast[interval_day,interval_day_to_minute]= expressions.Cast[interval_day,interval_day_to_second]= expressions.Cast[interval_day,interval_hour]= expressions.Cast[interval_day,interval_hour_to_minute]= expressions.Cast[interval_day,interval_hour_to_second]= expressions.Cast[interval_day,interval_minute]= expressions.Cast[interval_day,interval_minute_to_second]= expressions.Cast[interval_day,interval_second]= expressions.Cast[interval_day,decimal]= expressions.Cast[interval_day,integer]= expressions.Cast[interval_day,long]= expressions.Cast[interval_day,smallint]= expressions.Cast[interval_day,char]= expressions.Cast[interval_day,nchar]= expressions.Cast[interval_day,nvarchar]= expressions.Cast[interval_day,varchar]= expressions.Cast[interval_day_to_hour,clob]= expressions.Cast[interval_day_to_hour,interval_day]= expressions.Cast[interval_day_to_hour,interval_day_to_hour]= expressions.Cast[interval_day_to_hour,interval_day_to_minute]= expressions.Cast[interval_day_to_hour,interval_day_to_second]= expressions.Cast[interval_day_to_hour,interval_hour]= expressions.Cast[interval_day_to_hour,interval_hour_to_minute]= expressions.Cast[interval_day_to_hour,interval_hour_to_second]= expressions.Cast[interval_day_to_hour,interval_minute]= expressions.Cast[interval_day_to_hour,interval_minute_to_second]= expressions.Cast[interval_day_to_hour,interval_second]= expressions.Cast[interval_day_to_hour,char]= expressions.Cast[interval_day_to_hour,nchar]= expressions.Cast[interval_day_to_hour,nvarchar]= expressions.Cast[interval_day_to_hour,varchar]= expressions.Cast[interval_day_to_minute,clob]= expressions.Cast[interval_day_to_minute,interval_day]= expressions.Cast[interval_day_to_minute,interval_day_to_hour]= expressions.Cast[interval_day_to_minute,interval_day_to_minute]= expressions.Cast[interval_day_to_minute,interval_day_to_second]= expressions.Cast[interval_day_to_minute,interval_hour]= expressions.Cast[interval_day_to_minute,interval_hour_to_minute]= expressions.Cast[interval_day_to_minute,interval_hour_to_second]= expressions.Cast[interval_day_to_minute,interval_minute]= expressions.Cast[interval_day_to_minute,interval_minute_to_second]= expressions.Cast[interval_day_to_minute,interval_second]= expressions.Cast[interval_day_to_minute,char]= expressions.Cast[interval_day_to_minute,nchar]= expressions.Cast[interval_day_to_minute,nvarchar]= expressions.Cast[interval_day_to_minute,varchar]= expressions.Cast[interval_day_to_second,clob]= expressions.Cast[interval_day_to_second,interval_day]= expressions.Cast[interval_day_to_second,interval_day_to_hour]= expressions.Cast[interval_day_to_second,interval_day_to_minute]= expressions.Cast[interval_day_to_second,interval_day_to_second]= expressions.Cast[interval_day_to_second,interval_hour]= expressions.Cast[interval_day_to_second,interval_hour_to_minute]= expressions.Cast[interval_day_to_second,interval_hour_to_second]= expressions.Cast[interval_day_to_second,interval_minute]= expressions.Cast[interval_day_to_second,interval_minute_to_second]= expressions.Cast[interval_day_to_second,interval_second]= expressions.Cast[interval_day_to_second,char]= expressions.Cast[interval_day_to_second,nchar]= expressions.Cast[interval_day_to_second,nvarchar]= expressions.Cast[interval_day_to_second,varchar]= expressions.Cast[interval_hour,clob]= expressions.Cast[interval_hour,interval_day]= expressions.Cast[interval_hour,interval_day_to_hour]= expressions.Cast[interval_hour,interval_day_to_minute]= expressions.Cast[interval_hour,interval_day_to_second]= expressions.Cast[interval_hour,interval_hour]= expressions.Cast[interval_hour,interval_hour_to_minute]= expressions.Cast[interval_hour,interval_hour_to_second]= expressions.Cast[interval_hour,interval_minute]= expressions.Cast[interval_hour,interval_minute_to_second]= expressions.Cast[interval_hour,interval_second]= expressions.Cast[interval_hour,decimal]= expressions.Cast[interval_hour,integer]= expressions.Cast[interval_hour,long]= expressions.Cast[interval_hour,smallint]= expressions.Cast[interval_hour,char]= expressions.Cast[interval_hour,nchar]= expressions.Cast[interval_hour,nvarchar]= expressions.Cast[interval_hour,varchar]= expressions.Cast[interval_hour_to_minute,clob]= expressions.Cast[interval_hour_to_minute,interval_day]= expressions.Cast[interval_hour_to_minute,interval_day_to_hour]= expressions.Cast[interval_hour_to_minute,interval_day_to_minute]= expressions.Cast[interval_hour_to_minute,interval_day_to_second]= expressions.Cast[interval_hour_to_minute,interval_hour]= expressions.Cast[interval_hour_to_minute,interval_hour_to_minute]= expressions.Cast[interval_hour_to_minute,interval_hour_to_second]= expressions.Cast[interval_hour_to_minute,interval_minute]= expressions.Cast[interval_hour_to_minute,interval_minute_to_second]= expressions.Cast[interval_hour_to_minute,interval_second]= expressions.Cast[interval_hour_to_minute,char]= expressions.Cast[interval_hour_to_minute,nchar]= expressions.Cast[interval_hour_to_minute,nvarchar]= expressions.Cast[interval_hour_to_minute,varchar]= expressions.Cast[interval_hour_to_second,clob]= expressions.Cast[interval_hour_to_second,interval_day]= expressions.Cast[interval_hour_to_second,interval_day_to_hour]= expressions.Cast[interval_hour_to_second,interval_day_to_minute]= expressions.Cast[interval_hour_to_second,interval_day_to_second]= expressions.Cast[interval_hour_to_second,interval_hour]= expressions.Cast[interval_hour_to_second,interval_hour_to_minute]= expressions.Cast[interval_hour_to_second,interval_hour_to_second]= expressions.Cast[interval_hour_to_second,interval_minute]= expressions.Cast[interval_hour_to_second,interval_minute_to_second]= expressions.Cast[interval_hour_to_second,interval_second]= expressions.Cast[interval_hour_to_second,char]= expressions.Cast[interval_hour_to_second,nchar]= expressions.Cast[interval_hour_to_second,nvarchar]= expressions.Cast[interval_hour_to_second,varchar]= expressions.Cast[interval_minute,clob]= expressions.Cast[interval_minute,interval_day]= expressions.Cast[interval_minute,interval_day_to_hour]= expressions.Cast[interval_minute,interval_day_to_minute]= expressions.Cast[interval_minute,interval_day_to_second]= expressions.Cast[interval_minute,interval_hour]= expressions.Cast[interval_minute,interval_hour_to_minute]= expressions.Cast[interval_minute,interval_hour_to_second]= expressions.Cast[interval_minute,interval_minute]= expressions.Cast[interval_minute,interval_minute_to_second]= expressions.Cast[interval_minute,interval_second]= expressions.Cast[interval_minute,decimal]= expressions.Cast[interval_minute,integer]= expressions.Cast[interval_minute,long]= expressions.Cast[interval_minute,smallint]= expressions.Cast[interval_minute,char]= expressions.Cast[interval_minute,nchar]= expressions.Cast[interval_minute,nvarchar]= expressions.Cast[interval_minute,varchar]= expressions.Cast[interval_minute_to_second,clob]= expressions.Cast[interval_minute_to_second,interval_day]= expressions.Cast[interval_minute_to_second,interval_day_to_hour]= expressions.Cast[interval_minute_to_second,interval_day_to_minute]= expressions.Cast[interval_minute_to_second,interval_day_to_second]= expressions.Cast[interval_minute_to_second,interval_hour]= expressions.Cast[interval_minute_to_second,interval_hour_to_minute]= expressions.Cast[interval_minute_to_second,interval_hour_to_second]= expressions.Cast[interval_minute_to_second,interval_minute]= expressions.Cast[interval_minute_to_second,interval_minute_to_second]= expressions.Cast[interval_minute_to_second,interval_second]= expressions.Cast[interval_minute_to_second,char]= expressions.Cast[interval_minute_to_second,nchar]= expressions.Cast[interval_minute_to_second,nvarchar]= expressions.Cast[interval_minute_to_second,varchar]= expressions.Cast[interval_second,clob]= expressions.Cast[interval_second,interval_day]= expressions.Cast[interval_second,interval_day_to_hour]= expressions.Cast[interval_second,interval_day_to_minute]= expressions.Cast[interval_second,interval_day_to_second]= expressions.Cast[interval_second,interval_hour]= expressions.Cast[interval_second,interval_hour_to_minute]= expressions.Cast[interval_second,interval_hour_to_second]= expressions.Cast[interval_second,interval_minute]= expressions.Cast[interval_second,interval_minute_to_second]= expressions.Cast[interval_second,interval_second]= expressions.Cast[interval_second,decimal]= expressions.Cast[interval_second,integer]= expressions.Cast[interval_second,long]= expressions.Cast[interval_second,smallint]= expressions.Cast[interval_second,char]= expressions.Cast[interval_second,nchar]= expressions.Cast[interval_second,nvarchar]= expressions.Cast[interval_second,varchar]= expressions.Cast[interval_year,clob]= expressions.Cast[interval_year,interval_year]= expressions.Cast[interval_year,interval_year_to_month]= expressions.Cast[interval_year,interval_month]= expressions.Cast[interval_year,decimal]= expressions.Cast[interval_year,integer]= expressions.Cast[interval_year,long]= expressions.Cast[interval_year,smallint]= expressions.Cast[interval_year,char]= expressions.Cast[interval_year,nchar]= expressions.Cast[interval_year,nvarchar]= expressions.Cast[interval_year,varchar]= expressions.Cast[interval_year_to_month,clob]= expressions.Cast[interval_year_to_month,interval_year]= expressions.Cast[interval_year_to_month,interval_year_to_month]= expressions.Cast[interval_year_to_month,interval_month]= expressions.Cast[interval_year_to_month,char]= expressions.Cast[interval_year_to_month,nchar]= expressions.Cast[interval_year_to_month,nvarchar]= expressions.Cast[interval_year_to_month,varchar]= expressions.Cast[interval_month,clob]= expressions.Cast[interval_month,interval_year]= expressions.Cast[interval_month,interval_year_to_month]= expressions.Cast[interval_month,interval_month]= expressions.Cast[interval_month,decimal]= expressions.Cast[interval_month,integer]= expressions.Cast[interval_month,long]= expressions.Cast[interval_month,smallint]= expressions.Cast[interval_month,char]= expressions.Cast[interval_month,nchar]= expressions.Cast[interval_month,nvarchar]= expressions.Cast[interval_month,varchar]= expressions.Cast[decimal,clob]= expressions.Cast[decimal,interval_day]= expressions.Cast[decimal,interval_hour]= expressions.Cast[decimal,interval_minute]= expressions.Cast[decimal,interval_second]= expressions.Cast[decimal,interval_year]= expressions.Cast[decimal,interval_month]= expressions.Cast[decimal,decimal]= expressions.Cast[decimal,double]= expressions.Cast[decimal,float]= expressions.Cast[decimal,float]= expressions.Cast[decimal,integer]= expressions.Cast[decimal,long]= expressions.Cast[decimal,smallint]= expressions.Cast[decimal,char]= expressions.Cast[decimal,nchar]= expressions.Cast[decimal,nvarchar]= expressions.Cast[decimal,varchar]= expressions.Cast[double,clob]= expressions.Cast[double,decimal]= expressions.Cast[double,double]= expressions.Cast[double,float]= expressions.Cast[double,float]= expressions.Cast[double,integer]= expressions.Cast[double,long]= expressions.Cast[double,smallint]= expressions.Cast[double,char]= expressions.Cast[double,nchar]= expressions.Cast[double,nvarchar]= expressions.Cast[double,varchar]= expressions.Cast[float,clob]= expressions.Cast[float,decimal]= expressions.Cast[float,double]= expressions.Cast[float,float]= expressions.Cast[float,float]= expressions.Cast[float,integer]= expressions.Cast[float,long]= expressions.Cast[float,smallint]= expressions.Cast[float,char]= expressions.Cast[float,nchar]= expressions.Cast[float,nvarchar]= expressions.Cast[float,varchar]= expressions.Cast[integer,clob]= expressions.Cast[integer,interval_day]= expressions.Cast[integer,interval_hour]= expressions.Cast[integer,interval_minute]= expressions.Cast[integer,interval_second]= expressions.Cast[integer,interval_year]= expressions.Cast[integer,interval_month]= expressions.Cast[integer,decimal]= expressions.Cast[integer,double]= expressions.Cast[integer,float]= expressions.Cast[integer,float]= expressions.Cast[integer,integer]= expressions.Cast[integer,long]= expressions.Cast[integer,smallint]= expressions.Cast[integer,char]= expressions.Cast[integer,nchar]= expressions.Cast[integer,nvarchar]= expressions.Cast[integer,varchar]= expressions.Cast[long,clob]= expressions.Cast[long,interval_day]= expressions.Cast[long,interval_hour]= expressions.Cast[long,interval_minute]= expressions.Cast[long,interval_second]= expressions.Cast[long,interval_year]= expressions.Cast[long,interval_month]= expressions.Cast[long,decimal]= expressions.Cast[long,double]= expressions.Cast[long,float]= expressions.Cast[long,float]= expressions.Cast[long,integer]= expressions.Cast[long,long]= expressions.Cast[long,smallint]= expressions.Cast[long,char]= expressions.Cast[long,nchar]= expressions.Cast[long,nvarchar]= expressions.Cast[long,varchar]= expressions.Cast[smallint,clob]= expressions.Cast[smallint,interval_day]= expressions.Cast[smallint,interval_hour]= expressions.Cast[smallint,interval_minute]= expressions.Cast[smallint,interval_second]= expressions.Cast[smallint,interval_year]= expressions.Cast[smallint,interval_month]= expressions.Cast[smallint,decimal]= expressions.Cast[smallint,double]= expressions.Cast[smallint,float]= expressions.Cast[smallint,float]= expressions.Cast[smallint,integer]= expressions.Cast[smallint,long]= expressions.Cast[smallint,smallint]= expressions.Cast[smallint,char]= expressions.Cast[smallint,nchar]= expressions.Cast[smallint,nvarchar]= expressions.Cast[smallint,varchar]= expressions.Cast[char,binary]= expressions.Cast[char,clob]= expressions.Cast[char,boolean]= expressions.Cast[char,date]= expressions.Cast[char,time]= expressions.Cast[char,time_with_time_zone]= expressions.Cast[char,timestamp]= expressions.Cast[char,timestamp_with_time_zone]= expressions.Cast[char,interval_day]= expressions.Cast[char,interval_day_to_hour]= expressions.Cast[char,interval_day_to_minute]= expressions.Cast[char,interval_day_to_second]= expressions.Cast[char,interval_hour]= expressions.Cast[char,interval_hour_to_minute]= expressions.Cast[char,interval_hour_to_second]= expressions.Cast[char,interval_minute]= expressions.Cast[char,interval_minute_to_second]= expressions.Cast[char,interval_second]= expressions.Cast[char,interval_year]= expressions.Cast[char,interval_year_to_month]= expressions.Cast[char,interval_month]= expressions.Cast[char,decimal]= expressions.Cast[char,double]= expressions.Cast[char,float]= expressions.Cast[char,float]= expressions.Cast[char,integer]= expressions.Cast[char,long]= expressions.Cast[char,smallint]= expressions.Cast[char,char]= expressions.Cast[char,nchar]= expressions.Cast[char,nvarchar]= expressions.Cast[char,varchar]= expressions.Cast[char,xml]= expressions.Cast[nchar,binary]= expressions.Cast[nchar,clob]= expressions.Cast[nchar,boolean]= expressions.Cast[nchar,date]= expressions.Cast[nchar,time]= expressions.Cast[nchar,time_with_time_zone]= expressions.Cast[nchar,timestamp]= expressions.Cast[nchar,timestamp_with_time_zone]= expressions.Cast[nchar,interval_day]= expressions.Cast[nchar,interval_day_to_hour]= expressions.Cast[nchar,interval_day_to_minute]= expressions.Cast[nchar,interval_day_to_second]= expressions.Cast[nchar,interval_hour]= expressions.Cast[nchar,interval_hour_to_minute]= expressions.Cast[nchar,interval_hour_to_second]= expressions.Cast[nchar,interval_minute]= expressions.Cast[nchar,interval_minute_to_second]= expressions.Cast[nchar,interval_second]= expressions.Cast[nchar,interval_year]= expressions.Cast[nchar,interval_year_to_month]= expressions.Cast[nchar,interval_month]= expressions.Cast[nchar,decimal]= expressions.Cast[nchar,double]= expressions.Cast[nchar,float]= expressions.Cast[nchar,float]= expressions.Cast[nchar,integer]= expressions.Cast[nchar,long]= expressions.Cast[nchar,smallint]= expressions.Cast[nchar,char]= expressions.Cast[nchar,nchar]= expressions.Cast[nchar,nvarchar]= expressions.Cast[nchar,varchar]= expressions.Cast[nchar,xml]= expressions.Cast[nvarchar,binary]= expressions.Cast[nvarchar,clob]= expressions.Cast[nvarchar,boolean]= expressions.Cast[nvarchar,date]= expressions.Cast[nvarchar,time]= expressions.Cast[nvarchar,time_with_time_zone]= expressions.Cast[nvarchar,timestamp]= expressions.Cast[nvarchar,timestamp_with_time_zone]= expressions.Cast[nvarchar,interval_day]= expressions.Cast[nvarchar,interval_day_to_hour]= expressions.Cast[nvarchar,interval_day_to_minute]= expressions.Cast[nvarchar,interval_day_to_second]= expressions.Cast[nvarchar,interval_hour]= expressions.Cast[nvarchar,interval_hour_to_minute]= expressions.Cast[nvarchar,interval_hour_to_second]= expressions.Cast[nvarchar,interval_minute]= expressions.Cast[nvarchar,interval_minute_to_second]= expressions.Cast[nvarchar,interval_second]= expressions.Cast[nvarchar,interval_year]= expressions.Cast[nvarchar,interval_year_to_month]= expressions.Cast[nvarchar,interval_month]= expressions.Cast[nvarchar,decimal]= expressions.Cast[nvarchar,double]= expressions.Cast[nvarchar,float]= expressions.Cast[nvarchar,float]= expressions.Cast[nvarchar,integer]= expressions.Cast[nvarchar,long]= expressions.Cast[nvarchar,smallint]= expressions.Cast[nvarchar,char]= expressions.Cast[nvarchar,nchar]= expressions.Cast[nvarchar,nvarchar]= expressions.Cast[nvarchar,varchar]= expressions.Cast[nvarchar,xml]= expressions.Cast[varchar,binary]= expressions.Cast[varchar,clob]= expressions.Cast[varchar,boolean]= expressions.Cast[varchar,date]= expressions.Cast[varchar,time]= expressions.Cast[varchar,time_with_time_zone]= expressions.Cast[varchar,timestamp]= expressions.Cast[varchar,timestamp_with_time_zone]= expressions.Cast[varchar,interval_day]= expressions.Cast[varchar,interval_day_to_hour]= expressions.Cast[varchar,interval_day_to_minute]= expressions.Cast[varchar,interval_day_to_second]= expressions.Cast[varchar,interval_hour]= expressions.Cast[varchar,interval_hour_to_minute]= expressions.Cast[varchar,interval_hour_to_second]= expressions.Cast[varchar,interval_minute]= expressions.Cast[varchar,interval_minute_to_second]= expressions.Cast[varchar,interval_second]= expressions.Cast[varchar,interval_year]= expressions.Cast[varchar,interval_year_to_month]= expressions.Cast[varchar,interval_month]= expressions.Cast[varchar,decimal]= expressions.Cast[varchar,double]= expressions.Cast[varchar,float]= expressions.Cast[varchar,float]= expressions.Cast[varchar,integer]= expressions.Cast[varchar,long]= expressions.Cast[varchar,smallint]= expressions.Cast[varchar,char]= expressions.Cast[varchar,nchar]= expressions.Cast[varchar,nvarchar]= expressions.Cast[varchar,varchar]= expressions.Cast[varchar,xml]= expressions.Cast[xml,xml]= # # 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.RowNumber[]= olap.FirstValue[any]= olap.LastValue[any]= olap.NTile[any]= olap.Tertile[]= olap.RatioToReport[any]= olap.Difference[any]= # # 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[any]= olap.Min.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.CumeDistH[any,any]= aggregates.PercentileCont[any,any]= aggregates.PercentileDisc[any,any]= aggregates.XMLAgg= aggregates.Grouping[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]= # # Character scalar functions. # functions.CharLength[text]= functions.CharLength[clob]= functions.OctetLength[text]= functions.OctetLength[clob]= functions.BitLength[text]= functions.Upper[text]= functions.Upper[clob]= functions.Lower[text]= functions.Lower[clob]= functions.Substring[text,numeric,numeric]= functions.Substring[clob,numeric,numeric]= functions.Position[text,text]= functions.Position[text,clob]= functions.Concat[text,text]= functions.Ascii[text]=ASCII(%1$s) 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.Abs[numeric]= functions.Ceiling[numeric]= functions.Exp[numeric]= functions.Floor[numeric]= functions.Ln[numeric]= functions.Log10[numeric]= functions.Mod[numeric,numeric]= functions.Power[numeric,numeric]= functions.Random[]= functions.Random[any]= functions.Round[numeric]= functions.Round[numeric,numeric]= functions.Round[numeric,numeric,numeric]= functions.Sign[numeric]= functions.Sqrt[numeric]= functions.WidthBucket[numeric,numeric,numeric,numeric]= # # FDS functions. # # Local process does not support FDS functions. # # Datetime value functions. # functions.CurrentDate[]= functions.CurrentTime[]= functions.CurrentTime[numeric]= functions.CurrentTimestamp[]= functions.CurrentTimestamp[numeric]= functions.LocalTime[]= functions.LocalTime[numeric]= functions.LocalTimestamp[]= functions.LocalTimestamp[numeric]= # # Trigonometric functions. # functions.Arccos[numeric]= functions.Arcsin[numeric]= functions.Arctan[numeric]= functions.Cos[numeric]= functions.Coshyp[numeric]= functions.Sin[numeric]= functions.Sinhyp[numeric]= functions.Tan[numeric]= functions.Tanhyp[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.JSONExists= functions.JSONQuery= functions.JSONTable= functions.JSONValue= # # Business date functions. # functions.AddDays[interval_day_time,numeric]= functions.AddDays[datetime,numeric]= functions.AddDays[time_with_time_zone,numeric]= functions.AddDays[timestamp_with_time_zone,numeric]= functions.AddMonths[interval_year_month,numeric]= functions.AddMonths[datetime,numeric]= functions.AddMonths[time_with_time_zone,numeric]= functions.AddMonths[timestamp_with_time_zone,numeric]= functions.AddYears[interval_year_month,numeric]= functions.AddYears[datetime,numeric]= functions.AddYears[time_with_time_zone,numeric]= functions.AddYears[timestamp_with_time_zone,numeric]= functions.DaysToEndOfMonth[datetime]= functions.DaysBetween[datetime,datetime]= functions.FirstOfMonth[datetime]= functions.LastOfMonth[datetime]= functions.MakeTimestamp[numeric,numeric,numeric]= functions.DayOfYear[datetime]= functions.DayOfWeek[datetime,numeric]= # # Mappings used for transformation purposes only. # functions.AddHours[time,numeric]= functions.AddHours[timestamp,numeric]= functions.AddHours[time_with_time_zone,numeric]= functions.AddHours[timestamp_with_time_zone,numeric]= functions.AddMinutes[time,numeric]= functions.AddMinutes[timestamp,numeric]= functions.AddMinutes[time_with_time_zone,numeric]= functions.AddMinutes[timestamp_with_time_zone,numeric]= functions.AddSeconds[time,numeric]= functions.AddSeconds[timestamp,numeric]= functions.AddSeconds[time_with_time_zone,numeric]= functions.AddSeconds[timestamp_with_time_zone,numeric]= functions.HoursBetween[datetime,datetime]= functions.MinutesBetween[datetime,datetime]= functions.SecondsBetween[datetime,datetime]= # # Literals. # Use data types only, not domains. # literals.binary=false literals.blob=false literals.clob=false literals.boolean=false literals.date=false literals.time=false literals.time_with_time_zone=false literals.timestamp=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.smallint=false literals.integer=false literals.long=false literals.float=false literals.double=false literals.decimal=false literals.char=true literals.nchar=false literals.varchar=false literals.nvarchar=false literals.xml=false # # Literal format specifications. # # # 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 # # Arithmetic operators. # operators.arithmetic.Subtract[any,datetime]= operators.arithmetic.Concat[any,any]=(%1$s + %2$s) operators.arithmetic.Concat[text,clob]= operators.arithmetic.Concat[clob,text]=