analytics/configuration/xqe/db2.sql8.2.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.

#
# Product information.
#

#
# Delimiters.
#

#
# Various limits.
#
limits.maxStatementLength=65535


#
# General settings.
#

#
# Various features.
#
supports.nestedOlap=false

#
# Command.
#

#
# Tables.
#

#
# Constructors.
#

#
# Clauses.
#


#
# Joins.
#

#
# Set operators.
#


#
# Logical operators.
#

#
# Arithmetic operators.
#

#
# Group By Operators
#

#
# Comparison predicates.
#

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

#
# Expressions.
#

#
# Cast expression
#
expressions.Cast[time,varchar]=
expressions.Cast[time,char]=
# 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 8.2 adds leading 0's to the result string
expressions.Cast[decimal,char]=
expressions.Cast[decimal,varchar]=
expressions.Cast[decimal,nchar]=
expressions.Cast[decimal,nvarchar]=

#
# literal formats
#
literals.format.time={t '%1$02d:%2$02d:%3$02d'}
#
# fds functions
#
functions.cast_char[time]=CHAR(%1$s)
functions.cast_varchar[time,any]=CAST(%1$s AS VARCHAR (%2$d))
functions.cast_longvarchar[time]=CAST(%1$s AS LONG VARCHAR)
#
# 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)

#
# Trim expression. DB2 8.2 doesn't support SQL Standard TRIM syntax.
#
expressions.Trim.BOTH[text]=LTRIM(RTRIM(%1$s))
expressions.Trim.LEADING[text]=LTRIM(%1$s)
expressions.Trim.TRAILING[text]=RTRIM(%1$s)
expressions.Trim.BOTH[text,text]=
expressions.Trim.LEADING[text,text]=
expressions.Trim.TRAILING[text,text]=

#
# Windowed aggregates (SQL/OLAP).
#
olap.FirstValue[any]=
olap.LastValue[any]=
olap.NTile[any]=

#
# Window clause.
#

#
# Window specification
# A list of windows specifications that are supported by the DB
# P = PARTITION BY
# O = ORDER BY
# F = FRAME 
#

#
# Olap (distinct).
#

#
# Aggregates.
#

#
# Aggregates (distinct).
#

#
# Linear regression aggregates.
#

#
# Character scalar functions.
#
functions.CharLength[text]=LENGTH(%1$s, CODEUNITS32)
functions.CharLength[clob]=LENGTH(%1$s, CODEUNITS32)
functions.BitLength[text]=


#
# FDS functions.
#


#
# Numeric scalar functions.
#

#
# Datetime value functions.
#

#
# XML functions.
#

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

#
# Mappings used for transformation purposes only.
#


#
# Spatial functions (SQL/MM).
#


#
# Literals.
# Use datatypes only, not domains.
#

#
# Literal format specifications.
#


#
# Data types.
#

#
# Collation sequence query
#
collation.sequence.sql=