;*********************************************************************** ;Licensed Materials - Property of IBM ; ;BI and PM: UDA ; ;(C) Copyright IBM Corp. 2005, 2010 ; ;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/cogdmol.ini#7 $ ; ; Module: ; cogdmol.ini ; ; Purpose: ; This module contains the OLE DB information. ; ; Notes: ; Do NOT modify this file. Doing so could result in unknown behavior, ; possibly resulting in application aborts. ; ************************************************************************ [DATABASE:ORACLE] DBINFO_TYPE="OR" ; ;DB Key ; dbkeyType="sqlDbKey" dbkeySize="19" unqualifiedDbkey="rowid" qualifiedDbkey="%s.rowid" [PROVIDER:MSDAORA.DLL] VERSION_STRING_0="07.00.0000 Oracle7 Server Release 7.2" MAP_TO_0="07.02.0000" VERSION_STRING_1="07.00.0000 Oracle7 Server Release 7.3" MAP_TO_1="07.03.0000" ; ;DB Key ; dbkeySize="18" oledbDbkeyType="DBTYPE_CHAR" DelimitMetadataNames="T" [DATABASE:ORACLE VERSION:07.02] ; If using Microsoft OLE DB provider for Oracle, the entry - ; DBINFO_SUBTYPE should be specified in the connection string. DBINFO_SUBTYPE="ORACLE7.2" [DATABASE:ORACLE VERSION:07.03] ; If using Microsoft OLE DB provider for Oracle, the entry - ; DBINFO_SUBTYPE should be specified in the connection string. DBINFO_SUBTYPE="ORACLE7.3" [DATABASE:ORACLE VERSION:08.00] ; If using Microsoft OLE DB provider for Oracle, the entry - ; DBINFO_SUBTYPE should be specified in the connection string. DBINFO_SUBTYPE="ORACLE8.0" [DATABASE:ORACLE VERSION:08.01] ; If using Microsoft OLE DB provider for Oracle, the entry - ; DBINFO_SUBTYPE should be specified in the connection string. DBINFO_SUBTYPE="ORACLE8.1" [DATABASE:MICROSOFT SQL SERVER] DBINFO_TYPE="MS" MAX_ROWSETS="1" Procedure Cursors="T" Unicode Literals="F" ;SQL Server always append ';x' after a procedure/function name (where x is a number) ;We'd discovered that for functions the number x is always 0 and for procedures ;the number x is always non-zero Function Name Suffix=";0" No RET for Procedure="T" ; Call ICommandWithParameter::SetParameterInfo() ; if subquery contains parameter SetSubqueryParamInfo="T" ;Procedure requests against SQLServer version 2000 and up, ;use SQL statement instead of using IDBSShemaRowset, since ;it does not give enough information to distinguish between ;functions, procedures and other types of functions. SQL used for Procedure Request="T" ;Support synonym metadata requests SynonymsSupported="T" [DATABASE:MICROSOFT SQL SERVER VERSION:08.00] SynonymsSupported="F" [DATABASE:MICROSOFT SQL SERVER VERSION:06.50] Unicode Literals="F" [Operator Cast PROVIDER:SQLOLEDB.DLL] AD=DT,NA:TM,NA:TZ,NA [Exceptions Value Expressions PROVIDER:SQLOLEDB.DLL] Current_Timestamp=F [Builtin Functions PROVIDER:SQLOLEDB.DLL] s:coguda#cast_timestamp(%1cndtsz)=CAST( %1 AS DATETIME ); [DATABASE:DTS PACKAGE ROWSET PROVIDER] DBINFO_TYPE="MD" [DATABASE:OLAP SERVER] DBINFO_TYPE="MD" [DATABASE:AS/400] DBINFO_TYPE="D2" TableNameQualifiers="2" CatalogSeparator="\"" SchemaSeparator="\"" IdentifierQuoteChar="\"" [Misc] ; Specifies which conversion algorithm to use for decimal data types Numeric_binding=C