;*********************************************************************** ;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_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=