analytics/bin/cogdmxml.ini

;***********************************************************************
;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:
;    cogdmxml.ini
;
; Purpose:
;    This module contains the SGIXML gateway information.
;
; Notes:
;    Do NOT modify this file.  Doing so could result in unknown behavior,
;    possibly resulting in application aborts.
; ************************************************************************
[Expression Results]

[Exceptions Commands]	
	Insert=
	Update=
	Delete=

[Exceptions Clauses]
	Where=
	Group_By=
	Having=


[Exceptions Tables]
	Simple=T
	Derived=F
	Joined=F
	Simple_And_Joined=F
	UniqueName_Prefix="coguda"
	; Maximum length of aliases.
	; XML does not use ALIAS, so the value
	; returned here can be arbitrarily large.
	; So we'll just set it to 128 here
	SQL_MAX_TABLE_NAME_LEN="128"


[Exceptions Joins]
	Inner=F
	Left_Outer=F
	Right_Outer=F
	Full_Outer=F
	Cross=F
	Product_Join=F
	Optnl_Tbl_Filter=F
	Prsrv_Tbl_Filter=F
	On_Condition_Set_Functions=F
	Non_Join_Expr=F
	Non_Join_Non_Equi_Expr=F

[Exceptions Predicates]
	Between=
	In=
	Like=
	Is_Null=
	Any=
	All=
	Exists=
	Unique=
	Match=
	Overlaps=
	NotLike=


[Exceptions Aggregates]
;	Max=
;	Min=
;	Sum=
;	Avg=
;	Count=
;	Count_Star=
;	Stddev=
;	Stddev_Pop=
;	Stddev_Samp=
;	Variance=
;	Variance_Pop=
;	Variance_Samp=
;	Grouping=
;	Rank=
;	Dense_Rank=
;	Percent_Rank=
;	Cume_Dist=
;	Percentile=
;	First=F
;	Last=F
;	Ravg=F
;	Rcount=F
;	Rcountstar=F
;	Rdiff=F
;	Rmax=F
;	Rmin=F
;	Rsum=F
;	Xavg=F
;	Xcount=F
;	Xcountstar=F
;	Xfirst=F
;	Xlast=F
;	Xmax=F
;	Xmin=F
;	Xmovingavg=F
;	Xmovingsum=F
;	Xntile=F
;	Xperc=F
;	Xrank=F
;	Xratio=F
;	Xstddev=F
;	Xsum=F
;	Xtertile=F
;	Xvariance=F

[Exceptions Set Operators]
	Distinct=
	Except=
	Except_All=F
	Intersect=
	Intersect_All=F
	Order_By=
	Order_By_Limit="0"
	Union=
	Union_All=F

[Exceptions Operators]
	Add=
	Sub=
	Mul=
	Div=
	Eql=
	Neq=
	Grt=
	Geq=
	Les=
	Leq=
	Neg=
	And=
	Or=
	Not=


[Exceptions Value Expressions]
	Char_Length=F
	Lower=F
	Upper=F
	Substring=F
	Position=F
	Trim=F
	StrCat=F
	User=F
	Null=

[Exceptions General]
	Group_By_Alias=F
	Group_By_Expr=F
	Group_By_In_Exists=F
	Group_By_Sorted=F
	Subquery_Column_Alias=F
	Order_By_Alias=F
	Order_By_Name=F
	Count_Literal=F
	Count_Non_Distinct=F
	Subqueries=F
	Aggregate_In_Expr=F
	Aggregate_Value_Expr=F
	Cross_Product=F
	Substring_On_Expr=F
	Multiple_Distinct=F
	Subquery_In_Group_By=F
	Boolean_Comparison=F
	;Trakker 521401
	Correlated_Subqueries=F

[Exceptions Literals] 
	Date_Literal=F
	Interval_Literal=F
	IntervalYM_Literal=F
	Time_Literal=F
	TimeTZ_Literal=F
	Timestamp_Literal=F
	TimestampTZ_Literal=F
	Boolean_Literal=F
	True_Literal_Str=
	False_Literal_Str=
	Unknown_Literal_Str=

[Exceptions Misc]

[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 "\"".
;
; SAP does not support delimiter
	Wholename_Delimiter=""
	Catalog_Delimiter=""
	Schema_Delimiter=""
	Table_Delimiter=""
	Column_Delimiter=""
	Procedure_Delimiter=""
	Numeric_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>]
;
; SAP use '~' to denote columns belonging to a table
	Table_Separator="."

;
; List of expression results.
;
[Expression Results]

;
; Operations supported and results of the supported operation.
; The format is;
; [Operator <operator name>]
; <LHS>=<RHS>,<RES>{;<RHS>,<RES>}
;
; where
;
; LHS = data type of left hand side of operation
; RHS = data type of right hand side of operation
; RES = result data type of operation
;
; LHS, RHS and RES values may be one of:
;
;   Name			Abbreviation			DMS Data Type
;	CHAR			CH						sqlChar
;	VARCHAR			VC						sqlVarChar
;	LVARCHAR		LC						sqlLongVarChar
;	BINARY			BN						sqlBinary
;	VARBINARY		VB						sqlVarBinary
;	SMALLINT		SM						sqlSmallInt
;	INTEGER			IT						sqlInteger
;	QUAD			QD						sqlQuad
;	DECIMAL			DM						sqlDecimal
;	FLOAT			FL						sqlFloat
;	DOUBLE			DB						sqlDouble
;	DATE			DT						sqlDate
;	TIME			TM						sqlTime
;	TIMESTAMP		TS						sqlDateTime
;	INTERVAL		IV						sqlInterval
;	----			NA						sqlUnknownType
;
[Operator Addition]

[Operator Subtraction]

[Operator Multiplicateion]

[Operator Division]

[Operator Concatenation]

[Operator Comparison]

[Builtin Functions]
;
; Date/time functions
;

[Database Functions]
;
; Numeric functions
;

;
; Date/time functions
;

;
; String functions
;

;
; System functions
;

[Database Function Mappings]
;
; Numeric functions
;

;
; Date/time functions
;

;
; String functions
;

;
; System functions
;


[Special Case Information]

[Misc]
; Default processing mode
Processing Mode=Limited Local


; Maximum precision (in code points)
; for sqlVarChar = 32K - 1
maxVarcharPrecision=32767

; validation of input files
; T = always validate (default)
; F = never validate. 
validateWithSchema=T