analytics/configuration/xqe/db2.sql9.7.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.
#

#
# Keywords.
#

#
# Various limits.
#

#
# General settings.
#

#
# Cursor options - appended to end of generated SELECT statement.
#

#
# Various features.
#

#
# Performance properties (force certain transformations to be applied). 
#

#
# Command.
#

#
# Tables.
#

#
# Constructors.
#

#
# Constructors - context overrides.
#
constructors.row.simpleCase=false
constructors.row.between=false

#
# Clauses.
#

#
# Joins.
#

#
# Set operators.
#

#
# Logical operators.
#

#
# Arithmetic operators.
#

#
# Group By Operators
#

#
# Comparison predicates.
#

#
# Various predicates.
#
predicates.Overlaps[any,any,any,any]=
predicates.LikeRegex=

#
# Period predicates.
#

#
# Expressions.
#

#
# Cast expression.
#
expressions.Cast[any,xml]=

#
# Extract expression.
#

#
# Trim expression.
#

#
# Windowed aggregates (SQL/OLAP).
#
olap.PercentRank[]=
olap.CumeDist[]=
olap.PercentileCont[any,any]=
olap.PercentileDisc[any,any]=
olap.StdDevSamp[any]=
olap.VarSamp[any]=
olap.Median[any]=
olap.NthValue[any,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.VarSamp[any]=
aggregates.StdDevSamp[any]=
aggregates.PercentRank[any,any]=
aggregates.PercentileCont[any,any]=
aggregates.PercentileDisc[any,any]=
aggregates.Median[any]=

#
# Aggregates (distinct).
#

#
# Linear regression aggregates.
#

#
# JSON aggregates.
#

#
# Character scalar functions.
#

#
# Regular expression functions.
#

#
# FDS functions.
#

#
# Numeric scalar functions.
#
functions.WidthBucket[any,any,any,any]=

# Array scalar functions.
#

#
# Datetime value functions.
#

#
# XML functions.
#

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

#
# Table functions.
#

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

#
# Literal constraints.
#

#
# Data types.
#