analytics/configuration/xqe/db2.sql9.5.properties

# Licensed Materials - Property of IBM
# IBM Cognos Products: OQP
# (C) Copyright IBM Corp. 2005, 2020
# US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM corp.

#
#
# Comparison predicates.
#
predicates.comparison.LessThan[date,timestamp]=
predicates.comparison.LessThan[date,timestamp_with_time_zone]=
predicates.comparison.LessThan[timestamp,date]=
predicates.comparison.LessThan[timestamp_with_time_zone,date]=

predicates.comparison.LessThanOrEquals[date,timestamp]=
predicates.comparison.LessThanOrEquals[date,timestamp_with_time_zone]=
predicates.comparison.LessThanOrEquals[timestamp,date]=
predicates.comparison.LessThanOrEquals[timestamp_with_time_zone,date]=

predicates.comparison.Equals[date,timestamp]=
predicates.comparison.Equals[date,timestamp_with_time_zone]=
predicates.comparison.Equals[timestamp,date]=
predicates.comparison.Equals[timestamp_with_time_zone,date]=

predicates.comparison.NotEquals[date,timestamp]=
predicates.comparison.NotEquals[date,timestamp_with_time_zone]=
predicates.comparison.NotEquals[timestamp,date]=
predicates.comparison.NotEquals[timestamp_with_time_zone,date]=

predicates.comparison.GreaterThan[date,timestamp]=
predicates.comparison.GreaterThan[date,timestamp_with_time_zone]=
predicates.comparison.GreaterThan[timestamp,date]=
predicates.comparison.GreaterThan[timestamp_with_time_zone,date]=

predicates.comparison.GreaterThanOrEquals[date,timestamp]=
predicates.comparison.GreaterThanOrEquals[date,timestamp_with_time_zone]=
predicates.comparison.GreaterThanOrEquals[timestamp,date]=
predicates.comparison.GreaterThanOrEquals[timestamp_with_time_zone,date]=

#
# Various predicates.
#
predicates.IsDistinctFrom[blob,any]=
predicates.IsDistinctFrom[any,blob]=
predicates.IsNotDistinctFrom[any,blob]=
predicates.IsNotDistinctFrom[blob,any]=

predicates.Between[date,timestamp,any]=
predicates.Between[date,any,timestamp]=
predicates.Between[date,timestamp_with_time_zone,any]=
predicates.Between[date,any,timestamp_with_time_zone]=
predicates.Between[timestamp,date,any]=
predicates.Between[timestamp,any,date]=
predicates.Between[timestamp_with_time_zone,date,any]=
predicates.Between[timestamp_with_time_zone,any,date]=

predicates.In[date,timestamp]=
predicates.In[date,timestamp_with_time_zone]=
predicates.In[timestamp,date]=
predicates.In[timestamp_with_time_zone,date]=

# Extract expression.
#
expressions.Extract.YEAR[any]=YEAR(%1$s)
expressions.Extract.MONTH[any]=MONTH(%1$s)
expressions.Extract.DAY[any]=DAY(%1$s)
expressions.Extract.HOUR[any]=HOUR(%1$s)
expressions.Extract.MINUTE[any]=MINUTE(%1$s)

#
# Cast expression
#
expressions.Cast[text,float]=
expressions.Cast[text,double]=
# cast through CHAR as an intermediate type so we can push it.
expressions.Cast[numeric,varchar]=CAST(RTRIM(CAST(%1$s as CHAR(%3$d))) as %2$s)
# safe to substitute VARCHAR for NVARCHAR on DB2.
expressions.Cast[numeric,nvarchar]=CAST(RTRIM(CAST(%1$s as CHAR(%3$d))) as VARCHAR(%3$d))

# disable cast[decimal,text],
# since DB2 9.5 adds leading 0's to the result string
expressions.Cast[decimal,char]=
expressions.Cast[decimal,varchar]=
expressions.Cast[decimal,nchar]=
expressions.Cast[decimal,nvarchar]=

#
# Windowed aggregates (SQL/OLAP).
#
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]=
olap.NTile[any]=

#
# Business date functions.
#
functions.FirstOfMonth[any]=(%1$s - (DAY(%1$s)-1) DAY)
functions.LastOfMonth[any]=(%1$s - (DAY(%1$s)-1) DAY + 1 MONTH - 1 DAY)

#
# literal formats
#

#
# fds functions
#

#
# Character scalar functions.
#
functions.Upper[clob]=
functions.Lower[clob]=
functions.Round[any]=