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