analytics/bin64/cogdmod_pa.ini

;***********************************************************************
;Licensed Materials - Property of IBM
;
;BI and PM: UDA
;
;(C) Copyright IBM Corp. 2005, 2020
;
;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_pa.ini
;
; Purpose:
;    This module contains the Paraccel gateway information.
;
; Notes:
;    Do NOT modify this file.  Doing so could result in unknown behavior
;    by the Paraccel gateway, possibly resulting in application aborts.
;
; ************************************************************************

 
[DATABASE:PARACCEL]
Disable_Subquery_With_Parameters=T
Keyword Alias=" as \"%s\" "
; Various issues found with their parameter support so the API is disabled
SQL_API_SQLDESCRIBEPARAM="FALSE"
 
[Exceptions Commands DATABASE:PARACCEL]
Select="select "
Insert="insert "
Update="update "
Delete="delete "
Call=
Select_Star="T"
Max_Stmt_Len=""

[Exceptions Clauses DATABASE:PARACCEL]
From="from"
Where="where"
Group_By="Group By"
Having="having"
Window=
With=
With_Recursive=

[Exceptions Tables DATABASE:PARACCEL]
Derived=T
Joined=F
Simple_And_Joined=T
Tbl_Ref_Limit=""
SubSelect_Limit=""
Table_Constructor=F
UniqueName_Prefix="coguda"

[Exceptions Joins DATABASE:PARACCEL]
Inner=T
Left_Outer=T
Right_Outer=T
Full_Outer=T
Cross=T
On_Condition_Or_Predicate=T
Nested_Outer=T
Inner_Tbl_Restrict=F
Optnl_Tbl_Restrict=F
Non_Equi_Joins=T
One_Outer=F
Natural=T
Left_Nested=T
Right_Nested=T
Two_Sided_Join_Restrict=F
Optnl_Tbl_Join_Restrict=F
Optnl_Tbl_Join_Filter=T
Optnl_Tbl_Filter=T
Prsrv_Tbl_Join_Filter=T
Prsrv_Tbl_Filter=T
On_Condition_Set_Functions=T
On_Condition_Subqueries=T
Full_Non_Equi_Join=F
On_Condition_In_Predicate=T
On_Condition_Not_Predicate=T
On_Condition_Like_Predicate=T
On_Condition_Between_Predicate=T
On_Condition_IsNull_Predicate=T
Non_Join_Expr=T
Non_Join_Non_Equi_Expr=T
Only_Eql_With_And=F
On_Condition_Functions=T
Two_Sided_Join_Restrict_Filter=F
Nested_Inner=T
Product_Join=T
Outer_Non_Equi_Join=T
On_Condition_No_Expr=T
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:PARACCEL]
Between="between"
In="in"
Like="like"
Is_Null="is null"
Any=
All=
Exists="exists"
NotLike="not like"

[Exceptions Aggregates DATABASE:PARACCEL]
Max="max"
Min="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="avg"
Count="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:PARACCEL]
Olap_Min="min"
Olap_Max="max"
Olap_Sum="sum"
Olap_Avg="avg"
Olap_Count="count"
Olap_Count_Star="count(*)"
Olap_Stddev=
Olap_Stddev_Pop=
Olap_Stddev_Samp=
Olap_Variance=
Olap_Var_Pop=
Olap_Var_Samp=
Olap_Rank="rank"
Olap_Dense_Rank="dense_rank"
Olap_Percent_Rank=
Olap_Cume_Dist=
Olap_Percentile_Cont=
Olap_Percentile_Disc=
Olap_First_Value=
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:PARACCEL]
Union="union"
Union_All=T
Intersect="intersect"
Intersect_All=T
Except=" except "
Except_All=F
Distinct="distinct"
Order_By="order by"

[Exceptions Operators DATABASE:PARACCEL]
Add="+"
Sub="-"
Mul="*"
Div="/"
Eql="="
Neq="<>"
Grt=">"
Geq=">="
Les="<"
Leq="<="
Neg="-"
And="and"
Or="or"
Not="not"
Assign="="

