;*********************************************************************** ;Licensed Materials - Property of IBM ; ;BI and PM: UDA ; ;(C) Copyright IBM Corp. 2005, 2011, 2014 ; ;U.S. Government Users Restricted Rights - Use, duplication, or disclosure ;by GSA ADP Schedule Contract with IBM Corp. ; ;Unless specifically authorized by IBM, you may not modify any part of this ;file. Where modification is authorized, you must reproduce any copyright ;notices contained in this file and specifically identify which ;modifications have been made by your organization. YOU ARE SOLELY ;RESPONSIBLE FOR DETERMINING THE APPROPRIATENESS OF ANY MODIFICATIONS TO ;THIS FILE AND ASSUME ALL RISKS ASSOCIATED WITH THE USE AND DISTRIBUTION ;OF THE MODIFIED FILE. IBM will not provide support relating to ;unauthorized changes you make to this file. ;*********************************************************************** ; $Header: $ ; ; Module: ; cogdmod_cf.ini ; ; Purpose: ; This module contains the Vertica gateway information. ; ; Notes: ; Do NOT modify this file. Doing so could result in unknown behavior ; by the Classic Federation gateway, possibly resulting in application aborts. ; ; ************************************************************************ ; To enable tracing of ODBC routines called, uncomment the following lines in cogdmod.ini and specify a valid trace file name. ; [TRACE] ; output= ; To enable tracing of data in the bound buffers, uncomment the following line ; Data=yes ; To enable printing the elapsed times for ODBC function calls, uncomment the following line: ; Timer=yes ; Note that the ODBC API provides C types where the structs do not provide for returning fractional seconds for ; TIME type. While the RDBMS may support a TIME TZ or TIMESTAMP TZ those types are either described as ; TIME and TIMSTAMP or a CHAR type. Recommendations will reflect these restrictions that a non-ODBC API ; would not encounter. [DATABASE:INFOSPHERE CLASSIC FEDERATION] Disable_Subquery_With_Parameters=T Keyword Alias=" as \"%s\" " ; A significant number (5) of tests using parameter markers failed. This aspect ; of the RDBMS should be reviewed. For ODBC the solution may be to disable using the ; vendors SQL DESCRIBE API ; SQL_API_SQLDESCRIBEPARAM="FALSE" SQL_OJ_CAPABILITIES = "1" [Exceptions Commands DATABASE:INFOSPHERE CLASSIC FEDERATION] Select="select " Insert="insert " Update="update " Delete="delete " Call= Select_Star="T" Max_Stmt_Len="" [Exceptions Clauses DATABASE:INFOSPHERE CLASSIC FEDERATION] From="from " Where="where" Group_By="Group By" Having= Window= With= With_Recursive= [Exceptions Tables DATABASE:INFOSPHERE CLASSIC FEDERATION] Derived=T Joined=F Simple_And_Joined=T Tbl_Ref_Limit="" SubSelect_Limit="" Table_Constructor=F UniqueName_Prefix="coguda" [Exceptions Joins DATABASE:INFOSPHERE CLASSIC FEDERATION] Inner=F Left_Outer=T Right_Outer=T Full_Outer=T Cross=F On_Condition_Or_Predicate=F Nested_Outer=T Inner_Tbl_Restrict=F Optnl_Tbl_Restrict=T Non_Equi_Joins=T One_Outer=T Natural=F Left_Nested=F Right_Nested=F Two_Sided_Join_Restrict=F Optnl_Tbl_Join_Restrict=F Optnl_Tbl_Join_Filter=F Optnl_Tbl_Filter=T Prsrv_Tbl_Join_Filter=F Prsrv_Tbl_Filter=T On_Condition_Set_Functions=F On_Condition_Subqueries=F Full_Non_Equi_Join=F On_Condition_In_Predicate=F On_Condition_Not_Predicate=F On_Condition_Like_Predicate=F On_Condition_Between_Predicate=F On_Condition_IsNull_Predicate=F Non_Join_Expr=F Non_Join_Non_Equi_Expr=F Only_Eql_With_And=T On_Condition_Functions=F Two_Sided_Join_Restrict_Filter=F Nested_Inner=T Product_Join=T Outer_Non_Equi_Join=T On_Condition_No_Expr=F Outer_Syntax=T Left_Pre= ;Left_Eql=" LEFT OUTER JOIN " Left_Post= Right_Pre= ;Right_Eql=" RIGHT OUTER JOIN " Right_Post= ;Full_Syntax=" FULL OUTER JOIN " Full_Pre= Full_Post= ;Inner_Syntax=" INNER JOIN " Inner_Col_Pre= Inner_Col_Post= ;Cross_Syntax=" CROSS JOIN " ;Union_Syntax=" UNION " ;Natural_Syntax=" NATURAL JOIN " [Exceptions Predicates DATABASE:INFOSPHERE CLASSIC FEDERATION] Between="between" In="in" Like="like" Is_Null="is null" Any="any" All="all" Exists="exists" NotLike="not like" [Exceptions Aggregates DATABASE:INFOSPHERE CLASSIC FEDERATION] Max= Min= Sum="sum" ; Vendor has the aggregate function but is returning an integral value (e.g. 2) as opposed to an approximate value (e.g. 2.5) ; this may cause AVG, windowed AVG and similar ratio expressions to be flagged as failed. Avg= Count= Count_Star="count(*)" Stddev= Stddev_Pop= Stddev_Samp= Variance= Var_Pop= Var_Samp= Grouping= Rank= Dense_Rank= Percent_Rank= Cume_Dist= Percentile_Cont= Percentile_Disc= First_Value= Last_Value= Percentile=F [Exceptions OLAP Functions DATABASE:INFOSPHERE CLASSIC FEDERATION] ; Vendor does not support muliple partitions in the same block which is required Olap_Min= Olap_Max= Olap_Sum= Olap_Avg= Olap_Count= Olap_Count_Star= Olap_Stddev= Olap_Stddev_Pop= Olap_Stddev_Samp= Olap_Variance= Olap_Var_Pop= Olap_Var_Samp= Olap_Rank= Olap_Dense_Rank= Olap_Percent_Rank= Olap_Cume_Dist= Olap_Percentile_Cont= Olap_Percentile_Disc= ; Vendor imposing ordering in window Olap_First_Value= ; Vendor imposing ordering in window Olap_Last_Value= Olap_Row_Number= Olap_Ratio_To_Report= Olap_Ntile= ; Olap_Count_Default="ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING" ; Olap_Sum_Default="ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING" ; Olap_Last_Value_Default="ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING" [Exceptions Set Operators DATABASE:INFOSPHERE CLASSIC FEDERATION] Union="union" Union_All=T Intersect= Intersect_All=F Except= Except_All=F Distinct= Order_By="order by" [Exceptions Operators DATABASE:INFOSPHERE CLASSIC FEDERATION] Add="+" Sub="-" Mul="*" Div="/" Eql= Neq= Grt= Geq= Les= Leq= Neg="-" And="and" Or="or" Not="not" Assign="=" [Exceptions Value Expressions DATABASE:INFOSPHERE CLASSIC FEDERATION] Case_Simple=F Case_Searched=F Coalesce=T Nullif=F Grouping_Sets=F Rollup=F Cube=F Position=F ; The Position function did not throw expected exceptions. Review the position exceptions tests Char_Length=F Octet_Length=F Substring=F Upper=F Lower=F Cast=F Abs=F Floor=F Ceiling=F ln=F Exp=F Mod=F Sqrt=F Power=F Current_Date=F ;Unable to get timezone type via ODBC so disabled Current_Time=F Current_TimeStamp=F LocalTime=F LocalTimestamp=F Extract=F Row_Value_Constructors=F Olap_Window_Order_By=F ; Unable to order by a literal value [Exceptions General DATABASE:INFOSPHERE CLASSIC FEDERATION] Aggregate_In_Expr=F Aggregate_Value_Expr=T Correlated_Subqueries=T Cross_Product=T Distinct_Aggregates=T Distinct_Aggr_In_Case=F Group_By_Expr=F Group_By_Ordinal=F Group_By_Alias=F Multiple_Distinct=F Count_Non_Distinct=F Count_Value_Expr=F Count_Literal=F Is_Null_Value_Expr=T Is_Null_Value_Parm=T Like_Value_Expr=F Subquery_In_Having=T Subquery_In_Group_By=F Subquery_In_Case=F Count_Blob=T Expression_In_In=F Null_Order=F Olap_Null_Order=F Olap_Distinct=F Nested_Olap_Functions=F Empty_String_Is_Null=T Order_By_In_Derived_Table=F Interval_As_VarChar=F Boolean_Comparison=T Derived_Column_List=F With_Column_List=F Aggr_With_Interval=T Nested_Case=F Not_In_Subquery=F Nulls_Sort_Last=T Order_By_Alias=F Order_By_Name=T Substring_On_Expr=F Subqueries=T Subquery_Column_Alias=F Parameter_In_Select_List=T Remove_Parameter_Cast=F Subquery_With_Parameters=T Like_With_Parameters=T Like_With_Escape=T Comments=F Integer_Division_Truncation=T [Exceptions Literals DATABASE:INFOSPHERE CLASSIC FEDERATION] Interval_Literal=F IntervalYM_Literal=F TimeTZ_Literal=F TimestampTZ_Literal=F [Exceptions Misc DATABASE:INFOSPHERE CLASSIC FEDERATION] [Exceptions Delimiters DATABASE:INFOSPHERE CLASSIC FEDERATION] ; The RDBMS did not accept double quotes for a quoted identifier ODBC connections will determine what quote ; character may be required via SQL_IDENTIFIER_QUOTE_CHAR. ;Catalog_Delimiter= ;Schema_Delimiter= ;Table_Delimiter="" ;Column_Delimiter="\"" ;Procedure_Delimiter= ;Wholename_Delimiter= ;Table_Function_PreStr="TABLE( " ;Table_Function_PostStr=" )" ; ANSI style dashdash is also supported Comment_Begin="/* " Comment_End=" */ " [Exceptions Separators DATABASE:INFOSPHERE CLASSIC FEDERATION] Catalog_Separator="." Schema_Separator="." Table_Separator="." [Exceptions Blob Expressions DATABASE:INFOSPHERE CLASSIC FEDERATION] Blob_In_Substring=T Blob_In_Trim=T Blob_In_StrCat=T Blob_In_IsNull=T Blob_In_Substring_Return_Blob=F ;b stands for boolean. ;c stands for character. ;x stands for text. ;d stands for date. ;i stands for the interval. ;n stands for the numeric. ;s stands for the timestamp. ;t stands for the time. ;y stands for time with time zone ;z stands for timestamp with time zone [Database Functions DATABASE:INFOSPHERE CLASSIC FEDERATION] ;if Trim is not fully supported (Trim=F) but aspects of Trim can be re-mapped ;uncomment the applicable entries associated to the Trim mappings from value expressions section ; The trim function did not throw expected exceptions. Review the trim exceptions tests ;c:trim_leading_spaces(%1c)=; ;c:trim_traiing_spaces(%1c)=; ;c:trim_both_spaces(%1c)=; [Builtin Functions DATABASE:INFOSPHERE CLASSIC FEDERATION] ;n:_round(%1n, %2n)=; [Operator Addition DATABASE:INFOSPHERE CLASSIC FEDERATION] [Operator Subtraction DATABASE:INFOSPHERE CLASSIC FEDERATION] [Operator Multiplication DATABASE:INFOSPHERE CLASSIC FEDERATION] [Operator Division DATABASE:INFOSPHERE CLASSIC FEDERATION] [Operator Comparison DATABASE:INFOSPHERE CLASSIC FEDERATION] [Operator Cast DATABASE:INFOSPHERE CLASSIC FEDERATION] AD=AD,NA [Directives Session DATABASE:INFOSPHERE CLASSIC FEDERATION]