;*********************************************************************** ;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. ; [][][][] ; [][][] ; ; 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 ] ; =,{;,} ; ; 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