[Exceptions Value Expressions DATABASE:PARACCEL]
Case_Simple=T
Case_Searched=T
Coalesce=T
Nullif=T
Grouping_Sets=F
Rollup=F
Cube=F
Position=F
Char_Length=F
Octet_Length=F
Substring=T
Upper=T
Lower=T
StrCat=T
Cast=C
Abs=T
Floor=T
Ceiling=C
ln=T
Exp=F
Mod=F
Sqrt=T
Power=F
Current_Date=T
;Unable to get timezone type via ODBC so disabled
Current_Time=F
Current_TimeStamp=F
; ODBC driver has problem returning the value
LocalTime=F
LocalTimestamp=F
; Aspects of Extract can be mapped via entries in the built in section
Extract=C
Extract_Year=coguda#extract_year
Extract_Month=coguda#extract_month
Extract_Day=coguda#extract_day
Extract_Hours=coguda#extract_hour
Extract_Minutes=coguda#extract_minute
Trim=T
Row_Value_Constructors=T
Olap_Window_Order_By=F
; Unable to order by a literal value
 
[Exceptions General DATABASE:PARACCEL]
Aggregate_In_Expr=T
Aggregate_Value_Expr=T
Correlated_Subqueries=T
Cross_Product=T
Distinct_Aggregates=T
Distinct_Aggr_In_Case=T
Group_By_Expr=T
Group_By_Ordinal=T
Group_By_Alias=T
Multiple_Distinct=T
Count_Non_Distinct=T
Count_Value_Expr=T
Count_Literal=T
Is_Null_Value_Expr=T
Is_Null_Value_Parm=T
Like_Value_Expr=T
Subquery_In_Having=T
Subquery_In_Group_By=T
Subquery_In_Case=T
Count_Blob=T
Expression_In_In=T
Null_Order=F
Olap_Null_Order=F
Olap_Distinct=F
Nested_Olap_Functions=F
Empty_String_Is_Null=F
Order_By_In_Derived_Table=T
Interval_As_VarChar=F
Boolean_Comparison=T
Derived_Column_List=T
With_Column_List=F
Aggr_With_Interval=T
Nested_Case=T
Not_In_Subquery=T
Nulls_Sort_Last=T
Order_By_Alias=T
Order_By_Name=T
Substring_On_Expr=T
Subqueries=T
Subquery_Column_Alias=T
Parameter_In_Select_List=T
Remove_Parameter_Cast=T
Subquery_With_Parameters=T
Like_With_Parameters=T
Like_With_Escape=T
Comments=T
Integer_Division_Truncation=T
 
[Exceptions Literals DATABASE:PARACCEL]
Date_Literal=T
Timestamp_Literal=T
Interval_Literal=F
IntervalYM_Literal=F
TimeTZ_Literal=F
TimestampTZ_Literal=F
 
[Exceptions Misc DATABASE:PARACCEL]

[Exceptions Delimiters DATABASE:PARACCEL]
; The RDBMS is accepting double quotes for quoted identifiers. For non-ODBC based connections
; enable the appropriate delimeter entries with respect to if catalog, schemas, procedures and
; table functions would be supported.
;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:PARACCEL]
Catalog_Separator="."
Schema_Separator="."
Table_Separator="."
 
[Exceptions Blob Expressions DATABASE:PARACCEL]
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:PARACCEL]
n:ceiling(%1n)=CEIL(%1);

 
[Builtin Functions DATABASE:PARACCEL]

