analytics/bin/cogdmod_ig.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: //uda/main/prod/dmd/sgi/odbc35/generic_od/cogdmod_ig.ini#3 $
;
; Module:
;    cogdmig.ini
;
; Purpose:
;    This module contains the Ingres gateway information.
;
; Notes:
;    Do NOT modify this file.  Doing so could result in unknown behavior
;    by the Ingres gateway, possibly resulting in application aborts.
;
; ************************************************************************

[Expression Results]

[Exceptions Commands]
  Call=

[Exceptions Clauses]

[Exceptions Tables]
  Derived=F
  Joined=F

[Exceptions Joins]
  Inner=F
  Left_Outer=T
  Right_Outer=T
  Full_Outer=T
  Cross=F
  Left_Eql=" LEFT JOIN "
  Right_Eql=" RIGHT JOIN "
  Nested_Outer=T
  Left_Nested=T
  Right_Nested=T
  Left_Pre=""
  Left_Post=""
  Right_Pre=""
  Right_Post=""
  Inner_Tbl_Restrict=F
  Optnl_Tbl_Restrict=F
  Outer_Tbl_List=F
  Outer_Syntax=T   
  Optnl_Tbl_Filter=T
  Optnl_Tbl_Join_Filter=T

  Non_Equi_Joins=T
  Full_Non_Equi_Join=T
  On_Condition_Set_Functions=F
  On_Condition_Subqueries=F
  On_Condition_Not_Predicate=T
  On_Condition_In_Predicate=T
  On_Condition_Between_Predicate=T
  On_Condition_Like_Predicate=T
  On_Condition_IsNull_Predicate=T

  Full_Syntax=" FULL JOIN "
  Cross_Syntax=
  Union_Syntax=
  Inner_Syntax=
  Natural_Syntax=
  Full_Pre=
  Full_Post=

[Exceptions Joins INGRES6.4]
  Inner=F
  Left_Outer=F
  Right_Outer=F
  Full_Outer=F
  Cross=F
  Nested_Outer=F
  Inner_Tbl_Restrict=F
  Optnl_Tbl_Restrict=F
  Non_Equi_Joins=F
  Outer_Tbl_List=F
  Outer_Syntax=F   
  Optnl_Tbl_Filter=F
  Optnl_Tbl_Join_Filter=F

  Full_Non_Equi_Join=F
  On_Condition_Set_Functions=F
  On_Condition_Subqueries=F
  On_Condition_Not_Predicate=F
  On_Condition_In_Predicate=F
  On_Condition_Between_Predicate=F
  On_Condition_Like_Predicate=F
  On_Condition_IsNull_Predicate=F

  Full_Syntax=
  Cross_Syntax=
  Union_Syntax=
  Inner_Syntax=
  Natural_Syntax=
  Full_Pre=
  Full_Post=

[Exceptions Predicates]

[Exceptions Aggregates]
  Max="max"
  Min="min"
  Sum="sum"
  Avg="avg"
  Count_Non_Distinct=T
  Count_Value_Expr=T
  Count_Literal=T
  Count="count"
  Count_Star="count(*)"

[Exceptions Set Operators]
  Distinct=
  Union="union"
  Union_All=T

[Exceptions Set Operators INGRES6.4]
  Union=
  Union_All=F

[Exceptions Operators]
  Neq=" <> "

[Exceptions Value Expressions]
  Position=C
  Char_Length=F
  Lower=C
  Upper=C
  Strcat=C

[Exceptions General]
  Multiple_Distinct=T
  Like_Value_Expr=T
  Count_Blob=F
  Is_Null_Value_Expr=T
  Order_By_Alias=F

