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

[Database Functions]
;
; Note: ODBC grammar doesn't define any functions. Applications 
; inquire the driver about supported functions, using SQLGetInfo API function.
; As this file is for use by OLE-DB, no functions are defined here.
;

[Exceptions Aggregates]
;
; ODBC Minimum grammar doesn't define any aggregate functions. They
; are part of the CORE grammar
;

[Exceptions Aggregates CORE]
;
; ODBC Core grammar defines five aggregate functions
;
Avg="avg"
Count="count"
Count_star="count(*)"
Max="max"
Min="min"
Sum="sum"

[Exceptions Clauses]
;
; In ODBC minimum grammar, only FROM, WHERE and ORDER BY clauses are permited
;
From="from"
Where="where"


[Exceptions Commands]
;
; In ODBC minimum grammar stored procedures are not permited.
;
Delete="delete "
Insert="insert "
Select="select "
Update="update "

[Exceptions Delimiters]
; 
; Double quotes are used by default to quote identifiers in ODBC 
;
Catalog_Delimiter="\""
Schema_Delimiter="\""
Table_Delimiter="\""
Column_Delimiter="\""
;Procedure_Delimiter="\""
;Wholename_Delimiter="\""


[Exceptions General]
; Correlated_Subqueries is set in the gateway using SQLGetInfo(SQL_SUBQUERIES)
; Subqueries is set in the gateway using SQLGetInfo(SQL_SUBQUERIES)
; Subquery_Column_Alias is set in the gateway using SQLGetInfo(SQL_SUBQUERIES and SQL_COLUMN_ALIAS)
Aggregate_In_Expr=F
Aggregate_Value_Expr=F
Correlated_Subqueries=F
Count_Blob=F
Count_Non_Distinct=F
Count_Value_Expr=F
Cross_Product=T
Distinct_Aggregates=F
Group_By_Alias=F 
Group_By_Expr=F
Group_By_In_Exists=F
Group_By_Ordinal=F
Group_By_Sorted=F
Like_Value_Expr=F
Multiple_Distinct=F
Nested_Case=F
Not_In_Subquery=F
Nulls_Sort_Last=F
Subqueries=F 
Subquery_Column_Alias=F
Subquery_In_Case=F
Subquery_In_Group_By=F
Subquery_In_Having=F
Substring_On_Expr=F

[Exceptions Joins]
;
; ODBC Minimum grammar doesn't support joined tables
;
Cross=F
Full_Non_Equi_Join=F
Full_Outer=F
Full_Post=""
Full_Pre=""
Full_Syntax=""
Inner=F
Inner_Col_Post=""
Inner_Col_Pre=""
Inner_Syntax=""
Inner_Tbl_Restrict=F
Left_Eql=""
Left_Nested=F
Left_Outer=F
Left_Post=""
Left_Pre=""
Natural=F
Natural_Syntax=""
Nested_Outer=F
Non_Equi_Joins=F
One_Outer=F
On_Condition_Between_Predicate=F
On_Condition_In_Predicate=F
On_Condition_IsNull_Predicate=F
On_Condition_Like_Predicate=F
On_Condition_Not_Predicate=F
On_Condition_Set_Functions=F
On_Condition_Subqueries=F
Optnl_Tbl_Filter=F
Optnl_Tbl_Join_Filter=F
Optnl_Tbl_Join_Restrict=F
Outer_Tbl_List=F
Optnl_Tbl_Restrict=T
Outer_Syntax=F
Right_Eql=""
Right_Nested=F
Right_Outer=F
Right_Post=""
Right_Pre=""
Two_Sided_Join_Restrict=F
Union_Join=F
Union_Syntax=""

[Exceptions Literals]
;
; Minimum ODBC grammar is required to support only CHAR and VARCHAR
; 
Date_Literal=F
Interval_Literal=F
Time_Literal=F
Timestamp_Literal=F

[Exceptions Operators]
; 
; Minimum ODBC grammar supports expressions, comparison predicates, 
; NOT, AND and OR
;
Add="+"
Sub="-"
Mul="*"
Div="/"

And="and"
Or="or"
Not="not"


Eql="="
Geq=">="
Grt=">"
Leq="<="
Les="<"
Neq="<>"

[Exceptions Predicates]
; 
; Minimum ODBC grammar supports comparison predicates, LIKE and IS [NOT] NULL
;
All=
Any=
Between=
Exists=
In=
Is_Null="is null"
Like="like"
Match=
;NotLike=T
Overlaps=
Unique=
 
[Exceptions Separators]
;
Catalog_Separator="."
Schema_Separator="."
Table_Separator="."

[Exceptions Set Operators]
; Entries added here affect all ODBC connections.
; For this reason overwrites should be added to subsections only.
; Union is set in the gateway using SQLGetInfo(SQL_UNION)
; Union_All is set in the gateway using SQLGetInfo(SQL_UNION)
; The entries below show the ODBC defaults.
Distinct="distinct"
Except=
Except_All=F
Intersect=
Intersect_All=F
Union=
Union_All=F

[Exceptions Tables]
; Entries added here affect all ODBC connections.
; For this reason overwrites should be added to subsections only.
; The entries below show the ODBC defaults.
Derived=F
Joined=F
Simple=T


[Exceptions Value Expressions]
; Entries added here affect all ODBC connections.
; For this reason overwrites should be added to subsections only.
; Cast is set in the gateway using SQLGetInfo(SQL_CONVERT_FUNCTIONS)
; Lower is set in the gateway using SQLGetInfo(SQL_STRING_FUNCTIONS)
; Position is set in the gateway using SQLGetInfo(SQL_STRING_FUNCTIONS)
; StrCat is set in the gateway using SQLGetInfo(SQL_STRING_FUNCTIONS)
; Substring is set in the gateway using SQLGetInfo(SQL_STRING_FUNCTIONS)
; Upper is set in the gateway using SQLGetInfo(SQL_STRING_FUNCTIONS)
; The entries below show the ODBC defaults.
Bit_Length=F
Case=F
Cast=F
Char_Length=F
Coalesce=F
Extract=F
Lower=F
Nullif=F
Octet_Length=F
Position=F
StrCat=F
Substring=F
Upper=F

[Operator Addition]
Date=
Time=
Timestamp=
Interval=

[Operator Subtraction]
Date=
Time=
Timestamp=
Interval=