# Licensed Materials - Property of IBM # IBM Cognos Products: OQP # (C) Copyright IBM Corp. 2005, 2016 # 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. # # Clauses. # # # Constructors. # constructors.row=false # # Windowed aggregates (SQL/OLAP). # olap.Count[any]= olap.Sum[any]= # # Window specification # A list of windows specifications that are supported by the DB # P = PARTITION BY # O = ORDER BY # F = FRAME # olap.Window.Specification[OF]=false olap.Window.Specification[F]=false olap.Window.Specification[PF]=false olap.Window.Specification[POF]=false olap.Window.Specification[PO]=false olap.Window.Specification[P]=false olap.Window.Specification[O]=false olap.Window.Specification[F]=false olap.Window.Specification[]=false # # Aggregates. # aggregates.PercentileCont[any,any]= aggregates.PercentileDisc[any,any]= # # Mappings used for transformation purposes only. # functions.AddHours[time_with_time_zone,numeric]= functions.AddHours[timestamp_with_time_zone,numeric]= functions.AddMinutes[time_with_time_zone,numeric]= functions.AddMinutes[timestamp_with_time_zone,numeric]= # # Literals. # literals.timestamp_with_time_zone=false # # Literal format specifications. Formats are compatible with String.format(). # Values for default behaviour are listed. # Only char, temporal and string types can be overridden. # Fractional seconds are presented as a string of up to 10 characters: '.' followed by 9 character # 0-padded string representing nanoseconds or empty. # literals.format.timestamp=TIMESTAMP('%1$04d-%2$02d-%3$02d %4$02d:%5$02d:%6$02d%7$.7s') # # Data types. # dataType.timestamp_with_time_zone=false