analytics/configuration/xqe/sqlserver9.0.properties

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

#
# Product information.
#

#
# Delimiters.
#

#
# Various limits.
#

#
# General settings.
#

#
# Various features.
#
supports.sqlserverWindowBehaviour=false

#
# Command.
#

#
# Tables.
#

#
# Constructors.
#

#
# Clauses.
#
clauses.With=
clauses.ForSystemTimeAsOf=
clauses.ForSystemTimeFrom=
clauses.ForSystemTimeBetween=

#
# Joins.
#

#
# Set operators.
#
operators.set.Intersect=
operators.set.Except=

#
# Logical operators.
#

#
# Arithmetic operators.
#

#
# Group By Operators
#

#
# Comparison predicates.
#

#
# Various predicates.
#

#
# Expressions.
#

#
# Cast expression.
#
expressions.Cast[nchar,decimal]=
expressions.Cast[timestamp,timestamp]=%1$s
expressions.Cast[any,date]=
expressions.Cast[any,time]=

#
# Extract expression.
#

#
# Trim expression.
#

#
# Windowed aggregates (SQL/OLAP).
#
olap.Max[any]=
olap.Min[any]=
olap.Sum[any]=
olap.Avg[any]=
olap.Count[any]=
olap.Count[blob]=
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.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]=
olap.Difference[any]=
#CQ654767, RTC216142
olap.RowNumber[]=

#
# 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).
#
olap.Max.distinct[any]=
olap.Min.distinct[any]=
olap.Sum.distinct[any]=
olap.Avg.distinct[any]=
olap.Count.distinct[any]=

#
# Aggregates.
#

#
# Aggregates (distinct).
#

#
# Linear regression aggregates.
#

#
# Character scalar functions.
#

#
# Numeric scalar functions.
#

#
# Trigonometric functions.
#

#
# Datetime value functions.
#
functions.CurrentDate[]=convert(datetime, convert( char(8), current_timestamp, 112 ), 112)
functions.CurrentTime[]=
functions.CurrentTimestamp[]=

#
# XML functions.
#

#
# Business date functions.
#
functions.WeekOfYear[any]=

#
# Mappings used for transformation purposes only.
#

#
# FDS functions.
#

#
# Literals.
#
literals.time=false
literals.timestamp_with_time_zone=false

#
# Literal format specifications.
#
literals.format.date={d '%1$04d-%2$02d-%3$02d'}

#
# Literal Exceptions.
#
#
# Data types.
#
dataType.date=false
dataType.time=false
dataType.timestamp_with_time_zone=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=