;*********************************************************************** ;Licensed Materials - Property of IBM ; ;BI and PM: UDA ; ;(C) Copyright IBM Corp. 2005, 2020 ; ;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/sgi/odbc35/generic_od/cogdmod.ini#24 $ ; ; Module: ; cogdmod.ini ; ; Purpose: ; This module contains the ODBC gateway information. ; ; Notes: ; Do NOT modify this file. Doing so could result in unknown behavior ; by the ODBC gateway, possibly resulting in application aborts. ; ; ; Entries in this file are there to... ; 1) set an option to reflect what the driver/database can support. ; These are DbInfo entries which are set to reflect what the ; driver/database combination can support. Since these are set only ; to reflect what is supported, looking up the definition of the ; entry on the DbInfo web page is enough of an explanation of why ; it is there. ; 2) reflect problems that are encountered when using the driver/database ; combination These require an explanation of why they have been added ; to the cogdmod.ini file. ; All driver and database specific entries, those in sections labeled ; [DRIVER:xxxx] or [DATABASE:xxxx], require an explanation. ; Also included are those in DbInfo subsections that DO NOT reflect ; what the driver/database combination is documented to support. ; If, for example, a driver/database combination is documented to ; support the aggregate function count the entry count="count" ; would be added to the cogdmod.ini file with no explanation. ; However, if the count function is found to not work the way we ; require it to work the entry count= would be added to the ; cogdmod.ini file and a explanation is required. ; ; Tested driver/database combinations: ; ; The groups below indicate what driver/database combinations have been ; fully or partially tested in the gateway. Each group will have a single ; header line followed by one or more driver/database combination. ; ; The header line will have the form ; "STR1 driver attaching to STR2 database" where... ; STR1 is the common name for the vendor ; STR2 is the common name for the database ; ; The driver/database combination line will have the form ; "DRIVER:STR3 VERSION:STR4 DATABASE:STR5 VERSION:STR6(STR7)" where... ; STR3 is the text returned by a SQLGetInfo(SQL_DRIVER_NAME) ODBC call ; STR4 is the text returned by a SQLGetInfo(SQL_DRIVER_VER) ODBC call ; STR5 is the text returned by a SQLGetInfo(SQL_DBMS_NAME) ODBC call ; STR6 is the text returned by a SQLGetInfo(SQL_DBMS_VER) ODBC call ; STR7 indicates the extent that the combination has been tested where... ; "(C)" indicates entries have been added to completely support ; the driver/database combination. ; "(I)" indicates entries have been added to fix an issue with ; the driver/database combination. ; ; Versions will always be in the form XX.YY.ZZZZ. ; XX indicates the major version. ; YY indicates the minor version. ; ZZZZ indicates the release version. ; Question marks(?) in versions indicate that the information is not known. ; Hash marks(#) in versions indicate that the information is not used/needed. ; ; ; ; ; ; The groups are alphabetical, ordered ascending by STR3, STR4, STR5, STR6. ; ; Peregrine driver attaching to AssetCenter database ; DRIVER:ADBC32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.####(I) ; ; ??? driver attaching to ??? database ; DRIVER:ALLBASE.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.####(I) ; ; IBM driver attaching to DB2/400 SQL database ; DRIVER:CWBODBC.DLL VERSION:03.00.#### DATABASE:DB2/400 SQL VERSION:04.01.####(C) ; ; IBM driver attaching to DB2/400 SQL database ; DRIVER:CWBODBC.DLL VERSION:03.00.#### DATABASE:DB2/400 SQL VERSION:04.03.####(C) ; ; IBM driver attaching to DB2/400 SQL database ; DRIVER:CWBODBC.DLL VERSION:03.00.#### DATABASE:DB2/400 SQL VERSION:04.04.####(C) ; ; DB2 driver attaching to DB2(except on AS/400) database ; DRIVER:DB2CLI.DLL VERSION:05.02.#### DATABASE:DB2 VERSION:##.##.####(C) ; ; DB2 driver attaching to DB2(except on AS/400) database ; DRIVER:DB2CLIW.DLL VERSION:05.02.#### DATABASE:DB2 VERSION:##.##.####(C) ; ; Sybase Adaptive Server Anywhere driver attaching to a Adaptive Server Anywhere database ; DRIVER:DBODBC6.DLL VERSION:06.00.#### DATABASE:ADAPTIVE SERVER ANYWHERE VERSION:06.00.####(I) ; ; Sybase Adaptive Server Anywhere driver attaching to a Adaptive Server IQ database ; DRIVER:DBODBC6.DLL VERSION:06.00.#### DATABASE:ADAPTIVE SERVER IQ VERSION:12.00.####(I) ; ; EDA driver attaching to ??? database ; DRIVER:EDAODBC.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Striva DETAIL driver attaching to IMS\VSAM database ; DRIVER:DTLODBC.DLL VERSION:02.00.4000 DATABASE:DETAIL VERSION:01.00.0000(I) ; ; EDA 32 bit driver attaching to ??? database ; DRIVER:EDAODB32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; ??? driver attaching to ??? database ; DRIVER:EHNODBC3.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; ??? driver attaching to ??? database ; DRIVER:FASTPATH.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Interbase driver attaching to Interbase database ; DRIVER:IBINT13.DLL VERSION:03.11.#### DATABASE:INTERBASE VERSION:05.05.####(C) ; ; Intersolv driver attaching to Btrieve database ; DRIVER:IVBTR12.DLL VERSION:??.??.???? DATABASE:BTRIEVE VERSION:??.??.????(I) ; ; Intersolv driver attaching to dBASE, Clipper and FoxPro 3.0 databases ; DRIVER:IVDBF12.DLL VERSION:03.01.#### DATABASE:DBASE VERSION:03.00.####(I) ; ; Intersolv driver attaching to dBASE III, IV, V files; Clipper files; FoxPro 2.5, 2.6, 3.0, and 6.0 databases ; DRIVER:IVDBF14.DLL VERSION:03.50.#### DATABASE:DBASE VERSION:05.00.####(I) ; ; Intersolv driver attaching to Informix database ; DRIVER:IVINF709.DLL VERSION:02.12.#### DATABASE:INFORMIX VERSION:09.14.####(C) ; ; MERANT driver attaching to Informix database ; DRIVER:IVINF914.DLL VERSION:03.50.#### DATABASE:INFORMIX VERSION:09.14.####(I) ; ; Intersolv driver attaching to Oracle 7.3 database ; DRIVER:IVOR708.DLL VERSION:??.??.???? DATABASE:ORACLE VERSION:07.03.####(C) ; ; Intersolv driver attaching to Oracle 7.3 database ; DRIVER:IVOR712.DLL VERSION:??.??.???? DATABASE:ORACLE VERSION:07.03.####(C) ; ; Intersolv driver attaching to Oracle 7.3 database ; DRIVER:IVOR713.DLL VERSION:03.10.#### DATABASE:ORACLE VERSION:07.03.####(C) ; ; Intersolv driver attaching to Oracle 8.0 database ; DRIVER:IVOR813.DLL VERSION:03.10.#### DATABASE:ORACLE 8 VERSION:08.00.####(C) ; ; Intersolv driver attaching to Oracle 8.0 database ; DRIVER:IVOR814.DLL VERSION:03.50.#### DATABASE:ORACLE 8 VERSION:08.00.####(C) ; ; Intersolv driver attaching to Oracle 8.1 database ; DRIVER:IVOR815.DLL VERSION:03.60.#### DATABASE:ORACLE 8 VERSION:08.01.####(C) ; ; Intersolv driver attaching to Microsoft SQL Server database ; DRIVER:IVSS612.DLL VERSION:03.01.#### DATABASE:MICROSOFT SQL SERVER VERSION:06.50.####(C) ; ; Intersolv driver attaching to Sybase database ; DRIVER:IVSYB12.DLL VERSION:03.01.#### DATABASE:SYBASE VERSION:??.??.????(C) ; ; Microsoft oracle driver attaching to Oracle database ; DRIVER:MSORCL32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Navision ODBC driver attaching to Microsoft Business Solutions-Navision database ; DRIVER:NODBC.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Microsoft access driver attaching to Access database ; DRIVER:ODBCJT32.DLL VERSION:02.50.#### DATABASE:ACCESS VERSION:03.50.####(I) ; ; Microsoft access driver attaching to Access database ; DRIVER:ODBCJT32.DLL VERSION:03.50.#### DATABASE:ACCESS VERSION:03.50.####(I) ; ; Microsoft access driver attaching to Access database ; DRIVER:ODBCJT32.DLL VERSION:04.00.#### DATABASE:ACCESS VERSION:03.50.####(I) ; ; ??? driver attaching to ??? database ; DRIVER:ODBCLN32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; ??? driver attaching to ??? database ; DRIVER:ODNAV32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; OpenA driver attaching to OpenA database ; DRIVER:OPENA.DLL VERSION:04.200.### DATABASE:DMSII VERSION:01.00.####(I) ; ; PeopleSoft driver attaching to PeopleSoft database ; DRIVER:PSQODB32.DLL VERSION:01.00.#### DATABASE:MICROSFT VERSION:07.05.####(I) ; ; ??? driver attaching to ??? database ; DRIVER:QEDBF06.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; ??? driver attaching to ??? database ; DRIVER:QEDBF07.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; ??? driver attaching to ??? database ; DRIVER:QEDB207.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; ??? driver attaching to ??? database ; DRIVER:QESYB07.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Rational ODBC driver attaching to ??? database ; DRIVER:RATLXML.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Redbrick driver attaching to Red Brick database ; DRIVER:RB32ODBC.DLL VERSION:05.00.#### DATABASE:RED BRICK WAREHOUSE VERSION:03.##.####(I) ; ; Redbrick driver attaching to Red Brick database ; DRIVER:RB32ODBC.DLL VERSION:05.00.#### DATABASE:RED BRICK WAREHOUSE VERSION:04.##.####(I) ; ; Redbrick driver attaching to Red Brick database ; DRIVER:RB32ODBC.DLL VERSION:05.00.#### DATABASE:RED BRICK WAREHOUSE VERSION:05.##.####(I) ; ; Redbrick driver attaching to Red Brick database ; DRIVER:RB32ODBC.DLL VERSION:05.00.#### DATABASE:RED BRICK WAREHOUSE VERSION:06.##.####(I) ; ; ??? driver attaching to ??? database ; DRIVER:RBODBC32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; ??? driver attaching to ??? database ; DRIVER:RBODBC32.DLL VERSION:03.13.#### DATABASE:??? VERSION:??.??.????(I) ; ; ??? driver attaching to ??? database ; DRIVER:SCLIW16.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Simba driver attaching to Sybase database ; DRIVER:SIMBASYBASE.DLL VERSION:06.77.#### DATABASE:SYBASE VERSION:07.06.####(C) ; ; ??? driver attaching to ??? database ; DRIVER:SQRDB.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Microsoft driver attaching to Microsoft SQL Server database ; DRIVER:SQLSRV32.DLL VERSION:02.65.#### DATABASE:MICROSOFT SQL SERVER VERSION:06.50.####(C) ; ; Microsoft driver attaching to Microsoft SQL Server database ; DRIVER:SQLSRV32.DLL VERSION:03.70.#### DATABASE:MICROSOFT SQL SERVER VERSION:07.00.####(C) ; ; Microsoft driver attaching to Microsoft SQL Server database ; DRIVER:SQLSRV32.DLL VERSION:03.70.#### DATABASE:MICROSOFT SQL SERVER VERSION:08.00.####(C) ; ; Microsoft driver attaching to Microsoft SQL Server database ; DRIVER:SQLSRV.DLL VERSION:02.65.#### DATABASE:MICROSOFT SQL SERVER VERSION:06.00.####(C) ; ; Oracle ODBC driver attaching to oracle database ; DRIVER:SQO32_73.DLL VERSION:02.05.#### DATABASE:ORACLE VERSION:07.03.####(C) ; ; ??? driver attaching to ??? database ; DRIVER:SQOCI32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Oracle ODBC driver attaching to oracle database ; DRIVER:SQORA32.DLL VERSION:08.00.#### DATABASE:ORACLE8 VERSION:08.00.####(C) ; ; ??? driver attaching to ??? database ; DRIVER:SQRDB32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; ??? driver attaching to ??? database ; DRIVER:SRDB32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Intersolv driver attaching to Sybase IQ database ; DRIVER:SYIQ95.DLL VERSION:02.12.#### DATABASE:SYBASE IQ VERSION:11.05.####(C) ; ; Intersolv driver attaching to Sybase IQ database ; DRIVER:SYIQNT.DLL VERSION:02.12.#### DATABASE:SYBASE IQ VERSION:11.05.####(C) ; ; Intersolv driver attaching to Sybase IQ database ; DRIVER:SYIQW3.DLL VERSION:02.12.#### DATABASE:SYBASE IQ VERSION:11.05.####(C) ; ; NCR driver attaching to Teradata database ; DRIVER:TDATA32.DLL VERSION:02.02.#### DATABASE:TERADATA VERSION:02.00.####(I) ; ; NCR driver attaching to Teradata database ; DRIVER:TDATA32.DLL VERSION:02.02.#### DATABASE:TERADATA VERSION:02.01.####(I) ; ; Tandem driver attaching to ??? database ; DRIVER:TDMSRVR.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Tandem 32 bit driver attaching to ??? database ; DRIVER:TDMSRVR32.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; ; Microsoft Visual FoxPro driver attaching to Visual FoxPro database ; DRIVER:VFPODBC.DLL VERSION:06.00.#### DATABASE:VISUAL FOXPRO VERSION:03.00.####(I) ; ; Btrieve driver attaching to Btrieve database ; DRIVER:W32BTINT.DLL VERSION:02.01.#### DATABASE:BT VERSION:05.01.####(I) ; ; SCO ODBC driver (SCO Vision SQL-Retriever) attaching to Informix 7 database ; DRIVER:VWODBC32.DLL VERSION:04.15.#### DATABASE:INFORMIX VERSION:07.12.####(C) ; ; Watcom driver attaching to Sybase SQL Anywhere database ; DRIVER:WOD40T.DLL VERSION:??.??.???? DATABASE:WATCOM SQL VERSION:??.??.????(I) ; ; Watcom driver attaching to Sybase SQL Anywhere database ; DRIVER:WOD40W.DLL VERSION:??.??.???? DATABASE:WATCOM SQL VERSION:??.??.????(I) ; ; Sybase SQL Anywhere driver attaching to Sybase SQL Anywhere database ; DRIVER:WOD50T.DLL VERSION:05.00.#### DATABASE:SYBASE SQL ANYWHERE VERSION:05.50.####(I) ; ; Sybase SQL Anywhere driver attaching to Sybase SQL Anywhere database ; DRIVER:WOD50W.DLL VERSION:05.00.#### DATABASE:SYBASE SQL ANYWHERE VERSION:05.50.####(I) ; ; ??? driver attaching to ??? database ; DRIVER:WSQLODBC.DLL VERSION:??.??.???? DATABASE:??? VERSION:??.??.????(I) ; Composite driver attaching to ??? database ; DRIVER:COMPOSITE30.DLL VERSION:01.00.0000 DBMS:COMPOSITE VERSION:01.00.0000(C) ; ; ; Perforce driver attaching to Perforce SCM database ; DRIVER:P4ODBC.DLL ; ; ************************************************************************ ; ; To enable tracing of ODBC routines called, uncomment the following two lines ; and specify a vaild trace file name. ;[TRACE] ;output= ; ; To enable tracing of data in the bound buffers, uncomment the following line ;Data=yes ; ; To enable printing the elapsed times for ODBC function calls, uncomment the following line: ;Timer=yes ; [Database Functions] ; Functions that are data base specific should be defined in a ; subsection using the data base for which they will be used. ; ; "b" stands for boolean. ; "c" stands for character. ; "d" stands for date. ; "i" stands for the interval. ; "n" stands for the numeric. ; "s" stands for the timestamp. ; "t" stands for the time. ; "l" stands for literal strings that will have their quotes removed ; ; To have consistency, all the re-defined database functions are defined ; in the gateway ini files and not here [Database Functions] ; ;These definitions are created by the gateway in run time ;and are here for information purposes only. ; ;n:position(%1c,%2c)=\{fn LOCATE( %1, %2 )\}; ;n:char_length(%1c)=\{fn CHAR_LENGTH(%1)\}; ;n:char_length(%1c)=\{fn CHARACTER_LENGTH(%1)\}; ;n:octet_length(%1c)=\{fn OCTET_LENGTH(%1)\}; ;n:bit_length(%1c)=\{fn BIT_LENGTH(%1)\}; ;c:substring(%1c, %2n, %3n)=\{fn SUBSTRING(%1, %2, %3)\}; ;c:upper(%1c)=\{fn UCASE(%1)\}; ;c:lower(%1c)=\{fn LCASE(%1)\}; ;c:coguda#concat(%1bcdintsx,%2bcdintsx)=\{fn CONCAT(%1, %2)\}; ;n:abs(%1n)=\{fn ABS(%1) \}; ;n:mod(%1n,%2n)=\{fn MOD(%1,%2) \}; ;n:ln(%1n)=\{fn LOG(%1) \}; ;n:exp(%1n)=\{fn EXP(%1) \}; ;n:power(%1n,%2n)=\{fn POWER(%1,%2) \}; ;n:sqrt(%1n)=\{fn SQRT(%1) \}; ;n:floor(%1n)=\{fn FLOOR(%1) \}; ;n:ceiling(%1n)=\{fn CEILING(%1) \}; ;d:current_date=\{fn CURRENT_DATE() \}; ;d:current_date=\{fn CURDATE() \}; ;t:localtime({%1n})=\{fn CURRENT_TIME({%1}) \}; ;s:localtimestamp({%1n})=\{fn CURRENT_TIMESTAMP({%1}) \}; ;cx:trim_leading_spaces(%1cx)=\{fn LTRIM(%1)\}; ;cx:trim_trailing_spaces(%1cx)=\{fn RTRIM(%1)\}; ;cx:trim_both_spaces(%1cx)=\{fn LTRIM(\{fn RTRIM(%1)\})\}; [Database Functions DATABASE:IBM COGNOS REAL-TIME MONITORING] n:ceiling(%1n)=CEIL(%1); c:trim_both_spaces(%1c)=LTRIM(RTRIM(%1)); c:trim_leading_spaces(%1c)=LTRIM(%1); c:trim_trailing_spaces(%1c)=RTRIM(%1); [Database Functions DRIVER:DBODBC6.DLL] c:substring(%1c, %2n, %3n)=CAST(SUBSTR(%1, %2, %3) as varchar(2000)); n:cast_decimal(%1n)=CAST(%1 AS DECIMAL); [Builtin Functions DATABASE:NETEZZASQL] t:localtime()=CAST(CURRENT_TIME AS TIME); s:localtimestamp({%1n})=CAST(CURRENT_TIMESTAMP AS TIMESTAMP); n:_months_between(%1ds,%2ds)= CAST(MONTHS_BETWEEN (%1, %2) AS INTEGER); n:_days_between(%1s,%2s)=(cast(%1 as DATE) - cast(%2 as DATE)); n:_days_between(%1s,%2d)=(cast(%1 as DATE) - (%2)); n:_days_between(%1d,%2s)=((%1) - cast(%2 as DATE)); n:_days_between(%1d,%2d)=((%1) - (%2)); n:_years_between(%1ds,%2ds)=EXTRACT (YEAR FROM AGE ( %1, %2)); d:_add_months(%1d,%2n)=cast(((%1) + INTERVAL '1 MONTH' * (%2)) as DATE); s:_add_months(%1s,%2n)=((%1) + INTERVAL '1 MONTH' * (%2)); d:_add_years(%1d,%2n)=cast(((%1) + INTERVAL '1 YEAR' * (%2)) as DATE); s:_add_years(%1s,%2n)=((%1) + INTERVAL '1 YEAR' * (%2)); d:_add_days(%1d,%2n)=cast(((%1) + ((%2) * INTERVAL '1 DAY')) as DATE); s:_add_days(%1s,%2n)=((%1) + ((%2) * INTERVAL '1 DAY')); s:_add_hours(%1s,%2n)=((%1) + ((%2) * INTERVAL '1 HOUR')); t:_add_hours(%1t,%2n)=((%1) + ((%2) * INTERVAL '1 HOUR')); s:_add_minutes(%1s,%2n)=((%1) + ((%2) * INTERVAL '1 MINUTE')); t:_add_minutes(%1t,%2n)=((%1) + ((%2) * INTERVAL '1 MINUTE')); s:_add_seconds(%1s,%2n)=((%1) + ((%2) * INTERVAL '1 SECOND')); t:_add_seconds(%1t,%2n)=((%1) + ((%2) * INTERVAL '1 SECOND')); n:_day_of_year(%1ds)=EXTRACT (doy from %1); n:_week_of_year(%1ds)=CAST( to_char(cast ( %1 as timestamp ),'IW') as integer); n:_day_of_week(%1ds, %2n)= (MOD( CAST( TO_CHAR( %1, 'D' ) AS INTEGER ) + 6 - %2, 7 ) + 1); d:_first_of_month(%1d)=(%1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY' ) + INTERVAL '1 DAY'); s:_first_of_month(%1s)=(%1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY' ) + INTERVAL '1 DAY'); d:_last_of_month(%1d)=(ADD_MONTHS( ( %1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY' ) + INTERVAL '1 DAY' ), 1 ) - INTERVAL '1 DAY'); s:_last_of_month(%1s)=(ADD_MONTHS( ( %1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY' ) + INTERVAL '1 DAY' ), 1 ) - INTERVAL '1 DAY'); n:_days_to_end_of_month(%1ds)=(EXTRACT( DAY FROM (ADD_MONTHS(%1 - ( EXTRACT( DAY FROM %1 ) * INTERVAL '1 DAY') + INTERVAL '1 DAY', 1) - INTERVAL '1 DAY')) - EXTRACT(DAY FROM %1)); n:_round(%1n, %2n)=ROUND(%1,%2); n:round(%1n, %2n)=ROUND(%1,%2); [Builtin Functions DRIVER:NSQLODBC.DLL VERSION:03.00] n:_round(%1n, %2n)=; n:round(%1n, %2n)=; [Builtin Functions DRIVER:NSQLODBC.DLL VERSION:03.01.0000] n:_round(%1n, %2n)=; n:round(%1n, %2n)=; [Builtin Functions DRIVER:NSQLODBC.DLL VERSION:03.01.0002] n:_round(%1n, %2n)=; n:round(%1n, %2n)=; [Builtin Functions DATABASE:HP NEOVIEW DATABASE] ; note: neoview datediff() function counts boundary crossings not just full units. n:_months_between(%1ds,%2ds)=DATEDIFF(MONTH,%2,%1); n:_days_between(%1sd,%2sd)=DATEDIFF(DAY,%2,%1); n:_years_between(%1ds,%2ds)=DATEDIFF(YEAR,%2,%1); d:_add_months(%1ds,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL MONTH) ); d:_add_years(%1ds,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL YEAR) ); s:_add_days(%1s,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL DAY) ); d:_add_days(%1d,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL DAY) ); s:_add_hours(%1s,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL HOUR) ); t:_add_hours(%1t,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL HOUR) ); s:_add_minutes(%1s,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL MINUTE) ); t:_add_minutes(%1t,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL MINUTE) ); s:_add_seconds(%1s,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL SECOND) ); t:_add_seconds(%1t,%2n)=DATE_ADD( %1, CAST( %2 AS INTERVAL SECOND) ); n:_day_of_year(%1ds)=DAYOFYEAR (%1); ;WEEK() function is not iso 8601 compliant. ;You can enable it for speed but the answers are off by +- 1 ;n:_week_of_year(%1ds)=WEEK(%1); n:day_of_week( %1ds, %2n )=(MOD(DAYOFWEEK(%1)+7-%2,7)+1); s:_first_of_month(%1s)=DATE_TRUNC('MONTH',%1); d:_first_of_month(%1d)=CAST( DATE_TRUNC('MONTH',%1) AS DATE); s:_last_of_month(%1s)=DATE_TRUNC('MONTH',DATE_ADD(%1,INTERVAL '1' MONTH))-INTERVAL '1' DAY; d:_last_of_month(%1d)=CAST( DATE_TRUNC('MONTH',DATE_ADD(%1,INTERVAL '1' MONTH))-INTERVAL '1' DAY as DATE); n:_days_to_end_of_month(%1sd)=DATEDIFF(DAY,%1,DATE_TRUNC('MONTH',DATE_ADD( %1, INTERVAL '1' MONTH)))-1; [Database Functions DATABASE:NETEZZASQL] ; For trakker#555650, No ascii definition for the netezza, this caused the local processing, ; UDA ascii function has different definition. So add the ascii definition for netezza. n:ascii(%1c)=ascii(%1); n:power(%1n,%2n)=POW(%1,%2); [Database Functions DRIVER:ODBCJT32.DLL] ;For trakker#405577, when accessing blob against MS Access, ;if the special columns/unique indices contain nullable columns ;then the generated SQL to access the blob will use CAST function ;because COALESCE is not supported by MS Access, and since when ;generating the statement with CAST to DECIMAL, precision and scale values ;are provided, and it's not needed here, so we need to find a way to ;accept those info and make them irrelevant to the actual function ;so I'm modifying the line to use multiplication by 0 to nullify ;the affect of precision/scale info ;NOTE: Access describes the result data type for concat as varchar ;instead of sqlText when concatnating sqlText. n:cast_decimal(%1bcdints {,%2n, %3n})=((%1 {+ 0 * %2 * %3}) * 1.0); n:cast_float(%1bcdn)=(%1 * 1e0); ;Trakker 528680 The functions CURDATE and CURTIME return VarChar instead of a DateTime. c:curdate()= \{fn CURDATE() \}; c:curtime()=\{fn CURTIME() \}; [Exceptions Value Expressions DRIVER:ODBCJT32.DLL] Current_Date=F [Database Functions DRIVER:WOD50T.DLL] c:substring(%1c, %2n, %3n)=CAST(SUBSTR(%1, %2, %3) as varchar(2000)); n:cast_decimal(%1n)=CAST(%1 AS DECIMAL); [Database Functions DRIVER:WOD50T.DLL VERSION:05.00] n:position(%1c, %2c {, %3n})=\{fn LOCATE(%2, %1 {, %3})\}; [Database Functions DRIVER:WOD50W.DLL VERSION:05.00] n:position(%1c, %2c {, %3n})=\{fn LOCATE(%2, %1 {, %3})\}; [Database Functions DRIVER:SYIQNT.DLL] c:cast_numberToString(%1bcdinst)=CAST(%1 AS CHAR(254)); [Database Functions DATABASE:ADAPTER FOR BAANERP DB DRIVER] s:localtimestamp({%1n})=CURRENT_TIMESTAMP; [Exceptions Aggregates] ; Entries added here affect all ODBC connections. ; For this reason overwrites should be added to subsections only. ; The entries below show the ODBC defaults. Avg="avg" Count="count" Count_star="count(*)" Max="max" Min="min" ; ravg ; rdiff ; rsum ; Stddev Sum="sum" ; Variance ; xmovingavg ; xmovingsum ; xntile ; xrank ; xratio ; xstddev ; xtertile ; xvariance [Exceptions Aggregate DATABASE:IBM COGNOS REAL-TIME MONITORING] Avg= Count= Count_star= Max= Min= Sum= Between= In= Like= Is_Null= Any= All= Exists= Unique= Match= Overlaps= NotLike= [Exceptions Aggregates DRIVER:DTLODBC.DLL] Avg= Count= Count_star= Max= Min= Sum= [Exceptions Clauses] ; Entries added here affect all ODBC connections. ; For this reason overwrites should be added to subsections only. ; Group_By is set in the gateway using SQLGetInfo(SQL_GROUP_BY) ; The entries below show the ODBC defaults. From="from" Group_By="group by" Having="having" Where="where" [Exceptions Clauses DATABASE:IBM COGNOS REAL-TIME MONITORING] Group_By= Having= Where= [Exceptions Clauses DRIVER:DTLODBC.DLL] Group_By= Having= Where= [Exceptions Clauses DATABASE:NETEZZASQL] With="with " [Exceptions Clauses DATABASE:NETEZZASQL VERSION:05] With= [Exceptions Clauses DATABASE:NETEZZASQL VERSION:04] With= [Exceptions Clauses DATABASE:NETEZZASQL VERSION:03] With= [Exceptions Commands] ; Entries added here affect all ODBC connections. ; For this reason overwrites should be added to subsections only. ; The entries below show the ODBC defaults. Call="call " Delete="delete " Insert="insert " Select="select " Update="update " [Exceptions Commands DRIVER:DTLODBC.DLL] Call= Select_Star="F" [Exceptions Delimiters] ; Entries added here affect all ODBC connections. ; For this reason overwrites should be added to subsections only. ; The entries below show the ODBC defaults. Catalog_Delimiter="\"" Schema_Delimiter="\"" Table_Delimiter="\"" Column_Delimiter="\"" Procedure_Delimiter="\"" Wholename_Delimiter="\"" [Exceptions General] ; Entries added here affect all ODBC connections. ; For this reason overwrites should be added to subsections only. ; Correlated_Subqueries is set in the gateway using SQLGetInfo(SQL_SUBQUERIES) ; Nulls_Sort_Last is set in the gateway using SQLGetInfo(SQL_NULL_COLLATION) ; 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) ; The entries below show the ODBC defaults. Aggregate_In_Expr=T Aggregate_Value_Expr=T Boolean_Comparison=F Correlated_Subqueries=T Count_Blob=F Count_Non_Distinct=T Count_Value_Expr=F Cross_Product=T Distinct_Aggregates=T Group_By_Expr=F Like_Value_Expr=F Multiple_Distinct=T ; Null=T Nulls_Sort_Last=F Order_By_Alias=F Substring_On_Expr=T Subqueries=T Subquery_Column_Alias=F [Exceptions General DATABASE:ADAPTIVE SERVER ANYWHERE] Like_Value_Expr=T Nulls_Sort_Last=F [Exceptions General DATABASE:COMPOSITE] Count_Value_Expr=T Count_Literal=T Distinct_Aggregates=F Group_By_Expr=T [Exceptions General DRIVER:DTLODBC.DLL] Aggregate_In_Expr=F Aggregate_Value_Expr=F Correlated_Subqueries=F Count_Non_Distinct=F Cross_Product=F Distinct_Aggregates=F Multiple_Distinct=F Order_By_Name=F Substring_On_Expr=F Subqueries=F Aggregate_Literal=F Group_By_In_Exists=F Group_By_Sorted=F Nested_Case=F Null= Subquery_In_Group_By=F Not_In_Subquery=F Subquery_In_Case=F Subquery_In_Having=F Group_By_Strict=F [Exceptions General DRIVER:EHNODBC3.DLL] Correlated_Subqueries=F [Exceptions General DATABASE:NETEZZASQL] Olap_Null_Order=T Localtime=C Localtimestamp=C Count_Value_Expr=T Count_Literal=T Distinct_Aggregates=T Group_By_Expr=T Correlated_Subqueries=T Is_Null_Value_Expr=T Order_By_In_Derived_Table=T Is_Null_Value_Parm=T [Exceptions General DATABASE:NETEZZASQL VERSION:04.00] Olap_Null_Order=F [Exceptions General DATABASE:NETEZZASQL VERSION:04.05] Olap_Null_Order=F [Exceptions General DATABASE:NETEZZASQL VERSION:03] Olap_Null_Order=F [Exceptions General DRIVER:ODBCJT16.DLL] Distinct_Aggregates=F Like_Value_Expr=T Nulls_Sort_Last=F Order_By_Alias=F [Exceptions General DRIVER:ODBCJT32.DLL] Count_Literal=T Distinct_Aggregates=F Like_Value_Expr=T Nulls_Sort_Last=F Order_By_Alias=F Like_With_Escape=F Group_By_Expr=T Jet_Aliases=T [Exceptions General DRIVER:ACEODBC.DLL] Distinct_Aggregates=F [Exceptions General DRIVER:ODNAV32.DLL] Like_Value_Expr=T Group_By_Expr=T [Exceptions General DRIVER:CACHEODBC.DLL] Group_By_Expr=T Remove_Parameter_Cast=T [Exceptions General DRIVER:QEDBF06.DLL] Nulls_Sort_Last=F [Exceptions General DRIVER:QEDBF07.DLL] Nulls_Sort_Last=F [Exceptions General DRIVER:QESYB07.DLL] Nulls_Sort_Last=F [Exceptions General DRIVER:SCLIW16.DLL] Nulls_Sort_Last=F [Exceptions General DRIVER:SQRDB.DLL] Count_Non_Distinct=F Like_Value_Expr=T [Exceptions General DRIVER:WOD40T.DLL] Like_Value_Expr=T Nulls_Sort_Last=F [Exceptions General DRIVER:WOD40W.DLL] Like_Value_Expr=T Nulls_Sort_Last=F [Exceptions General DRIVER:WOD50T.DLL] Like_Value_Expr=T Nulls_Sort_Last=F [Exceptions General DRIVER:WOD50W.DLL] Like_Value_Expr=T Nulls_Sort_Last=F [Exceptions General DRIVER:WSQLODBC.DLL] Like_Value_Expr=T Nulls_Sort_Last=F [Exceptions General DATABASE:ADAPTER FOR BAANERP DB DRIVER] Parameter_Markers=F [Exceptions Joins DATABASE:IBM COGNOS REAL-TIME MONITORING] 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 On_Condition_Between_Predicate=F Non_Join_Expr=F Non_Join_Non_Equi_Expr=F ; NEW SECTION FOR PROGRESS Driver. Trakker 562102 [Exceptions Joins DRIVER:PGPRO1019.DLL] Cross=T Cross_Syntax=" CROSS JOIN " Full_Outer=F Full_Post="" Full_Pre="" Full_Syntax="" Inner=T Inner_Col_Post="(+)" Left_Eql=" = " Left_Nested=T Left_Post="" Left_Pre="" Natural=T Natural_Syntax=" NATURAL JOIN " Nested_Inner=F Nested_Outer=T Non_Equi_Joins=T On_Condition_Between_Predicate=T On_Condition_In_Predicate=T On_Condition_Like_Predicate=T One_Outer=F Optnl_Tbl_Filter=T Optnl_Tbl_Join_Filter=T Optnl_Tbl_Restrict=F Outer_Syntax=F Right_Eql=" = " Right_Post="" Right_Pre="" [Exceptions Joins] ; Entries added here affect all ODBC connections. ; For this reason overwrites should be added to subsections only. ; Full_Outer is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Inner is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Left_Eql is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Left_Outer is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Left_Post is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Left_Pre is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Right_Eql is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Right_Nested is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Right_Outer is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Right_Post is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; Right_Pre is set in the gateway using SQLGetInfo(SQL_OJ_CAPABILITIES and SQL_OUTER_JOINS) ; The entries below show the ODBC defaults. Cross=F Cross_Syntax="" Full_Non_Equi_Join=F Full_Outer=T Full_Post=" } " Full_Pre=" {oj " Full_Syntax=" FULL OUTER JOIN " Inner=F Inner_Col_Post="" Inner_Col_Pre="" Inner_Syntax=" INNER JOIN " Inner_Tbl_Restrict=F Left_Eql=" LEFT OUTER JOIN " Left_Nested=F Left_Outer=T Left_Post=" } " Left_Pre=" {oj " 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=T On_Condition_Like_Predicate=F On_Condition_Not_Predicate=T On_Condition_Set_Functions=F On_Condition_Subqueries=T Optnl_Tbl_Filter=F Optnl_Tbl_Join_Filter=F Optnl_Tbl_Join_Restrict=F Outer_Tbl_List=F Optnl_Tbl_Restrict=T Outer_Syntax=T Right_Eql=" RIGHT OUTER JOIN " Right_Nested=T Right_Outer=T Right_Post=" } " Right_Pre=" {oj " Two_Sided_Join_Restrict=F Union_Syntax="" [Exceptions Joins DATABASE:ADAPTIVE SERVER ANYWHERE] Cross=T Cross_Syntax=" CROSS JOIN " Full_Outer=F Full_Post="" Full_Pre="" Full_Syntax="" Inner=T Inner_Syntax=" INNER JOIN " Left_Eql=" LEFT OUTER JOIN " Left_Nested=T Left_Outer=T Left_Post="" Left_Pre="" Natural=T Natural_Syntax=" NATURAL JOIN " Nested_Outer=T Non_Equi_Joins=T On_Condition_Between_Predicate=T On_Condition_In_Predicate=T On_Condition_IsNull_Predicate=T On_Condition_Like_Predicate=T On_Condition_Not_Predicate=T On_Condition_Set_Functions=F On_Condition_Subqueries=T One_Outer=F Optnl_Tbl_Filter=T Optnl_Tbl_Join_Filter=T Outer_Tbl_List=F Optnl_Tbl_Restrict=F Outer_Syntax=T Right_Eql=" RIGHT OUTER JOIN " Right_Nested=T Right_Outer=T Right_Post="" Right_Pre="" Two_Sided_Join_Restrict=F Union_Syntax="" [Exceptions Joins DRIVER:CACHEODBC.DLL] Cross=T Cross_Syntax=" CROSS JOIN " Full_Outer=F Full_Post="" Full_Pre="" Full_Syntax="" Inner=T Inner_Syntax=" INNER JOIN " Left_Eql=" LEFT OUTER JOIN " Left_Nested=T Left_Outer=T Left_Post="" Left_Pre="" On_Condition_Not_Predicate=F Optnl_Tbl_Restrict=F Right_Eql=" RIGHT OUTER JOIN " Right_Nested=T Right_Post="" Right_Pre="" ;See Trakker 529058 Inner_Tbl_Restrict=T Optnl_Tbl_Restrict=T Nested_Inner=F Right_Outer=F ;Trakker 529611 Optnl_Tbl_Filter=T [Exceptions Joins DRIVER:DTLODBC.DLL] Full_Outer=F Full_Post= Full_Pre= Full_Syntax= Left_Eql= Left_Outer=F Left_Post= Left_Pre= On_Condition_IsNull_Predicate=F On_Condition_Not_Predicate=F On_Condition_Subqueries=F Outer_Syntax=F Right_Nested=F Right_Outer=F Inner_Tbl_Restrict=F Nested_Inner=F Non_Join_Expr=F Non_Join_Non_Equi_Expr=F On_Condition_Functions=F Optnl_Tbl_Restrict=F Prsrv_Tbl_Filter=F Prsrv_Tbl_Join_Filter=F Right_Eql= [Exceptions Joins DATABASE:NETEZZASQL] Cross=T Cross_Syntax=" CROSS JOIN " Full_Non_Equi_Join=F Full_Outer=T Full_Post="" Full_Pre="" Full_Syntax=" FULL OUTER JOIN " Inner=T Inner_Syntax=" INNER JOIN " Left_Eql=" LEFT OUTER JOIN " Left_Nested=T Left_Outer=T Left_Post="" Left_Pre="" Optnl_Tbl_Restrict=F Inner_Tbl_Restrict=F Right_Eql=" RIGHT OUTER JOIN " Right_Nested=T Right_Outer=T Right_Post="" Right_Pre= On_Condition_Between_Predicate=T On_Condition_In_Predicate=T On_Condition_Isnull_Predicate=T On_Condition_Like_Predicate=T On_Condition_Not_Predicate=T On_Condition_Or_Predicate=T On_Condition_Set_Functions=T [Exceptions Joins DATABASE:SYBASE SQL ANYWHERE] Cross=T Cross_Syntax=" CROSS JOIN " Full_Outer=F Full_Post="" Full_Pre="" Full_Syntax="" Inner=T Inner_Syntax=" INNER JOIN " Left_Eql=" LEFT OUTER JOIN " Left_Nested=T Left_Outer=T Left_Post="" Left_Pre="" Natural=T Natural_Syntax=" NATURAL JOIN " Nested_Outer=T Non_Equi_Joins=T On_Condition_Between_Predicate=T On_Condition_In_Predicate=T On_Condition_IsNull_Predicate=T On_Condition_Like_Predicate=T On_Condition_Not_Predicate=T On_Condition_Set_Functions=F On_Condition_Subqueries=T One_Outer=F Optnl_Tbl_Filter=T Optnl_Tbl_Join_Filter=T Outer_Tbl_List=F Optnl_Tbl_Restrict=F Outer_Syntax=T Right_Eql=" RIGHT OUTER JOIN " Right_Nested=T Right_Outer=T Right_Post="" Right_Pre="" Two_Sided_Join_Restrict=F Union_Syntax="" [Exceptions Joins DATABASE:COMPOSITE] Cross=T Cross_Syntax=" CROSS JOIN " Inner=T Inner_Syntax=" INNER JOIN " On_Condition_In_Predicate=T On_Condition_Like_Predicate=T On_Condition_Or_Predicate=T Full_Post="" Full_Pre="" Left_Post="" Left_Pre="" Right_Post="" Right_Pre="" [Exceptions Joins DRIVER:ODBCJT32.DLL] Full_Outer=F Left_Outer=T Left_Post="" Left_Pre="" On_Condition_IsNull_Predicate=F On_Condition_Subqueries=F One_Outer=T ;Filter on the preserved table is not supported. Prsrv_Tbl_Join_Filter=F Right_Outer=T Right_Post="" Right_Pre="" [Exceptions Joins DRIVER:OPENA.DLL] Nested_Outer=T [Exceptions Joins DRIVER:SWODBC32.DLL] Left_Nested=T [Exceptions Joins DRIVER:TDMSRVR.DLL] Left_Nested=F Nested_Outer=F Right_Nested=T [Exceptions Joins DRIVER:TDMSRVR32.DLL] Left_Nested=F Nested_Outer=F Right_Nested=T [Exceptions Joins DRIVER:ODNAV32.DLL] Cross=T Cross_Syntax=" , " Inner=T Nested_Outer=T Non_Equi_Joins=T One_Outer=T Full_Outer=F On_Condition_Between_Predicate=T On_Condition_In_Predicate=T On_Condition_Like_Predicate=T On_Condition_Not_Predicate=T [Exceptions Joins DATABASE:ADAPTER FOR BAANERP DB DRIVER] On_Condition_Or_Predicate=F Full_Post="" Full_Pre="" Left_Post="" Left_Pre="" Right_Post="" Right_Pre="" Full_Outer=F Full_Syntax= [Exceptions Joins DATABASE:HP NEOVIEW DATABASE] On_Condition_Between_Predicate=T On_Condition_In_Predicate=T On_Condition_Like_Predicate=T On_Condition_Or_Predicate=T On_Condition_Set_Functions=T On_Condition_Not_Predicate=T On_Condition_Isnull_Predicate=T [Exceptions Literals] ; The entries below show the ODBC defaults. ; If the data source supports the call SQLGetTypeInfo ; then all the following flags will be over written by ; information retrieved from the data source. 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= Boolean_Literal=F Date_Add_Function_Str= Date_Format_Str="YYYY MM DD" Date_Literal=C Date_Literal_Str="{d '%s-%s-%s'}" Date_Sub_Function_Str= False_Literal_Str= Interval_Format_Str= Interval_Literal=F Interval_Literal_Str= IntervalYM_Format_Str= IntervalYM_Literal=F IntervalYM_Literal_Str= Time_Format_Str="HH MM SS" Time_Literal=C Time_Literal_Str="{t '%s:%s:%s'}" TimeTZ_Format_Str= TimeTZ_Literal=F TimeTZ_Literal_Str= Timestamp_Format_Str="YYYY MM DD HH MM SS" Timestamp_Literal=C Timestamp_Literal_Str="{ts '%s-%s-%s %s:%s:%s'}" TimestampTZ_Format_Str= TimestampTZ_Literal=F TimestampTZ_Literal_Str= True_Literal_Str= Unknown_Literal_Str= Zero_Date_Literal_Str= Zero_Timestamp_Literal_Str= [Exceptions Literals DATABASE:IBM COGNOS REAL-TIME MONITORING] ;Alt_Date_Literal_Str="{d '%s-%s-%s'}" NChar_Literal=F ;Date_Literal=F [Exceptions Literals DATABASE:NETEZZASQL] Date_Literal_Str="DATE '%s-%s-%s'" Time_Literal_Str="TIME '%s:%s:%s.%s'" Timestamp_Literal_Str="TIMESTAMP '%s-%s-%s %s:%s:%s.%s'" Time_Format_Str="HH MM SS FFFFFF" NChar_Literal=T [Exceptions Literals DATABASE:ADAPTER FOR BAANERP DB DRIVER] ; Date literals Date_Literal_Str="DATE '%s-%s-%s'" ; Timestamp literals Timestamp_Literal_Str="TIMESTAMP '%s-%s-%s %s:%s:%s'" [Exceptions Operators] ; Entries added here affect all ODBC connections. ; For this reason overwrites should be added to subsections only. ; The entries below show the ODBC defaults. Add="+" And="and" Div="/" Eql="=" Geq=">=" Grt=">" Leq="<=" Les="<" Mul="*" ;Neg="-" Neq="<>" Not="not" Or="or" Sub="-" [Exceptions Operators DATABASE:IBM COGNOS REAL-TIME MONITORING] Add= Sub= Mul= Div= Eql= Neq= Grt= Geq= Les= Leq= Neg= And= Or= Not= [Exceptions Operators DRIVER:DTLODBC.DLL] Add= And= Div= Eql= Geq= Grt= Leq= Les= Mul= Neg= Neq= Not= Or= Sub= [Exceptions Predicates] ; Entries added here affect all ODBC connections. ; For this reason overwrites should be added to subsections only. ; The entries below show the ODBC defaults. All= Exists="exists " [Exceptions Predicates DATABASE:IBM COGNOS REAL-TIME MONITORING] Between= In= Like= Is_Null= Any= All= Exists= Unique= Match= Overlaps= NotLike= [Exceptions Predicates DATABASE:SYBASE SQL ANYWHERE] All="all" [Exceptions Predicates DRIVER:DTLODBC.DLL] Any= Exists= Between= In= Is_Null= Like= Match= NotLike= Unique= [Exceptions Predicates DATABASE:NETEZZASQL] All="all" [Exceptions Predicates DRIVER:ODBCJT32.DLL] All="all" [Exceptions Predicates DATABASE:COMPOSITE] Any= Between= Exists= [Exceptions Separators] ; Entries added here affect all ODBC connections. ; For this reason overwrites should be added to subsections only. ; Catalog_Separator is set in the gateway using SQLGetInfo(SQL_QUALIFIER_NAME_SEPARATOR) ; Schema_Separator is set in the gateway using SQLGetInfo(SQL_QUALIFIER_NAME_SEPARATOR) ; only if SQLGetInfo(SQL_OWNER_TERM) indicates the data source does not support schemas. ; The entries below show the ODBC defaults. 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= Except= Except_All=F Intersect= Intersect_All=F ;Order_By= Union= Union_All=F [Exceptions Set Operators DATABASE:IBM COGNOS REAL-TIME MONITORING] Order_By= Order_By_Limit="0" [Exceptions Set Operators DRIVER:DTLODBC.DLL] Distinct= Order_By= Order_By_Limit="0" [Exceptions Set Operators DRIVER:ODBCJT32.DLL] Distinct="distinct" [Exceptions Set Operators DRIVER:ACEODBC.DLL] Distinct="distinct" [Exceptions Set Operators DRIVER:ODNAV32.DLL] Distinct="distinct" [Exceptions Set Operators DRIVER:CACHEODBC.DLL] Distinct="distinct" Union="union" Union_All=T [Exceptions Set Operators DATABASE:COMPOSITE] Distinct="distinct" [Exceptions Set Operators DATABASE:NETEZZASQL] Distinct="distinct" Except=" except " Except_All=T Intersect="intersect" Intersect_All=T Union="union" Union_All=T [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 UniqueName_Prefix="coguda" [Exceptions Tables DATABASE:IBM COGNOS REAL-TIME MONITORING] Derived=F Joined=F Simple_And_Joined=F UniqueName_Prefix="coguda" [Exceptions Tables DATABASE:ADAPTIVE SERVER ANYWHERE] Derived=T [Exceptions Tables DATABASE:RDB] Derived=T [Exceptions Tables DRIVER:DTLODBC.DLL] Simple_And_Joined=F [Exceptions Tables DATABASE:NETEZZASQL] Derived=T Joined=T [Exceptions Tables DRIVER:ODBCJT32.DLL] Derived=T Simple_And_Joined=F [Exceptions Tables DRIVER:ODNAV32.DLL] Joined=T Derived=T [Exceptions Tables DRIVER:CACHEODBC.DLL] Derived=T [Exceptions Tables DATABASE:COMPOSITE] Derived=T Joined=T [Exceptions Tables DATABASE:ADAPTER FOR BAANERP DB DRIVER] Joined=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 [Exceptions Value Expressions DATABASE:IBM COGNOS REAL-TIME MONITORING] Case=T Case_Simple=T Case_Searched=F Trim=F Cast=C Char_Length=F Lower=T Position=T Substring=T Upper=T Current_Date=F Current_Time=F Current_Timestamp=F Localtime=F Localtimestamp=F Abs=T Ceiling=C Exp=T Floor=T ln=F Mod=T Sqrt=T Trim_Both_Spaces=C Trim_Leading_Spaces=C Trim_Trailing_Spaces=C Power=T [Exceptions Value Expressions DATABASE:ADAPTIVE SERVER ANYWHERE] Case=T Case_Simple=T Case_Searched=T [Exceptions Value Expressions DRIVER:DTLODBC.DLL] NullConst=F [Exceptions Value Expressions DRIVER:ODNAV32.DLL] Case=T Case_Simple=T Case_Searched=T [Exceptions Value Expressions DRIVER:CACHEODBC.DLL] Case=T Case_Simple=T Case_Searched=T Coalesce=T Cast=T StrCat=T [Exceptions Value Expressions DATABASE:COMPOSITE] case=T Case_Simple=T Case_Searched=T Cast=T Char_Length=F Coalesce=F Extract=F Lower=T Nullif=F StrCat=T Substring=T Upper=T [Exceptions Value Expressions DATABASE:ADAPTER FOR BAANERP DB DRIVER] Case_Simple=T Trim=T Mod=F Strcat=T Current_Date=T ; According to the SQL99 standard, Current_Timestamp returns a timestamp ; with time zone value which is not supported by ODBC. Current_Timestamp=F Localtimestamp=C [Exceptions Value Expressions DATABASE:NETEZZASQL] Bit_Length=F abs=T Case=T Cast=T Ceiling=T Char_Length=T Coalesce=T Exp=T Extract=T Current_Date=T Current_Time=F Current_Timestamp=F floor=T Lower=T Ln=T Nullif=T mod=T position=T power=T sqrt=T StrCat=T Substring=T trim=T Upper=T [Exceptions OLAP Functions] [Exceptions OLAP Functions DATABASE:NETEZZASQL] Olap_Distinct=T Olap_First_Value="first_value" Olap_Last_Value="last_value" ;COGCQ00674367 Olap_Last_Value_Default="ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING" Olap_Variance="variance" Olap_Max="max" Olap_Min="min" Olap_Sum="sum" Olap_Avg="avg" Olap_Count="count" Olap_Count_Star="count(*)" Olap_Stddev_Pop="stddev_pop" Olap_Var_Pop="var_pop" Olap_Stddev_Samp="stddev_samp" Olap_Var_Samp="var_samp" Olap_Rank="rank" Olap_Dense_Rank="dense_rank" Olap_Row_Number="row_number" Olap_Percent_Rank="percent_rank" Olap_Cume_Dist="cume_dist" Olap_Ntile="ntile" [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:05.00] Olap_Percent_Rank= Olap_Cume_Dist= Olap_Ntile= [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:04.00] Olap_Distinct=F Olap_Percent_Rank= Olap_Cume_Dist= Olap_Ntile= [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:04.06] Olap_Percent_Rank= Olap_Cume_Dist= Olap_Ntile= [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:04.05] Olap_Distinct=F Olap_Percent_Rank= Olap_Cume_Dist= Olap_Ntile= [Exceptions OLAP Functions DATABASE:NETEZZASQL VERSION:03] Olap_Distinct=F Olap_Percent_Rank= Olap_Cume_Dist= Olap_Ntile= [Operator Addition] Date= Time= Timestamp= Interval= [Operator Addition DATABASE:COMPOSITE] Date=DT,DT:TS,TS Timestamp=DT,TS:TS,TS [Operator Subtraction] Date= Time= Timestamp= Interval= [Operator Comparison DATABASE:COMPOSITE] Date=DT,OK Time=TM,OK Timestamp=TS,OK Interval= [Operator Comparison DATABASE:ADAPTIVE SERVER ANYWHERE] Date=DT,OK:TS,OK Timestamp=DT,OK:TS,OK Time=TM,OK:TS,OK [Operator Comparison DATABASE:NETEZZASQL] Date=DT,OK:TS,OK Time=TM,OK:TS,OK Timestamp=DT,OK:TS,OK Interval= [Operator Comparison DATABASE:SYBASE SQL ANYWHERE] Date=DT,OK:TS,OK Timestamp=DT,OK:TS,OK Time=TM,OK:TS,OK [Operator Comparison DRIVER:ODBCJT32.DLL] Date=DT,OK:TS,OK Timestamp=DT,OK:TS,OK Time=TM,OK:TS,OK [Operator Comparison DATABASE:ADAPTER FOR BAANERP DB DRIVER] Date=DT,OK Timestamp=TS,OK Interval= Time= ; From this point on this ini file contains entries pertaining to ; the operation of the gateway through the ODBC driver being used. ; The section name used to set entries for a particular driver ; consists of the driver name with a possible driver version. ; (ie: DRIVER:[ VERSION:] ) ; The section name used to set entries for a particular database ; consists of the database name with a possible database version. ; (ie: DATABASE:[ VERSION:] ) ; To get the... The gateway uses... ; driver_name SQLGetInfo(SQL_DRIVER_NAME) ; driver_version SQLGetInfo(SQL_DRIVER_VER) ; database_name SQLGetInfo(SQL_DBMS_NAME) ; database_version SQLGetInfo(SQL_DBMS_VER) ; All entries are terminated with a semi comma character. ; The possible exceptions, listed alphabetical for easy lookup, ; that can be set are... ; Keyword Ascending=; ; If given, the default ascending keyword, "asc" will be replaced ; with this literal. For some drivers this keyword is optional or ; invalid, an blank entry will remove the keyword. ; Convert To Blob Limit=; ; The number will indicate the size limit for LongVarChar and ; LongVarBinary data. If the data size is greater then the ; specified size the data type will be treated as blob data. ; By default the size limit is 32K. ; Cursor Type for Deletes=[FORWARD|STATIC|KEYSET|DYNAMIC]; ; If given, this cursor type will be used for delete ; statements instead of the default cursor type for ; the data source. For definitions of the different cursor ; types refer to the SQLSetStmtOption(SQL_CURSOR_TYPE) ; function in the ODBC manual. ; Cursor Type for Inserts=[FORWARD|STATIC|KEYSET|DYNAMIC]; ; If given, this cursor type will be used for insert ; statements instead of the default cursor type for ; the data source. For definitions of the different cursor ; types refer to the SQLSetStmtOption(SQL_CURSOR_TYPE) ; function in the ODBC manual. ; Cursor Type for Metadata=[FORWARD|STATIC|KEYSET|DYNAMIC]; ; If given, this cursor type will be used for metadata ; statements instead of the default cursor type for ; the data source. For definitions of the different cursor ; types refer to the SQLSetStmtOption(SQL_CURSOR_TYPE) ; function in the ODBC manual. ; Cursor Type for Procedures=[FORWARD|STATIC|KEYSET|DYNAMIC]; ; If given, this cursor type will be used for procedure ; statements instead of the default cursor type for ; the data source. For definitions of the different cursor ; types refer to the SQLSetStmtOption(SQL_CURSOR_TYPE) ; function in the ODBC manual. ; Cursor Type for Selects=[FORWARD|STATIC|KEYSET|DYNAMIC]; ; If given, this cursor type will be used for select ; statements instead of the default cursor type for ; the data source. For definitions of the different cursor ; types refer to the SQLSetStmtOption(SQL_CURSOR_TYPE) ; function in the ODBC manual. ; Cursor Type for Updates=[FORWARD|STATIC|KEYSET|DYNAMIC]; ; If given, this cursor type will be used for update ; statements instead of the default cursor type for ; the data source. For definitions of the different cursor ; types refer to the SQLSetStmtOption(SQL_CURSOR_TYPE) ; function in the ODBC manual. ; Date Format=; ; If given, the default date format, YYYY MM DD, will be ; replaced with . The ODBC driver or underlying ; database must understand the date format. ; Date literal=; ; If given, the default ODBC date conversion, "{d '%s-%s-%s'}", ; will be replaced with a literal date string. For some drivers, ; ODBC date literals are converted into function calls and may ; cause the database optimizer to use table scan instead of index scan, ; impacting performance. So alternate literal date string can be ; used if the default ODBC date conversion is not desired. ; Disable Transaction Support=[T|F]; ; If set to T, transaction support is disabled and the drivers ; auotcommit option will be in effect. This option sets the ; transaction isolation level to SQL_TXN_SERIALIZABLE, meaning ; dirty reads, nonrepeatable reads and phantom reads will not ; be possible. ; Optimize For=; ; If a numeric value greater then zero is given, "OPTIMIZE FOR n ROWS" clause will ; be appended to the select statements ( n being equal to the numeric value and the ; number of rows to optimize for ). This option can improve performance based on the ; assumption that rows will be retrieved and causes a suitable communication ; buffer size to be chosen for blocked cursors. ; Procedure Cursors=T|F ; When set to T, sqlfeatures will report that procedure cursors are supported. ; For databases that have result set pending after SQLExecute of a {call ..} ; statement, this entry should be set to T. ; Qualified Synonyms are not supported=[T|F] ; If set to T, the database doesn't supported qualified synonyms. ; Replace Count Non-Distinct=[T|F]; ; If set to T, the count(value) expression will be replaced by count(*). ; Note, that this is NOT semantically equivalent: count(*) may count NULL ; values whereas count(value) does not. ; Select For Fetch Only=[T|F]; ; If set to T, "FOR FETCH ONLY" will be appended to select statements. ; This option can work around quirks on the server by turning on ; journalling or improve performance by affecting the locking strategy. ; Select For Update Disabled=[T|F]; ; If set to T, "FOR UPDATE" will not be allowed in SELECT statements. ; System View Supported=[T|F]; ; If set to F, 'SYSTEM VIEW' is not passed to SQL table. A few driver ; treat the unsupported table type as an error ; System Synonym Supported=[T|F]; ; If set to F, 'SYSTEM SYNONYM' is not passed to SQL table. A few driver ; treat the unsupported table type as an error ; System Alias Supported=[T|F]; ; If set to F, 'SYSTEM ALIAS' is not passed to SQL table. A few driver ; treat the unsupported table type as an error ; Time format=