d:_add_days(%1d,%2n)=cast(DATEADD(days,cast(floor(%2) as int),%1) as date);
d:_add_months(%1d,%2n)=cast(DATEADD(months,cast(floor(%2) as int),%1) as date);
d:_add_years(%1d,%2n)=cast(DATEADD(years,cast(floor(%2) as int),%1) as date);
d:_first_of_month(%1d)=cast(DATEADD(day,1,%1 - cast(extract(day from %1) as INTEGER)) AS date);
d:_last_of_month(%1d)=cast(DATEADD(month,1,%1 - cast(extract(day from %1) as INTEGER)) AS date);
s:_add_days(%1s,%2n)=DATEADD(days,cast(floor(%2) as int),%1);
s:_add_months(%1s,%2n)=DATEADD(months,cast(floor(%2) as int),%1);
s:_add_years(%1s,%2n)=DATEADD(years,cast(floor(%2) as int),%1);
s:_first_of_month(%1s)=DATEADD(day, 1, (%1 - cast(extract(day from %1) as INTEGER)));
s:_last_of_month(%1s)=DATEADD(month, 1, (%1 - cast(extract(day from %1) as INTEGER)));
;s:_make_timestamp(%1n,%2n,%3n)=;
s:_add_hours(%1s,%2n)=DATEADD(hours,cast(floor(%2) as int),%1);
s:_add_minutes(%1s,%2n)=DATEADD(minutes,cast(floor(%2) as int),%1);
s:_add_seconds(%1s,%2n)=DATEADD(seconds,cast(floor(%2) as int),%1);
n:_days_between(%1ds,%2ds)=DATEDIFF(day, %2, %1);
n:_months_between(%1ds,%2ds)=DATEDIFF(months, %2, %1);
n:_years_between(%1ds,%2ds)=DATEDIFF(years,%2,%1);
n:_hours_between(%1ds,%2ds)=DATEDIFF('hour', %2 , %1 );
n:_minutes_between(%1ds,%2ds)=DATEDIFF('minute', %2 , %1 );
n:_seconds_between(%1ds,%2ds)=DATEDIFF('second', %2 , %1 );
n:_days_to_end_of_month(%1ds)=DATEDIFF('day',%1,cast(DATEADD(month,1,%1 - cast(extract(day from %1) as INTEGER)) as timestamp)); 
n:_day_of_year(%1ds)=DATE_PART('doy',%1);
n:_day_of_week(%1ds, %2n)=(MOD( cast( TO_CHAR( %1, 'D' ) AS INTEGER ) + 6 - %2, 7 ) + 1);
;n:_age(%1ds)=;
;n:_ymdint_between(%1ds,%2ds)=;
; must be iso 8601 compliant
;n:_week_of_year(%1ds)=;
;n:_round(%1n, %2n)=; 
n:coguda#extract_year(%1ds)=cast(extract(year from %1) as INTEGER);
n:coguda#extract_month(%1ds)=cast(extract(month from %1) as INTEGER);
n:coguda#extract_day(%1ds)=cast(extract(day from %1) as INTEGER);
n:coguda#extract_hour(%1s)=cast(extract(hour from %1) as INTEGER);
n:coguda#extract_minute(%1s)=cast(extract(minute from %1) as INTEGER);


[Operator Addition]
 
[Operator Subtraction]
 
[Operator Multiplication]
 
[Operator Division]
 
[Operator Comparison]

[Operator Cast DATABASE:PARACCEL]
AD=AD,NA
BL=AD,NA
CH=CH,CH:DB,DB:DM,DM:DT,DT:FL,FL:IT,IT:NU,NU:QD,QD:SM,SM:TS,TS:VC,VC
DB=DB,DB:DM,DM:FL,FL:NU,NU:SM,SM
DM=CH,CH:DB,DB:DM,DM:FL,FL:IT,IT:NU,NU:QD,QD:SM,SM:VC,VC
DT=CH,CH:DT,DT:TS,TS:VC,VC
FL=DB,DB:DM,DM:FL,FL:IT,IT:NU,NU:SM,SM
IT=CH,CH:DB,DB:DM,DM:FL,FL:IT,IT:NU,NU:QD,QD:SM,SM:VC,VC
IV=AD,NA
IY=AD,NA
NA=CH,CH:DB,DB:DM,DM:DT,DT:FL,FL:IT,IT:NU,NU:QD,QD:SM,SM:TS,TS:VC,VC
NC=AD,NA
NU=CH,CH:DB,DB:DM,DM:FL,FL:IT,IT:NU,NU:QD,QD:SM,SM:VC,VC
QD=CH,CH:DB,DB:DM,DM:FL,FL:IT,IT:NU,NU:QD,QD:SM,SM:VC,VC
SM=DB,DB:DM,DM:FL,FL:IT,IT:NU,NU:QD,QD:SM,SM:VC,VC
TM=AD,NA
TS=DT,DT:TS,TS
TT=AD,NA
TZ=AD,NA
VC=CH,CH:DB,DB:DM,DM:DT,DT:FL,FL:IT,IT:NU,NU:QD,QD:SM,SM:TS,TS:VC,VC


[Directives Session]

[I18N Encoding Mapping DATABASE:PARACCEL] 
3=US-ASCII 
4=iso-8859-1