analytics/bin/cogdmod_cf.ini

;***********************************************************************
;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=<file specification>
 
; 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]