[Exceptions Literals]
Date_Literal=C
Date_Format_Str="DD MMM YYYY"
Date_Literal_Str="date( '%s-%s-%s' )"
Timestamp_Literal=C
Timestamp_Format_Str="DD MMM YYYY HH MM SS"
Timestamp_Literal_Str="date( '%s-%s-%s %s:%s:%s' )"
Time_Literal=C
Time_Format_Str="HH MM SS"
Time_Literal_Str="'%s:%s:%s'"
Interval_Literal=C
Interval_Format_Str="DD HH MM SS"
Interval_Literal_Str="date( '%s days %s hrs %s mins %s secs' )"
Date_Add_Function_Str="?1 + ?2"
Date_Sub_Function_Str="(?1 - ?2)"

Zero_Date_Literal_Str="date('')"
Zero_Timestamp_Literal_Str="date('')"

[Exceptions Delimiters]
;
; Specifies the delimiter character for each name part.
;
; If a delimiter is set to nothing, then the database does not support the
; delimiting of that name part; otherwise, the specified string is used to
; delimit the corresponding name part.
;
; NOTE: if Wholename specified and not empty then this indicates that fully
; 		qualified names are delimited with this character; 
;		For example,
;		"myCatalog.mySchema.myTable.myColumn"
;
; NOTE: for a double quote (") entry, specifies "\"".
;
Catalog_Delimiter=
Schema_Delimiter=
Table_Delimiter=
Column_Delimiter=
Procedure_Delimiter=
Wholename_Delimiter=

[Exceptions Separators]
;
; Specifies the name separator that follows the type of name.
; [<catalog><catalogSeparator>][<schema><schemaSeparator>][<table><tableSeparator>][<column>]
; [<catalog><catalogSeparator>][<schema><schemaSeparator>][<procedure>]
;
Catalog_Separator="."
Schema_Separator="."
Table_Separator="."


[Operator Addition]
Date=IV,TS
Time=
TimeStamp=IV,TS
Interval=DT,TS:TS,TS:IV,IV

[Operator Subtraction]
Date=DT,IV:TS,IV:IV,TS
Time=
;TimeStamp=DT,IV:TS,IV:IV,TS
Interval=IV,IV

[Operator Comparison]
Date=DT,OK:TS,OK
TimeStamp=DT,OK:TS,OK
Interval=IV,OK

[Builtin Functions]
c:lower(%1c)=lowercase(%1);
n:mod(%1n, %2n)=mod(%1, %2);
n:position(%1c, %2c)=locate(%2, %1);
c:upper(%1c)=uppercase(%1);
c:cast_char(%1bcdints)=char(%1);
c:cast_varchar(%1bcdints)=varchar(%1);
d:cast_date(%1c)=date(%1);
n:cast_float(%1bcn)=float8(%1);
n:cast_integer(%1bcn)=int4(%1);
n:cast_smallint(%1bcn)=int2(%1);
c:coguda#concat(%1c, %2c)=concat(%1, %2);

[Database Functions]
n:abs(%1n)=abs(%1);
n:exp(%1n)=exp(%1);
bcdints:nullif(%1bcdints, %2bcdints)=ifnull(%1, %2);
n:power(%1n, %2n)=%1**%2;
n:sqrt(%1n)=sqrt(%1);
c:trim(%1c)=trim(%1);

[Gateway Environment]
;
; INGRES has only one data type for representing DATEs and INTERVALs.
; Therefore, the type of data stored in a DATE column is not known.
; In fact, you could store DATE and INTERVAL data within the same
; column. Typically, you would only store one type of data in a column.
; 'DATE COLUMNS' allows you to select the default data type for all
; INGRES DATE columns as
;
;      TIMESTAMP (s),     (default)
;      DATE      (d),     
;      INTERVAL  (i), or
;      CHAR      (c).
;
; You can 'typecast' columns that do not conform to this default
; with these functions:
; 
;      ---------------------- ------------------------------------
;      Function              |  Action
;      ---------------------- ------------------------------------
;      ig_date_as_interval   | Treat column data as INTERVAL
;      ig_date_as_char       | Treat column data as CHAR
;      ig_date_as_date       | Treat column data as DATE
;      ig_date_as_timestamp  | Treat column data as absolute DATE
;
DATE COLUMNS=s

[UDA USER OPTIONS]
Attach=