;***********************************************************************
;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: //uda/main/prod/dmd/rds/oledb/cogdm92.ini#3 $
;
; Module:
;    cogdm92.ini
;
; Purpose:
;    This module contains the SQL-92 Entry Level definitions for OLE-DB.
;
; Notes:
;    Do NOT modify this file.  Doing so could result in unknown behavior,
;    possibly resulting in application aborts.
; ************************************************************************

[Exception Commands]
Select="select"
Insert="insert"
Insert Select=T
Update="update"
Delete="delete"
Call=" "; Don't think it's used.
SelectInto="select into"; don't think it's used

[Exceptions Clauses]
From="from"
Where="where"
Group_By="group by"
Having="having"
Qualify=

[Exceptions Tables]
Simple=T
Derived=F
Joined=F
Simple_And_Joined=F

[Exceptions Joins]
;
; Entry Level does not support joins.
; Many fields left empty and not explicitly set to F because they are not
; boolean fields
;
Cross=F
Inner=F
Left_Outer=F
Right_Outer=F
Full_Outer=F
Union_Join=F
Nested_Outer=F
Inner_Tbl_Restrict=T
Outer_Syntax=F
Optnl_Tbl_Restrict=T
Outer_Tbl_List=F
Non_Equi_Joins=F
One_Outer=F
Natural=F
Left_Nested=F
Right_Nested=F
Optnl_Tbl_Join_Restrict=T
Two_Sided_Join_Restrict=T
Two_Sided_Join_Restrict_Filter=T
Optnl_Tbl_Join_Filter=F
Optnl_Tbl_Filter=F
Prsrv_Tbl_Join_Filter=F
Prsrv_Tbl_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
Non_Join_Expr=F
Non_Join_Non_Equi_Expr=F
Only_Eql_With_And=F
On_Condition_Functions=F
Left_Pre=
Left_Eql=
Left_Post=
Right_Pre=
Right_Eql=
Right_Post=
Inner_Col_Pre=
Inner_Col_Post=
Full_Pre=
Full_Post=
Full_Syntax=
Cross_Syntax=
Union_Syntax=
Inner_Syntax=
Natural_Syntax=
Join_Strategy=

[Exceptions Predicates]
Between="between"
In="in"
Like="like"
Is_Null="is null"
Any="any"
All="all"
Exists="exists"
NotLike="not like"
Unique=
Match=
Overlaps=

[Exceptions Aggregates]
Max="max"
Min="min"
Sum="sum"
Avg="avg"
Count="count"
Count_Star="count (*)"
Stddev=
Variance=
First=F
Last=F
RMAX=F
RMIN=F
RSUM=F
RAVG=F
RCOUNT=F
RCountstar=F
RDiff=F
XMovingsum=F
XMovingavg=F
Xntile=F
Xtertile=F
Xmax=F
Xmin=F
Xsum=F
Xavg=F
Xcount=F
XcountStar=F
Xfirst=F
Xlast=F
Xrank=F
Xperc=F
Xratio=F
Xstddev=F
Xvariance=F

[Exceptions Set Operators]
Distinct="distinct"
Union="union"
Except=
Intersect=
Order_By="order by"
Union_All=T
Except_All=F
Intersect_All=F
Order_By_Limit=

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

[Exceptions Value Expressions]
Case_Simple=F
Case_Searched=F
Case=F
Coalesce=F
Nullif=F
Extract=F
Position=F
Char_Length=F
Octet_Length=F
Bit_Length=F
Substring=F
Upper=F
Lower=F
Strcat=F
Cast=F
NullConst=F ; not used in the code. Set it to foalse for good.
User=F ; not used in the code. Set it to foalse for good.
Extract_Year=
Extract_Month=
Extract_Day=
Extract_Hours=
Extract_Minutes=
Extract_Seconds=

[Exceptions General]
Null="null"
Count_Value_Expr=F
Count_Non_Distinct=F
Count_Blob=T
Correlated_Subqueries=T
;Nulls_Sort_Last=T ; don't think the sort order is part of the sql standard
Like_Value_Expr=F
Group_By_Expr=F
Group_By_Ordinal=T
Group_By_Alias=T
Multiple_Distinct=F
Subqueries=T
Subquery_Column_Alias=T
Cross_Product=T
Distinct_Aggregates=T
Aggregate_Value_Expr=T
Aggregate_In_Expr=T
Substring_On_Expr=T
Is_Null_Value_Expr=F
Subquery_In_Case=F
Subquery_In_Group_By=T
Subquery_In_Having=T
Subquery_In_Aggregate=T
Nested_Case=F
Not_In_Subquery=T
Group_By_In_Exists=F
Group_By_Sorted=T; not specified in the standard but leave as T because that is the default.
Simple_Filter=F
Order_By_Alias=T
Case_To_Decode=F

[Exceptions Literals]
Date_Literal=F
Time_Literal=F
Interval_Literal=F
Timestamp_Literal=F
Alt_Date_Literal_Assignment=F
Alt_Date_Literal_Between=F
Alt_Date_Literal_Comparison=F
Alt_Date_Literal_In=F
Alt_Date_Literal_Insert_Value=F
Alt_Date_Literal_Str=
Alt_Interval_Literal_Str=
Alt_Time_Literal_Str=
Alt_Timestamp_Literal_Str=
Date_Add_Function_Str=
Date_Format_Str=
Date_Literal_Str=
Date_Sub_Function_Str=
Interval_Format_Str=
Interval_Literal_Str=
Time_Format_Str=
Time_Literal_Str=
Timestamp_Format_Str=
Timestamp_Literal_Str=
Zero_Date_Literal_Str=
Zero_Interval_Literal_Str=
Zero_Time_Literal_Str=
Zero_Timestamp_Literal_Str=

[Exceptions Misc]
No_And_Parentheses=F
Case_Parentheses=F

[Exceptions Delimiters]
; Use defaults
;Wholename_Delimiter=
;Catalog_Delimiter=
;Schema_Delimiter=
;Table_Delimiter=
;Column_Delimiter=
;Procedure_Delimiter=

[Exceptions Separators]
; Use defaults
;Catalog_Separator=
;Schema_Separator=
;Table_Separator=

[Operator Comparison]
; Currently we only set for datetime which is not supported
; in entry level so leave empty.

[Directives Session]
; Use Defaults
;First_Row_Pos=
;Dop_Pos=
;Ordered_Pos=
;Star_Pos=
;First_Row_Text =
;Dop_Text =
;Ordered_Text=
;Star_Text =
;Directive_Separator=
;Append_Pre_Text=
;Append_Post_Text=
;Block_Comment_Pre_Text=
;Block_Comment_Post_Text=

[Uda Misc]
Check_Input_Parm_Types=F