| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136 |
- # 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.
- #
- # Clauses.
- #
- clauses.With=
- clauses.ForSystemTimeAsOf=
- clauses.ForSystemTimeFrom=
- clauses.ForSystemTimeBetween=
- #
- # Set operators.
- #
- operators.set.Intersect=
- operators.set.Intersect.all=
- operators.set.Except=
- operators.set.Except.all=
- #
- # Extract expression.
- #
- expressions.Extract.TIMEZONE_HOUR[any]=
- expressions.Extract.TIMEZONE_MINUTE[any]=
- #
- # 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.Lag[any]=
- olap.Lag[any,any]=
- olap.Lag[any,any,any]=
- olap.Lead[any]=
- olap.Lead[any,any]=
- olap.Lead[any,any,any]=
- olap.NTile[any]=
- olap.Tertile[]=
- olap.RatioToReport[any]=
- expressions.Cast[timestamp,clob]=
- expressions.Cast[timestamp,timestamp]=%1$s
- expressions.Cast[decimal,clob]=
- expressions.Cast[float,clob]=
- expressions.Cast[integer,clob]=
- expressions.Cast[smallint,clob]=
- expressions.Cast[char,clob]=
- expressions.Cast[char,timestamp]=CAST(%1$s as DATETIME)
- expressions.Cast[nchar,clob]=
- expressions.Cast[nchar,timestamp]=CAST(%1$s as DATETIME)
- expressions.Cast[nchar,decimal]=
- expressions.Cast[nvarchar,clob]=
- expressions.Cast[nvarchar,timestamp]=CAST(%1$s as DATETIME)
- expressions.Cast[varchar,clob]=
- expressions.Cast[varchar,timestamp]=CAST(%1$s as DATETIME)
- expressions.Cast[any,date]=
- expressions.Cast[any,time]=
- # Numeric scalar functions.
- #
- functions.Mod[integer,integer]=((%1$s) %% (%2$s))
- functions.Mod[integer,smallint]=((%1$s) %% (%2$s))
- functions.Mod[smallint,smallint]=((%1$s) %% (%2$s))
- functions.Mod[smallint,integer]=((%1$s) %% (%2$s))
- functions.Mod[any,any]=
- #
- # Literals.
- #
- literals.binary=false
- literals.boolean=false
- literals.time=false
- 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.xml=false
- #
- # Data types.
- #
- dataType.date=false
- dataType.time=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
- #
- # Support for SQL data types that are not defined in the JDBC 3.0 standard
- # datasource.type.<datasource specific name>=CCL datatype name
- # all spaces need to be replaced with an underscore (_)
- #
- datasource.type.datetimeoffset=
|
