analytics/bin/cogdmod.ini

;***********************************************************************
;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=<my trace file name>

;
; 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:<DRIVER_NAME>[ VERSION:<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:<DATABASE_NAME>[ VERSION:<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=<literal>;
; 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=<number>;
; 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=<date format>;
; If given, the default date format, YYYY MM DD, will be
; replaced with <date format>. The ODBC driver or underlying
; database must understand the date format.


; Date literal=<double quoted single quoted string>;
; 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=<numeric value>;
; 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 <n> 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=<time format>;
; If given, the default time format, HH MM SS, will be
; replaced with <time format>. The ODBC driver or underlying
; database must understand the time format.


; Time literal=<double quoted string>;
; If given, the default ODBC time conversion, "{t '%s:%s:%s'}",
; will be replaced with a literal time string. For some drivers,
; ODBC time 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 time string can
; be used if the default ODBC time conversion is not desired.


; Timestamp format=<timestamp format>;
; If given, the default timestamp format, YYYY MM DD HH MM SS FFF,
; will be replaced with <timestamp format>. The ODBC driver or
; underlying database must understand the timestamp format.


; Timestamp literal=<double quoted string>;
; If given, the default ODBC timestamp conversion, "{ts '%s-%s-%s %s:%s:%s'}",
; will be replaced with a literal timestamp string. For some drivers
; ODBC timestamp 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 timestamp string can
; be used if the default ODBC timestamp conversion is not desired.


; Treat Integers as Signed=[T|F];
; If set to T all integers will be treated as signed integers.
; If set to F all integers will be treated as unsigned integers.
; If not set the sign of each integer will be described by the driver.


; The return value for any of the options for ODBC's SQLGetInfo call can be 
; overwritten by specifying an alternate value. Please ensure that the
; values specified for the options are acceptable, otherwise, unexpected
; behaviour of the ODBC gateway might result. To add an .ini entry,
; specify the SQLGetInfo option which you wish to modify, and equate it to
; the desired (and appropriate) value.
; Currently the ODBC define names can not be used, you must use the
; define values, this will eventually change.
; (ie: If the driver incorrectly tells us that all columns are nullable,
; we must use the entry SQL_NON_NULLABLE_COLUMNS=1 to force columns to
; be non-nullable not SQL_NON_NULLABLE_COLUMNS=SQL_NNC_NON_NULL )


; The return value for any of the options for SQLGetFunctions call can be 
; overwritten by specifying an alternate value. Please ensure that the
; values specified for the options are acceptable, otherwise, unexpected
; behaviour of the ODBC gateway might result. To add an .ini entry,
; specify the SQLGetFunctions option which you wish to modify, and equate
; it to the desired (and appropriate) value. The only values that are
; acceptable for SQLGetFunctions are TRUE and FALSE.
; (ie: To use the alternate metadata retrieval method we would set
; SQL_API_SQLCOLUMNS=FALSE thus saying the driver does not support
; the SQLColumns function. The gateway would then use "Select * from" )


; The entries below are listed alphabetical for easy lookup.
; All entries are double quoted strings.

[DATABASE:COMPOSITE]
; to retrieve blobs with views we must use a forward only cursor
;Cursor Type for Selects="FORWARD"
; composite does note support the ODBC syntax for when calling ODBC functions
Function Esc Prefix=" "
Function Esc Suffix=" "

[DATABASE:ADAPTIVE SERVER ANYWHERE]
DBINFO_TYPE="OD_IQ"

[DATABASE:ADAPTIVE SERVER IQ]
DBINFO_TYPE="OD_IQ"

[DATABASE:SYBASE IQ]
DBINFO_TYPE="OD_IQ"

[DATABASE:INFORMIX]
; When connecting to Informix read the DbInfo entries from
; the native Informix ini file
DBINFO_TYPE="IF"

[DATABASE:INGRES]
DBINFO_TYPE="OD_IG"
DBINFO_SUBSECTIONS="DBNAM"


[DATABASE:INTERBASE]
; When connecting to Interbase read the DbInfo entries from
; the od_ib ini file with no subtype
DBINFO_TYPE="OD_IB"


[DATABASE:INTERBASE VERSION:05.05]
; When connecting to Interbase Version 5.5 read the subtype of <Version:5.5>
DBINFO_SUBTYPE="Version:5.5"


[DATABASE:INTERBASE VERSION:05.06]
; When connecting to Interbase Version 5.6 read the subtype of <Version:5.6>
DBINFO_SUBTYPE="Version:5.6"

[DATABASE:MICROSOFT SQL SERVER]
; When connecting to Microsoft SQL Server read the DbInfo entries from
; the native Microsoft SQL Server ini file with no subtype
DBINFO_TYPE="MS"
DBINFO_SUBSECTIONS="DBNAM"
Exec_JoinOrder_NoJoinOrder="SET FORCEPLAN OFF"
Exec_JoinOrder_OrderedJoin="SET FORCEPLAN ON"
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"

; Call ICommandWithParameter::SetParameterInfo()
; if subquery contains parameter
SetSubqueryParamInfo="T"

;DataDirect ODBC driver on Unix does not work with subquery with parameter 
Disable_Subquery_With_Parameters="T"


[DATABASE:MICROSOFT SQL SERVER VERSION:06.00]
; When connecting to Microsoft SQL Server Version 6.0 read the subtype of <Version:6.0>
DBINFO_SUBTYPE="Version:6.0"
Unicode Literals="F"


[DATABASE:MICROSOFT SQL SERVER VERSION:06.50]
; When connecting to Microsoft SQL Server Version 6.50 read the subtype of <Version:6.5>
DBINFO_SUBTYPE="Version:6.5"
Unicode Literals="F"


[DATABASE:MICROSOFT SQL SERVER VERSION:07.00]
; When connecting to Microsoft SQL Server Version 7.0 read the subtype of <Version:7.0>
DBINFO_SUBTYPE="Version:7.0"

[DATABASE:MICROSOFT SQL SERVER VERSION:08.00]
; When connecting to Microsoft SQL Server Version 8.0 read the subtype of <Version:8.0>
DBINFO_SUBTYPE="Version:8.0"
SQL_API_SQLPROCEDURES="TRUE:SELECT CATALOG, SCHEMAA, NAME, 0, 0, 0, '', TYPE FROM (SELECT SPECIFIC_CATALOG AS CATALOG, SPECIFIC_SCHEMA AS SCHEMAA, SPECIFIC_NAME AS NAME, ( CASE ROUTINE_TYPE WHEN 'PROCEDURE' THEN 1 WHEN 'FUNCTION' THEN 2 ELSE 0 END ) AS TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE IN ('FUNCTION', 'PROCEDURE') AND ( DATA_TYPE != 'TABLE' OR DATA_TYPE IS NULL ) UNION SELECT SPECIFIC_CATALOG AS CATALOG, SPECIFIC_SCHEMA AS SCHEMAA, SPECIFIC_NAME AS NAME, 3 AS TYPE FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE IN ('FUNCTION') AND DATA_TYPE = 'TABLE' ) AS T WHERE CATALOG ?1 AND SCHEMAA ?2 AND NAME ?3"

[DATABASE:NETEZZASQL]
User Tables="'TABLE','EXTERNAL TABLE'"
Functions Are Procedures="T"
; This entry is used to specify whether the prepared statement will be closed 
; when reaching the end of data, the connection occupied can be used by other 
; statement. 
CLOSE_HSTMT_AT_EOD="T"
Bulk Insert Supported="T"

; When set to T, the sub connections held by the request will be free when release request.
RELEASE_SUBCONNECTION="T"

[DATABASE:ORACLE]
; When connecting to Oracle read the DbInfo entries from
; the native Oracle ini file with no subtype
DBINFO_TYPE="OR"
DBINFO_SUBSECTIONS="DBNAM"
Exec_OptimizerGoal_FirstRow="ALTER SESSION SET OPTIMIZER_GOAL = FIRST_ROWS"
Exec_OptimizerGoal_AllRows="ALTER SESSION SET OPTIMIZER_GOAL = ALL_ROWS"
Set User As Default Schema="T"


[DATABASE:ORACLE VERSION:07.03]
; When connecting to Oracle Version 7.3 read the subtype of <ORACLE7.3>
DBINFO_SUBTYPE="ORACLE7.3"


[DATABASE:ORACLE VERSION:08.00]
; When connecting to Oracle Version 8 read the subtype of <ORACLE8.0>
DBINFO_SUBTYPE="ORACLE8.0"


[DATABASE:ORACLE VERSION:08.01]
; When connecting to Oracle Version 8.1 read the subtype of <ORACLE8.1>
DBINFO_SUBTYPE="ORACLE8.1"

[DATABASE:NETEZZASQL]
SQL_API_SQLDESCRIBEPARAM="FALSE"

[DATABASE:RED BRICK WAREHOUSE]
; When connecting to Redbrick read the DbInfo entries from
; the od_redbrick ini file with no subtype
DBINFO_TYPE="OD_RB"
;Override some cast functions
DBINFO_SUBSECTIONS="DBNAM"
State Overwrite 0="CCLMSG_UDA_SQL_GENERAL SQL_API_SQLCANCEL WS000 01S05"
Exec_DegreeOfParallelism="SET QUERYPROCS %d"
Exec_RowLimit_Set="SET ROWCOUNT %d"
Exec_RowLimit_Reset="SET ROWCOUNT 0"
System View Supported="F"
System Alias Supported="F"
System Synonym Supported="F"


[DATABASE:RED BRICK WAREHOUSE VERSION:06.00]
; When connecting to Redbrick Version 6.0 read the subtype of <Version:6.0>
DBINFO_SUBTYPE="Version:6.0"

[DATABASE:RED BRICK WAREHOUSE VERSION:06.10]
; When connecting to Redbrick Version 6.10 read the subtype of <Version:6.10>
DBINFO_SUBTYPE="Version:6.1"

[DATABASE:RED BRICK WAREHOUSE VERSION:06.11]
; When connecting to Redbrick Version 6.11 read the subtype of <Version:6.11>
DBINFO_SUBTYPE="Version:6.11"

[DATABASE:RED BRICK WAREHOUSE VERSION:06.20]
; When connecting to Redbrick Version 6.20 read the subtype of <Version:6.20>
DBINFO_SUBTYPE="Version:6.20"

[DATABASE:RED BRICK WAREHOUSE VERSION:06.30]
; When connecting to Redbrick Version 6.30 read the subtype of <Version:6.30>
DBINFO_SUBTYPE="Version:6.30"

[DATABASE:IBM COGNOS REAL-TIME MONITORING]
Keyword Alias=" as %s "
SQL_API_SQLDESCRIBEPARAM="FALSE" 
Parameter_In_Select_List="F" 
Subquery_With_Parameters="F" 
Like_With_Parameters="F" 
Disable_Subquery_With_Parameters="F" 

[DATABASE:SQLBase]
DBINFO_TYPE="SB"
Keyword Alias=" as %s "

;Entry to read cogdmct.ini for Sybase ASE using Sybase ASE ODBC Driver
[DRIVER:SYODASE.DLL DATABASE:SQL SERVER]
DBINFO_TYPE="CT"

[DATABASE:SQL SERVER VERSION:12.50]
DBINFO_SUBTYPE="Version:12.50"

;Entry to read cogdmct.ini for Sybase ASE using Sybase ASE ODBC Driver version 15
[DRIVER:Adaptive Server Enterprise Version:15]
DBINFO_TYPE="CT"

[DATABASE:SYBASE]
; When connecting to Sybase read the DbInfo entries from
; the native CTLIB ini file with no subtype
DBINFO_TYPE="CT"
Exec_JoinOrder_NoJoinOrder="SET FORCEPLAN OFF"
Exec_JoinOrder_OrderedJoin="SET FORCEPLAN ON"
Exec_DegreeOfParallelism="SET PARALLEL_DEGREE %d"


[DATABASE:SYBASE VERSION:11.00]
; When connecting to Sybase Version 11.0 read the subtype of <Version:11.0>
DBINFO_SUBTYPE="Version:11.0"

[DATABASE:SYBASE VERSION:11.05.0000]
; When connecting to Sybase Version 11.5.0 read the subtype of <Version:11.5.0>
DBINFO_SUBTYPE="Version:11.5.0"

[DATABASE:SYBASE VERSION:11.05.0001]
; When connecting to Sybase Version 11.5.1 read the subtype of <Version:11.5.1>
DBINFO_SUBTYPE="Version:11.5.1"

[DATABASE:SYBASE VERSION:11.09.0001]
; When connecting to Sybase Version 11.9.1 read the subtype of <Version:11.9.1>
DBINFO_SUBTYPE="Version:11.9.1"

[DATABASE:SYBASE VERSION:11.09.0002]
; When connecting to Sybase Version 11.9.2 read the subtype of <Version:11.9.2>
DBINFO_SUBTYPE="Version:11.9.2"

[DATABASE:SYBASE VERSION:11.09.0003]
; When connecting to Sybase Version 11.9.3 read the subtype of <Version:11.9.3>
DBINFO_SUBTYPE="Version:11.9.3"


[DATABASE:SYBASE SQL ANYWHERE]
; The outer joins settings are intentionally set to blanks as joins
; information is to be obtained from the [Exception Joins ...]
; section.
SQL_OUTER_JOINS=""
SQL_OJ_CAPABILITIES=""
SQL_CONVERT_FUNCTIONS="3"

[DATABASE:TERADATA]
; When connecting to NCR Teradata, read the DbInfo entries from
; the separate Teradata ini file with no subtype
DBINFO_TYPE="OD_TD"

[DATABASE:TERADATA VERSION:06.00]
; When connecting to Teradata V2R6,  read the subtype of <VERSION:06.00>
DBINFO_SUBTYPE="VERSION:06.00"
   
[DATABASE:TERADATA VERSION:05.01]
; When connecting to Teradata V2R5.1,  read the subtype of <VERSION:05.01>
DBINFO_SUBTYPE="VERSION:05.01"

[DATABASE:TERADATA VERSION:05.00.0102]
; When connecting to Teradata V2R5.01,  read the subtype of <VERSION:05.00.01>
DBINFO_SUBTYPE="VERSION:05.00.01"

[DATABASE:TERADATA VERSION:05.00]
; When connecting to Teradata V2R5,  read the subtype of <VERSION:05.00>
DBINFO_SUBTYPE="VERSION:05.00"

[DATABASE:TERADATA VERSION:04.00]
; When connecting to Teradata V2R4,  read the subtype of <VERSION:04.00>
DBINFO_SUBTYPE="VERSION:04.00"

[DATABASE:TERADATA VERSION:04.01]
; When connecting to Teradata V2R4,  read the subtype of <VERSION:04.01>
DBINFO_SUBTYPE="VERSION:04.01"

[DATABASE:TERADATA VERSION:03.00]
; When connecting to Teradata V2R3,  read the subtype of <VERSION:03.00>
DBINFO_SUBTYPE="VERSION:03.00"

[DATABASE:TERADATA VERSION:02.00]
; When connecting to Teradata V2R2 NT,  read the subtype of <VERSION:02.00>
DBINFO_SUBTYPE="VERSION:02.00"

[DATABASE:TERADATA VERSION:02.01]
; When connecting to Teradata V2R2,  read the subtype of <VERSION:02.01>
DBINFO_SUBTYPE="VERSION:02.01"

[DATABASE:DSN]
; When connect to DB2/MVS, read cogdmod_d2.ini file
DBINFO_TYPE="D2"

[DATABASE:QSQ]
; When connect to DB2 AS/400, read cogdmod_d2.ini file
DBINFO_TYPE="D2"

[DATABASE:SQL]
; When connect to DB2 UDB, read cogdmod_d2.ini file
DBINFO_TYPE="D2"

[DATABASE:VERTICA DATABASE]
; When connect to Vertica, read cogdmod_ve.ini file
DBINFO_TYPE="OD_VE"

[DATABASE:INFOSPHERE CLASSIC FEDERATION]
; When connect to Infosphere Classic Federation, read cogdmod_cf.ini file
; DbInfos must be disabled in this file.
DBINFO_TYPE="OD_CF"

[DATABASE:WEBSPHERE CLASSIC FEDERATION]
; When connect to Infosphere Classic Federation, read cogdmod_cf.ini file
DBINFO_TYPE="OD_CF"

[DATABASE:POSTGRESQL]
; When connect to Postgres, read cogdmod_postg.ini file
DBINFO_TYPE="OD_POSTG"

[DATABASE:PARACCEL]
; When connect to Paraccel, read cogdmod_pa.ini file
DBINFO_TYPE="OD_PA"

[DATABASE:GREENPLUM]
; When connect to Greenplum, read cogdmod_gp.ini file
DBINFO_TYPE="OD_GP"

[DATABASE:NCLUSTER] 
; When connected to Aster Data, read cogdmod_ast.ini file 
DBINFO_TYPE="OD_AST" 

[DATABASE:INGRES_VECTORWISE]
; When connected to Ingres Vectorwise, read cogdmod_ivw.ini file
DBINFO_TYPE="OD_IVW"

[DRIVER:ADBC32.DLL]
;trakker 300602 SQL_DRIVER_VER returns "1278" causing a gpf since driver version is non standard
SQL_DRIVER_VER="12.78"
;SQL_MAX_TABLE_NAME_LEN returns 0
SQL_MAX_TABLE_NAME_LEN="128"
;Driver does not support SQLExtendedFetch
SQL_API_SQLEXTENDEDFETCH="FALSE"


[DRIVER:ALLBASE.DLL]
SQL_OUTER_JOINS="N"

[DRIVER:ARODBC40.DLL]
Convert To Blob Limit="255"

[DRIVER:C2GUP14.DLL]
;The following two entries were added to fix trakker #303870.
SQL_API_SQLDESCRIBECOL="FALSE"
SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_LENGTH,SQL_COLUMN_UNSIGNED,SQL_COLUMN_UPDATABLE,SQL_COLUMN_NAME,SQL_COLUMN_PRECISION,SQL_COLUMN_SCALE,SQL_COLUMN_TYPE"

[DRIVER:CACHEODBC.DLL]
SQL_API_SQLEXTENDEDFETCH="FALSE"
;Cache ODBC driver does not fully support catalogs.  See trakker 409647.
SQL_QUALIFIER_TERM=""
;The driver is not capable when we set attribute 'row_bind_type' 
;after a call to SQLFetchScroll. See Trakker 489615 for more description.
SQL_API_SQLFETCHSCROLL="FALSE"

[DRIVER:EDAODBC.DLL]
; Enable the use single phase execution of SQL statements using
; SQLExecuteDirect instead of SQLPrepare and SQLExecute. Note
; this means the driver will not support parameters in SQL statements.
SQL_API_SQLPREPARE="FALSE"



[DRIVER:EHNODBC3.DLL]
Select For Fetch Only="T"


[DRIVER:FASTPATH.DLL]
SQL_NON_NULLABLE_COLUMNS="0"

[DRIVER:HSOPT32.DLL]
; Extended fetch is slower that normal fetch - HIT ODBC driver for DB2
SQL_API_SQLEXTENDEDFETCH="FALSE"


[DRIVER:IBINT13.DLL]
; This driver only supports Interbase
SQL_DBMS_NAME="INTERBASE"
; The version string looks like <WI-Va.b.c.ddd>, we are only intrested in <a.b>.
SQL_DBMS_VER="Format String:WI-V%3s"
SQL_CONVERT_FUNCTIONS="0"


[DRIVER:IVDBF12.DLL]
; This driver only supports dBASE, Clipper and FoxPro
SQL_DBMS_NAME="DBASE"
;Desktop databases catalogs are file specifications and therefore are disabled
SQL_QUALIFIER_TERM=""


[DRIVER:IVDBF14.DLL]
; This driver only supports dBASE, Clipper and FoxPro
SQL_DBMS_NAME="DBASE"
;Desktop databases catalogs are file specifications and therefore are disabled
SQL_QUALIFIER_TERM=""


[DRIVER:IVGUP14.DLL]
;The following two entries were added to fix trakker #303870.
SQL_API_SQLDESCRIBECOL="FALSE"
SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_LENGTH,SQL_COLUMN_UNSIGNED,SQL_COLUMN_UPDATABLE,SQL_COLUMN_NAME,SQL_COLUMN_PRECISION,SQL_COLUMN_SCALE,SQL_COLUMN_TYPE"


[DRIVER:IVINF709.DLL]
; This driver only supports Informix
SQL_DBMS_NAME="INFORMIX"


[DRIVER:IVINF914.DLL]
; This driver only supports Informix
SQL_DBMS_NAME="INFORMIX"
; The MERANT driver returns "N" for column aliases, the correct result is "Y"
SQL_COLUMN_ALIAS="Y"

[DRIVER:IVMSSS18.SO]
Threaded Open="T"

[DRIVER:IVMSSS18.SL]
Threaded Open="T"

[DRIVER:IVMSSS19.SO]
Threaded Open="T"

[DRIVER:IVMSSS19.SL]
Threaded Open="T"

[DRIVER:IVMSSS20.SO]
Threaded Open="T"

[DRIVER:IVMSSS20.SL]
Threaded Open="T"

[DRIVER:IVOR708.DLL]
; This driver only supports Oracle 7.3
SQL_DBMS_NAME="ORACLE"
SQL_DBMS_VER="07.03"


[DRIVER:IVOR712.DLL]
; This driver only supports Oracle 7.3
SQL_DBMS_NAME="ORACLE"
SQL_DBMS_VER="07.03"


[DRIVER:IVOR713.DLL]
; This driver only supports Oracle 7.3
SQL_DBMS_NAME="ORACLE"
SQL_DBMS_VER="07.03"


[DRIVER:IVOR813.DLL]
; This driver only supports Oracle 8.0
SQL_DBMS_NAME="ORACLE"
SQL_DBMS_VER="08.00"


[DRIVER:IVOR814.DLL]
; This driver only supports Oracle 8.0
SQL_DBMS_NAME="ORACLE"
SQL_DBMS_VER="08.00"
SQL_MAX_TABLE_NAME_LEN="128"


[DRIVER:IVOR815.DLL]
; This driver supports Oracle 8.1
SQL_DBMS_NAME="ORACLE"
SQL_DBMS_VER="08.01"


[DRIVER:IVSS612.DLL]
; This driver only supports Microsoft SQL Server
SQL_DBMS_NAME="MICROSOFT SQL SERVER"
SQL_DBMS_VER="Format String:Microsoft SQL Server  %4s"


[DRIVER:IVSYB12.DLL]
; This driver only supports Sybase
SQL_DBMS_NAME="SYBASE"


[DRIVER:MSORCL32.DLL]
; This driver only supports Oracle
; SQL_DRIVER_VER returns a non standard driver version
SQL_DRIVER_VER="Format String:%5s"


[DRIVER:NODBC.DLL] 
; This driver only supports Navision 
SQL_DBMS_NAME="Microsoft Business Solutions-Navision" 
SQL_DBMS_VER="05.00"


[DRIVER:NSQLV32.DLL]
;Lotus Notes
;Trakker 387101; rowset size larger than 16 causes Access Violation with some text fields.
SQL_API_SQLEXTENDEDFETCH="FALSE"
SQL_API_SQLFETCHSCROLL="FALSE"
;Trakker 517032
Unsigned Positive Numbers="T"

[DRIVER:ODBCJT32.DLL]
Keyword Ascending=""
Convert To Blob Limit="255"
Disable Transaction Support="T"
Select For Update Disabled="T"
;-- SELECT <name> as <name> fails, so aliases shouldn't be used.
;Trakker#463497 - According to "Access 2000 Developer's Handbook" 
; URL: http://www.developershandbook.com/Downloads/2370ch05.pdf
; the bracket [] is used for delimiting keywords
Keyword Alias=" as [%s] "
SQL_COLUMN_ALIAS="Y"
;Desktop databases catalogs are file specifications and therefore are disabled
SQL_QUALIFIER_TERM=""
;When a column name is misspelled in a query, no error is returned by the driver at prepare
;time, but an incorrect description for this column is returned.  An error is only returned
;at execute time, which is described in the driver documentation as an invalid column name.
;Therefore, the queries have to be executed at prepare time for this driver.
;SQL_API_SQLPREPARE="FALSE"

[DRIVER:ACEODBC.DLL]
Disable Transaction Support="T"
Keyword Alias=" as [%s] "

[DRIVER:PSQODB32.DLL]
; The Peoplesoft drive does not support SQLExtendedFetch even though it says it does.
SQL_API_SQLEXTENDEDFETCH="FALSE"
; The Peoplesoft driver returns """ for its quote char, the correct result is "".
SQL_IDENTIFIER_QUOTE_CHAR=""
; The Peoplesoft limit for column name lengths is 128 characters.
SQL_MAX_TABLE_NAME_LEN="128"
; The Peoplesoft driver does not support SQLNativeSql.
SQL_API_SQLNATIVESQL="FALSE"

[DRIVER:QEDB207.DLL]
Select For Fetch Only="T"


[DRIVER:RB32ODBC.DLL]
; This driver only supports Red Brick Warehouse
SQL_DBMS_NAME="RED BRICK WAREHOUSE"
;Some of the Redbrick drivers do not report this
SQL_IDENTIFIER_QUOTE_CHAR="""
;The database doesn't properly support ltrim/rtrim
;functions because of lacking varchar support
SQL_STRING_FUNCTIONS="6213"
SQL_MAX_SCHEMA_NAME_LEN="30"

[DRIVER:RB32ODBC.DLL VERSION:05.02]
SQL_API_SQLNATIVESQL="FALSE"

[DRIVER:RBODBC32.DLL]
; This driver only supports Red Brick Warehouse
SQL_DBMS_NAME="RED BRICK WAREHOUSE"
;Some of the Redbrick drivers do not report this
SQL_IDENTIFIER_QUOTE_CHAR="""
;The database doesn't properly support ltrim/rtrim
;functions because of lacking varchar support
SQL_STRING_FUNCTIONS="6213"

[DRIVER:LIBRBODBC.SO]
SQL_MAX_SCHEMA_NAME_LEN="30"

[DRIVER:LIBRBODBC.SL]
SQL_MAX_SCHEMA_NAME_LEN="30"

[DRIVER:LIBRBODBC.A]
SQL_MAX_SCHEMA_NAME_LEN="30"


[DRIVER:SCLIW16.DLL]
SQL_NON_NULLABLE_COLUMNS="0"


[DRIVER:SIMBASYBASE.DLL]
; This driver only supports Sybase
SQL_DBMS_NAME="SYBASE"


[DRIVER:SQLSRV.DLL]
; This driver only supports Microsoft SQL Server
SQL_DBMS_NAME="MICROSOFT SQL SERVER"
Cursor Type For Metadata="STATIC"
Connection Access Mode Is Changeable="F"


[DRIVER:SQLSRV32.DLL]
; This driver only supports Microsoft SQL Server
SQL_DBMS_NAME="MICROSOFT SQL SERVER"
Cursor Type For Metadata="STATIC"
Connection Access Mode Is Changeable="F"
; The functions CURDATE and CURTIME have been removed as they both return
; VarChar instead of a Date and Time (respectively).
SQL_TIMEDATE_FUNCTIONS="2096637"
; Trakkers 258739, 260583, 262219 
SQL_API_SQLEXTENDEDFETCH="FALSE"
SupportUnicode="T"

[DRIVER:SQLNCLI.DLL]
; This driver only supports Microsoft SQL Server
SQL_DBMS_NAME="MICROSOFT SQL SERVER"
Cursor Type For Metadata="STATIC"
Connection Access Mode Is Changeable="F"
; The functions CURDATE and CURTIME have been removed as they both return
; VarChar instead of a Date and Time (respectively).
SQL_TIMEDATE_FUNCTIONS="2096637"
; Trakkers 258739, 260583, 262219 
SQL_API_SQLEXTENDEDFETCH="FALSE"
Threaded Open="T"
SupportUnicode="T"

[DRIVER:SQO32_73.DLL]
; This driver only supports Oracle
SQL_DBMS_NAME="ORACLE"
State Overwrite 0="CCLMSG_UDA_SQL_ATTACH SQL_API_SQLDRIVERCONNECT 08003 01000"
SQL_API_SQLEXTENDEDFETCH="FALSE"

[DRIVER:SQORA32.DLL]
; This driver only supports Oracle
SQL_DBMS_NAME="ORACLE"


[DRIVER:SQRDB32.DLL]
Select For Update Disabled="T"
Keyword Alias=" as %s "

[DRIVER:SWODBC32.DLL]
SQL_OJ_CAPABILITIES="127"

[DRIVER:SYIQ95.DLL]
; This driver only supports Sybase IQ
SQL_DBMS_NAME="SYBASE IQ"
; The version string looks like <SQL Server/11.5/P/NT/OS 4.00/1/fbu/Wed Sep 10 03:56:32 PDT 1997>, we are only intrested in <11.5>.
SQL_DBMS_VER="Format String:SQL Server/%4s"
SQL_OJ_CAPABILITIES="75"


[DRIVER:SYIQNT.DLL]
; This driver only supports Sybase IQ
SQL_DBMS_NAME="SYBASE IQ"
SQL_DBMS_VER="Format String:SQL Server/%4s"
SQL_OJ_CAPABILITIES="75"


[DRIVER:SYIQW3.DLL]
; This driver only supports Sybase IQ
SQL_DBMS_NAME="SYBASE IQ"
SQL_OJ_CAPABILITIES="75"

[DRIVER:SYSYBNT.DLL]
SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_UPDATABLE"

[DRIVER:TDATA.SL]
;Teradata ODBC driver on hpux11
DBINFO_SUBSECTIONS="DBNAM,DBMIN"
ODBC3 DATE="T"

[DRIVER:TDATA.SO]
;Teradata ODBC driver on sunsol and aix
DBINFO_SUBSECTIONS="DBNAM,DBMIN"
ODBC3 DATE="T"

[DRIVER:TDATA32.DLL]
DBINFO_SUBSECTIONS="DBNAM,DBMIN"
ODBC3 DATE="T"

[DRIVER:UDTODBC.DLL]
Disable Transaction Support="T"

[DRIVER:VFPODBC.DLL]
;Visual FoxPro catalogs are file specifications and therefore are disabled
SQL_QUALIFIER_TERM=""

[DRIVER:VWODBC32.DLL]
; SCO driver for Informix 7 reports incorrect length of decimals, and unsigned.
SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_UPDATABLE"

[DRIVER:W32BTINT.DLL]
; BTrieve only supports column wize binding for extended fetch
SQL_API_SQLEXTENDEDFETCH="FALSE"



; ODBC connection to Oracle's Rdb 7 on OpenVMS tested ok.
; The driver does not seem to support neither Catalogs nor Schemas despite
; information returned by SQLGetInfo.
; The section for the ODBC Rdb driver is created here and is used to modify
; metadata information first (Trakker 423506).
; DRIVER:SQRDB3.DLL VERSION:03.00.0002 DATABASE:RDB VERSION:07.00.2000
[DRIVER:SQRDB3.DLL]
SQL_OWNER_TERM=""
SQL_QUALIFIER_TERM=""


;When access DB2 via odbc driver, SQL_DBMS_NAME should be given in cogdmod.ini.
;If we recgnize the entry as one of DB2 supported database, we will switch to 
;cogdmd2.ini

;DB2/400 via client access odbc driver
[DRIVER:CWBODBC.DLL DATABASE:DB2/400 SQL]
SQL_DBMS_NAME="QSQ"

[DRIVER:LIBCWBODBC.SO DATABASE:DB2/400 SQL]
SQL_DBMS_NAME="QSQ"

;DB2 UDB via db2cli odbc driver
[DRIVER:DB2CLI.DLL DATABASE:DB2/NT]
SQL_DBMS_NAME="SQL"

;DB2/400 via db2cli odbc driver
[DRIVER:DB2CLI.DLL DATABASE:AS]
SQL_DBMS_NAME="QSQ"

;DB2/MVS via db2cli odbc dirver
[DRIVER:DB2CLI.DLL DATABASE:DB2]
SQL_DBMS_NAME="DSN"

;DB2/400 via Sybase DirectConnect odbc driver
[DRIVER:DCSYB30.DLL DATABASE:DB2/400]
SQL_DBMS_NAME="QSQ"

;DB2/MVS via Sybase DirectConnect odbc driver
[DRIVER:DCSYB30.DLL DATABASE:DB2/MVS]
SQL_DBMS_NAME="DSN"

[DRIVER:ACUODBC.DLL]
;Driver only supports column wize binding for extended fetch
SQL_API_SQLEXTENDEDFETCH="FALSE"

[DRIVER:DTLODBC.DLL]
; The Striva driver does not support SQLNativeSql.
SQL_API_SQLNATIVESQL="FALSE"
;Driver does not support  SQL_COLUMN_UNSIGNED and SQL_COLUMN_UPDATABLE attributes
SQL_API_SQLCOLATTRIBUTES="TRUE:SQL_COLUMN_COUNT,SQL_COLUMN_LENGTH,SQL_COLUMN_NULLABLE,SQL_COLUMN_NAME,SQL_COLUMN_PRECISION,SQL_COLUMN_SCALE,SQL_COLUMN_TYPE"
; SQL_DRIVER_VER returns a non standard driver version
SQL_DRIVER_VER="Format String:%10s"

[DRIVER:P4ODBC.DLL]
; P4 is read-only, transactions are not supported
Disable Transaction Support="T"
;Trakker 487501
SQL_OWNER_TERM=""

[DRIVER:BBJODBC.DLL]
; Basis does not support the following ODBC 3.5 attributes / features
SQL_TIMEDATE_ADD_INTERVALS="F"
SQL_TIMEDATE_DIFF_INTERVALS="F"

;SSA FM odbc driver
[DRIVER:FMODBC.DLL]
SQL_OWNER_TERM=""

; Liant/Relativity ODBC Driver
[DRIVER:RELDBM32.DLL]
;Trakker 521340
SQL_API_SQLFOREIGNKEYS="FALSE"

[DRIVER:libtdsodbc.so]
; FreeTDS driver for SQLSERVER
SQL_DBMS_NAME="MICROSOFT SQL SERVER"
DBINFO_TYPE="MS"
SQL_CONVERT_BIGINT="F"
SQL_CONVERT_DATE="F"
SQL_CONVERT_DOUBLE="F"
SQL_CONVERT_TIME="F"
Cursor Type For Metadata="STATIC"
Connection Access Mode Is Changeable="F"

[I18N Encoding Mapping DATABASE:IBM COGNOS REAL-TIME MONITORING]
UTF8=utf-8

;-----------------
;WARNING
;-----------------
; Sections below this line is to support the ODBC 2.5 gateway under sgi/odbc.
; After Bering I ODBC 2.5 gateways will be discontinued, thus the following
; sections should be removed at that point. I18N mappings for the ODBC 3.5 
; gateways are defined in the ini file of the specific gateway.

; This section is used by Teradata driver 
; to map Teradata encoding names to icu names
; NOTE: Teradta (upto V2R5) does not support
; native Thai language codepage. The only way
; to support Thai language is through utf-8
[I18N Encoding Mapping DATABASE:TERADATA]
UTF8=utf-8
KANJISJIS_0S=Shift_JIS
KANJIEUC_0U=EUC_JP

[I18N Encoding Mapping DATABASE:RED BRICK]
JapanEUC=EUC-JP
MS1250=cp1250
MS1251=cp1251
MS1252=cp1252
MS1253=cp1253
MS1254=cp1254
MS1255=cp1255
MS1256=cp1256
MS1257=cp1257
MS1258=cp1258
MS932=sjis
MS874=cp874

; The following were tested with 10.1B and not 10.1A. Hence, for 10.1A the entries are disabled
; to preserve existing behaviour and should not be changed by non-developers.

[Builtin Functions DATABASE:OPENEDGE]
d:_add_years(%1d,%2n)=ADD_MONTHS( %1, (%2 * 12) );
s:_add_years(%1s,%2n)=CAST(CONCAT(CAST(ADD_MONTHS( CAST(%1 AS DATE), (%2 * 12) ) AS CHAR(11)),TO_CHAR(%1, 'HH:MI:SS:MLS')) AS TIMESTAMP);
d:_add_months(%1d,%2n)=ADD_MONTHS( %1, %2 );
s:_add_months(%1s,%2n)=CAST(CONCAT(CAST(ADD_MONTHS( CAST(%1 AS DATE), %2 ) AS CHAR(11)),TO_CHAR(%1, 'HH:MI:SS:MLS')) AS TIMESTAMP);
d:_add_days(%1d,%2n)=( %1 + %2);
n:_days_between(%1ds,%2ds)= ( %1 - %2 );
; progress interprets the integer as milliseconds for time and timestamps hence the multiplier
s:_add_days(%1s,%2n)=( %1 + (%2 * 86400000));
t:_add_hours(%1t,%2n)=( %1 + (%2 * 3600000 ));
s:_add_hours(%1s,%2n)=( %1 + (%2 * 3600000 ));
t:_add_minutes(%1t,%2n)=( %1 + (%2 * 60000 ));
s:_add_minutes(%1s,%2n)=( %1 + (%2 * 60000 ));
t:_add_seconds(%1t,%2n)=( %1 + (%2 * 1000 ));
s:_add_seconds(%1s,%2n)=( %1 + (%2 * 1000 ));
n:_day_of_year(%1ds)=DAYOFYEAR(%1);
n:_day_of_week(%1ds, %2n)= (MOD(DAYOFWEEK(%1)+7-%2,7)+1);
; progress does not return an iso week of year
; n:_week_of_year(%1d)=WEEK(%1);
d:_last_of_month(%1d)=LAST_DAY(%1);
s:_last_of_month(%1s)=CAST(CONCAT(CAST(LAST_DAY(CAST(%1 AS DATE)) AS CHAR(11)),TO_CHAR(%1, 'HH:MI:SS:MLS')) AS TIMESTAMP);
n:_days_to_end_of_month(%1d)=(LAST_DAY (%1) - %1);
n:_days_to_end_of_month(%1s)=(LAST_DAY (CAST(%1 AS DATE)) - CAST(%1 AS DATE));
d:_first_of_month(%1d)=(%1 - (DAYOFMONTH (%1) -1));
s:_first_of_month(%1s)=CAST(CONCAT(CAST(CAST(%1 AS DATE) - (DAYOFMONTH (%1) - 1) AS CHAR(11)),TO_CHAR(%1, 'HH:MI:SS:MLS')) AS TIMESTAMP);
n:_round(%1n, %2n)=ROUND(%1,%2);

n:coguda#extract_year(%1ds)=YEAR(%1);
n:coguda#extract_month(%1ds)=MONTH(%1);
n:coguda#extract_day(%1ds)=DAYOFMONTH(%1);
n:coguda#extract_hour(%1st)=HOUR(%1);
n:coguda#extract_minute(%1st)=MINUTE(%1);
n:coguda#extract_second(%1st)=SECOND(%1);

t:localtime()=systime();
s:localtimestamp()=systimestamp();

; odbc driver false advertises supporting  sql92 substring. trakker 585076
c:substring(%1c, %2n {,%3n})=SUBSTR(%1, %2 {,%3});

[Builtin Functions DATABASE:OPENEDGE VERSION:10.27]
d:_add_years(%1d,%2n)=;
s:_add_years(%1s,%2n)=;
d:_add_months(%1d,%2n)=;
s:_add_months(%1s,%2n)=;
d:_add_days(%1d,%2n)=;
n:_days_between(%1ds,%2ds)= ;
; progress interprets the integer as milliseconds for time and timestamps hence the multiplier
s:_add_days(%1s,%2n)=;
t:_add_hours(%1t,%2n)=;
s:_add_hours(%1s,%2n)=;
t:_add_minutes(%1t,%2n)=;
s:_add_minutes(%1s,%2n)=;
t:_add_seconds(%1t,%2n)=;
s:_add_seconds(%1s,%2n)=;
n:_day_of_year(%1ds)=;
n:_day_of_week(%1ds, %2n)=;
; progress does not return an iso week of year
; n:_week_of_year(%1d)=;
d:_last_of_month(%1d)=;
s:_last_of_month(%1s)=;
n:_days_to_end_of_month(%1d)=;
n:_days_to_end_of_month(%1s)=;
d:_first_of_month(%1d)=;
s:_first_of_month(%1s)=;

c:trim_both_spaces(%1c)=;
n:_round(%1n, %2n)=;

t:localtime()=;
s:localtimestamp()=;

; odbc driver false advertises supporting  sql92 substring. trakker 585076
c:substring(%1c, %2n {,%3n})=SUBSTR(%1, %2 {,%3});

[Exceptions Tables DATABASE:OPENEDGE]
Joined=T
Derived=T

[Exceptions Tables DATABASE:OPENEDGE VERSION:10.27]
Derived=F

[Exceptions General DATABASE:IBM COGNOS REAL-TIME MONITORING]
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
Null_Order=F
Parameter_Markers=F 


[Exceptions General DATABASE:OPENEDGE]
Group_By_Expr=T
Count_Literal=T
Count_Blob=T
Count_Value_Expr=T
Parameter_In_Select_List=F
Like_Pattern_Literal_Only=T
Multiple_Distinct=F
Distinct_Aggregate_Value_Expr=F
Integer_Division_Truncation=F
Subquery_In_Case=F

;OpenEdge 10.1B section
[Exceptions General DATABASE:OPENEDGE VERSION:10.28]
Remove_Parameter_Cast=T

;OpenEdge 10.1A section
[Exceptions General DATABASE:OPENEDGE VERSION:10.27]
Group_By_Expr=F
Count_Literal=F
Count_Blob=F
Count_Value_Expr=F
Parameter_In_Select_List=F

[Exceptions Blob Expressions DATABASE:OPENEDGE]
Blob_In_Substring=F
Blob_In_Trim=F
Blob_In_Substring_Return_Blob=F
Blob_In_IsNull=T

[Exceptions Blob Expressions DATABASE:OPENEDGE VERSION:10.27]
Blob_In_IsNull=F

; progress has feature limitations which means we cannot push all cases of intersect and minus
; trakker 587818
[Exceptions Set Operators DATABASE:OPENEDGE]
Distinct="distinct"
Intersect=
Except=

[Exceptions Set Operators DATABASE:OPENEDGE VERSION:10.27]
Distinct=
Intersect=
Except=

[Exceptions Value Expressions DATABASE:OPENEDGE]
case=T
Coalesce=T
Nullif=T
Cast=T
Trim_Both_Spaces=C
Localtime=C
Localtimestamp=C
Substring=C
Extract=C
Extract_Year=coguda#extract_year
Extract_Month=coguda#extract_month
Extract_Day=coguda#extract_day
Extract_Hours=coguda#extract_hour
Extract_Minutes=coguda#extract_minute
Extract_Seconds=coguda#extract_second
Comments=T

;OpenEdge 10.1C00 section
[Exceptions Value Expressions DATABASE:OPENEDGE VERSION:10.29.0000]
;Trakker 586698
case=F

;OpenEdge 10.1B section
[Exceptions Value Expressions DATABASE:OPENEDGE VERSION:10.28]
;Trakker 586698
case=F

;OpenEdge 10.1A section
[Exceptions Value Expressions DATABASE:OPENEDGE VERSION:10.27]
case=F
Coalesce=F
Nullif=F
Cast=F
Trim_Both_Spaces=F
Localtime=F
Localtimestamp=F
Substring=C
Extract=F
Comments=F

[Exceptions Joins DATABASE:OPENEDGE]
;trakker 586135
Cross=T
Cross_Syntax=" CROSS JOIN "
Full_Outer=F
Nested_Inner=F
Nested_Outer=T
Left_Nested=T
Right_Outer=F
Right_Nested=F
On_Condition_Between_Predicate=T
On_Condition_In_Predicate=T
On_Condition_Like_Predicate=T
On_Condition_Or_Predicate=T
On_Condition_Set_Functions=F

[Exceptions Joins DATABASE:OPENEDGE VERSION:10.27]
On_Condition_Between_Predicate=F
On_Condition_In_Predicate=F
On_Condition_Like_Predicate=F
On_Condition_Or_Predicate=F
On_Condition_Set_Functions=F


[Exceptions Delimiters]
Comment_Begin="/* "
Comment_End=" */ "

[Operator Comparison DATABASE:OPENEDGE]
Date=DT,OK:TS,OK
Time=TM,OK:TS,OK
Timestamp=DT,OK:TS,OK
Interval=

[Exceptions Predicates DATABASE:OPENEDGE]
All="all"

[Exceptions Predicates DATABASE:OPENEDGE VERSION:10.27]
All=


[Operator Cast DATABASE:NETEZZASQL]
TM=TS,NA
SM=IV,NA:IY,NA
IT=IV,NA:IY,NA
QD=IV,NA:IY,NA
DM=IV,NA:IY,NA
NU=IV,NA:IY,NA
FL=IV,NA:IY,NA
DB=IV,NA:IY,NA

[Operator Cast DATABASE:OPENEDGE]
AD=LC,NA:NC,NA:BN,NA:NV,NA:VB,NA:BO,NA:IV,NA:TT,NA:TZ,NA:IY,NA:TX,NA:BL,NA
BN=AD,NA
LC=AD,NA
VB=AD,NA
TX=AD,NA
BL=AD,NA
; trakker 587055 
DT=CH,NA:VC,NA:NC,NA:NV,NA

[Operator Cast DATABASE:IBM COGNOS REAL-TIME MONITORING]
;AD=LC,NA:NC,NA:BN,NA:NV,NA:VB,NA:BO,NA:IV,NA:TT,NA:TZ,NA:IY,NA:TX,NA:BL,NA
AD=AD,NA
VC=TS,TS:DB,DB:DM,DM:IT,IT
DB=DM,DM:IT,IT
DM=DB,DB:IT,IT
IT=DB,DB:DM,DM

[Database Functions DATABASE:HP NEOVIEW DATABASE]
cdinst:nullif(%1cdinst, %2cdinst)=NULLIF( %1, %2);
n:length(%1c)=\{fn CHAR_LENGTH(%1)\};
s:localtimestamp({%1n})=CAST(CURRENT_TIMESTAMP AS TIMESTAMP);

[Database Functions DATABASE:HP NEOVIEW DATABASE VERSION:1]
cdinst:nullif(%1cdinst, %2cdinst)=(case when %1=%2 then null else %1 end);

[Database Functions DATABASE:ACCESS]
cdinst:nullif(%1cdinst, %2cdinst)=IIF(%1=%2, null, %1);

[Exceptions General DATABASE:HP NEOVIEW DATABASE]
Count_Value_Expr=T
Group_By_Ordinal=T
Nulls_Sort_Last=T
Is_Null_Value_Expr=T
Distinct_Aggregates=T 
Correlated_Subqueries=T

[Exceptions Set Operators DATABASE:HP NEOVIEW DATABASE]
Distinct="distinct"
Union="union"
Union_All=T

[Exceptions Tables DATABASE:HP NEOVIEW DATABASE]
Derived=T

[Exceptions Value Expressions DATABASE:HP NEOVIEW DATABASE]
case=T
Case_Simple=T
Case_Searched=T
; Cast=T
Char_Length=T
Octet_Length=T
Extract=T
Lower=T
StrCat=T
Substring=T
Upper=T
Current_Date=T
Current_Time=T
Current_Timestamp=T
Abs=T
Exp=T
Mod=T
Power=T
Sqrt=T
Ceiling=T
Floor=T
Trim=T
Position=T
Coalesce=T
Nullif=C
 
[Operator Addition DATABASE:HP NEOVIEW DATABASE]
Date=
Time=
Timestamp=IV,TS
Interval=TS,TS:IV,IV:DT,TS

[Operator Subtraction DATABASE:HP NEOVIEW DATABASE]
Date=
Time=
Timestamp=TS,TS
Interval=IV,IV

[Operator Comparison DATABASE:HP NEOVIEW DATABASE]
Date=DT,OK
Timestamp=TS,OK
Time=TM,OK:TS,OK
Interval=IV,OK

;HP NEOVIEW NOTE
; Due to issue 584091 (incorrect version info supported) 
; We cannot programatically detect the minor version number of neoview DB.
; So the settings in this file apply to both version 2.1 and 2.3
; Version 2.2 is not supported.

[DRIVER:HP_ODBC0100.DLL]
;using DLL name as version info is unreliable (promised to be fixed in 2.3 )
; The following entry is required to workaround Trakker (3rd party) issue 556253
SQL_OJ_CAPABILITIES="27"

; Since version string of SQL_DBMS_VER does not follow ODBC standard
; ODBC gateway converts character letters in the version string to an equivalent numeric values 
; For examples, the version string "10.1A01" is read as 10.27.0001 where 10 is major version,
; 27 is minor version and 0001 is release version, likewise "10.1B03" is read as 10.28.0003,
; and "10.1C01 as 10.29.0001".  Please use the equivalent values in the ini file.
[DATABASE:OPENEDGE]
SQL_DBMS_VER_STR_FORMAT="m.nnr." 

[Misc DATABASE:IBM COGNOS REAL-TIME MONITORING]
; Default processing mode
Processing Mode=Limited Local

[DATABASE:MYSQL]
Disable_Subquery_With_Parameters=T
Keyword Alias=" as \"%s\" "
SQL_API_SQLDESCRIBEPARAM="FALSE"
SQL_QUALIFIER_TERM=""

;MySQL ODBC driver on Linux returns strlen 2 for SQL_DBMS_NAME.
;the database name is then read as 'MY'
; This is a temporary workaround
[DATABASE:MY]
SQL_DBMS_NAME="MYSQL"
 
[Exceptions Commands DATABASE:MYSQL]
Select="select"
Insert=
Update=
Delete=
Call=
Select_Star="T"
Max_Stmt_Len=""

[Exceptions Clauses DATABASE:MYSQL]
From="from"
Where="where"
Group_By="Group By"
Having="having"
Window=
With=
With_Recursive=

[Exceptions Tables DATABASE:MYSQL]
Derived=T
Joined=T
Simple_And_Joined=T
Tbl_Ref_Limit=""
SubSelect_Limit=""
Table_Constructor=F
UniqueName_Prefix="coguda"

[Exceptions Joins DATABASE:MYSQL]
Inner=T
Left_Outer=T
Right_Outer=T
Full_Outer=F
Cross=T
On_Condition_Or_Predicate=T
Nested_Outer=T
Inner_Tbl_Restrict=F
Optnl_Tbl_Restrict=F
Non_Equi_Joins=T
One_Outer=F
Natural=T
Left_Nested=T
Right_Nested=T
Two_Sided_Join_Restrict=F
Optnl_Tbl_Join_Restrict=F
Optnl_Tbl_Join_Filter=T
Optnl_Tbl_Filter=T
Prsrv_Tbl_Join_Filter=T
Prsrv_Tbl_Filter=T
On_Condition_Set_Functions=F
On_Condition_Subqueries=T
Full_Non_Equi_Join=F
On_Condition_In_Predicate=T
On_Condition_Not_Predicate=T
On_Condition_Like_Predicate=T
On_Condition_Between_Predicate=T
On_Condition_IsNull_Predicate=T
Non_Join_Expr=T
Non_Join_Non_Equi_Expr=T
Only_Eql_With_And=T
On_Condition_Functions=T
Two_Sided_Join_Restrict_Filter=T
Nested_Inner=T
Product_Join=T
Outer_Non_Equi_Join=T
On_Condition_No_Expr=T
Outer_Syntax=T
Left_Pre=
;Left_Eql=" LEFT OUTER JOIN "
Left_Post=
Right_Pre=
;Right_Eql=" RIGHT OUTER JOIN "
Right_Post=
;Full_Syntax=" FULL OUTER JOIN "
Full_Pre=
Full_Post=
;Inner_Syntax=" INNER JOIN "
Inner_Col_Pre=
Inner_Col_Post=
;Cross_Syntax=" CROSS JOIN "
;Union_Syntax=" UNION "
;Natural_Syntax=" NATURAL JOIN "

[Exceptions Predicates DATABASE:MYSQL]
Between="between"
In="in"
Like="like"
Is_Null="is null"
Any="any"
All="all"
Exists="exists"
NotLike="not like"

[Exceptions Aggregates DATABASE:MYSQL]
Max="max"
Min="min"
Sum="sum"
Avg="avg"
Count="count"
Count_Star="count(*)"
Stddev="stddev_samp"
Stddev_Pop="stddev_pop"
Stddev_Samp="stddev_samp"
Variance="var_samp"
Var_Pop="var_pop"
Var_Samp="var_samp"
Grouping=
Rank=
Dense_Rank=
Percent_Rank=
Cume_Dist=
Percentile_Cont=
Percentile_Disc=
First_Value=
Last_Value=
Percentile=F

[Exceptions OLAP Functions DATABASE:MYSQL]
Olap_Min=
Olap_Max=
Olap_Sum=
Olap_Avg=
Olap_Count=
Olap_Count_Star=
Olap_Stddev=
Olap_Stddev_Pop=
Olap_Stddev_Samp=
Olap_Variance=
Olap_Var_Pop=
Olap_Var_Samp=
Olap_Rank=
Olap_Dense_Rank=
Olap_Percent_Rank=
Olap_Cume_Dist=
Olap_Percentile_Cont=
Olap_Percentile_Disc=
Olap_First_Value=
Olap_Last_Value=
Olap_Row_Number=
Olap_Ratio_To_Report=
Olap_Ntile=
; Olap_Count_Default="ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING"
; Olap_Sum_Default="ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING"
; Olap_Last_Value_Default="ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING"

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

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

; Note MySQL will not parse func (x) unless MySQL client or server is configured to ignore
; spaces between the function reference and the open parenthesis
[Exceptions Value Expressions DATABASE:MYSQL]
Case_Simple=T
Case_Searched=T
Coalesce=T
Nullif=T
Grouping_Sets=F
Rollup=F
Cube=F
Position=T
Char_Length=F
Octet_Length=F
Substring=T
Upper=T
Lower=T
Strcat=C
Cast=C
Abs=T
Floor=T
Ceiling=C
ln=T
Exp=T
Mod=T
Sqrt=T
Power=T
Current_Date=T
;Unable to get timezone type via ODBC so disabled
Current_Time=F
Current_TimeStamp=F
LocalTime=T
LocalTimestamp=T
Extract=C
Extract_Year=coguda#extract_year
Extract_Month=coguda#extract_month
Extract_Day=coguda#extract_day
Extract_Hours=coguda#extract_hour
Extract_Minutes=coguda#extract_minute
Trim=T
Row_Value_Constructors=T
Olap_Window_Order_By=F
 
[Exceptions General DATABASE:MYSQL]
Aggregate_In_Expr=T
Aggregate_Value_Expr=T
Correlated_Subqueries=T
Cross_Product=T
Distinct_Aggregates=T
Distinct_Aggr_In_Case=T
Group_By_Expr=T
Group_By_Ordinal=T
Group_By_Alias=F
Multiple_Distinct=T
Count_Non_Distinct=T
Count_Value_Expr=T
Count_Literal=T
Is_Null_Value_Expr=T
Is_Null_Value_Parm=T
Like_Value_Expr=T
Subquery_In_Having=T
Subquery_In_Group_By=T
Subquery_In_Case=T
Count_Blob=T
Expression_In_In=T
Null_Order=F
Olap_Null_Order=F
Olap_Distinct=F
Nested_Olap_Functions=F
Empty_String_Is_Null=F
Order_By_In_Derived_Table=T
Interval_As_VarChar=F
Boolean_Comparison=T
Derived_Column_List=F
With_Column_List=F
Aggr_With_Interval=T
Nested_Case=T
Not_In_Subquery=T
Nulls_Sort_Last=F
Order_By_Alias=T
Order_By_Name=T
Substring_On_Expr=T
Subqueries=T
Subquery_Column_Alias=T
Parameter_In_Select_List=T
Remove_Parameter_Cast=F
Subquery_With_Parameters=T
Like_With_Parameters=T
Like_With_Escape=T
Comments=T
Integer_Division_Truncation=F
Parameter_Markers=F
 
[Exceptions Literals DATABASE:MYSQL]
Date_Literal=C
Date_Literal_Str="cast('%s-%s-%s' as date)"
Timestamp_Literal=C
Timestamp_Literal_Str="cast('%s-%s-%s %s:%s:%s'  as datetime)"
Time_Literal=C
Time_Literal_Str="cast('%s:%s:%s' as time)"
Interval_Literal=F
IntervalYM_Literal=F
TimeTZ_Literal=F
TimestampTZ_Literal=F
NChar_Literal=T
 
[Exceptions Misc DATABASE:MYSQL]

[Exceptions Delimiters DATABASE:MYSQL]
Comment_Begin="/* "
Comment_End=" */ "
 
[Exceptions Separators DATABASE:MYSQL]
Catalog_Separator="."
Schema_Separator="."
Table_Separator="."
 
[Exceptions Blob Expressions DATABASE:MYSQL]
Blob_In_Substring=T
Blob_In_Trim=T
Blob_In_StrCat=F
Blob_In_IsNull=T
Blob_In_Substring_Return_Blob=F
 
;b stands for boolean.
;c stands for character.
;x stands for text.
;d stands for date.
;i stands for the interval.
;n stands for the numeric.
;s stands for the timestamp.
;t stands for the time.
;y stands for time with time zone
;z stands for timestamp with time zone
 
[Database Functions DATABASE:MYSQL]
cx:concat(%1cx,%2cx)=concat(%1,%2);
n:ceiling(%1n)=CEIL(%1);

 
[Builtin Functions DATABASE:MYSQL]
d:_add_days(%1d,%2n)=(%1 + interval floor(%2) day);
d:_add_months(%1d,%2n)=(%1 + interval floor(%2) month);
d:_add_years(%1d,%2n)=(%1 + interval floor(%2) year);
d:_first_of_month(%1d)=( %1 - interval(dayofmonth(%1) -1) day);
d:_last_of_month(%1d)=(last_day(%1));
s:_add_days(%1s,%2n)=(%1 + interval floor(%2) day);
s:_add_months(%1s,%2n)=(%1 + interval floor(%2) month);
s:_add_years(%1s,%2n)=(%1 + interval floor(%2) year);
s:_first_of_month(%1s)=( %1 - interval(dayofmonth(%1) -1) day);
s:_last_of_month(%1s)=(last_day(%1));
;s:_make_timestamp(%1n,%2n,%3n)=;
;s:_add_hours(%1s,%2n)=;
;s:_add_minutes(%1s,%2n)=;
;s:_add_seconds(%1s,%2n)=;
;n:_days_between(%1ds,%2ds)=;
;n:_months_between(%1ds,%2ds)=;
n:_years_between(%1ds,%2ds)=((year(%1) - year(%2)));
;n:_hours_between(%1ds,%2ds)=;
;n:_minutes_between(%1ds,%2ds)=;
;n:_seconds_between(%1ds,%2ds)=;
n:_days_to_end_of_month(%1ds)=(cast(last_day(%1) as date) - cast(%1 as date));
n:_day_of_year(%1ds)=(dayofyear(%1));
n:_day_of_week(%1ds, %2n)=(mod(dayofweek(%1)+7-%2,7));
;n:_age(%1ds)=;
;n:_ymdint_between(%1ds,%2ds)=;
; must be iso 8601 compliant
;n:_week_of_year(%1ds)=;
;n:_round(%1n, %2n)=; 

n:coguda#extract_year(%1ds)=extract(year from %1);
n:coguda#extract_month(%1ds)=extract(month from %1);
n:coguda#extract_day(%1ds)=extract(day from %1);
n:coguda#extract_hour(%1st)=extract(hour from %1);
n:coguda#extract_minute(%1st)=extract(minute from %1);
;n:coguda#extract_second(%1st)=;

[Operator Addition DATABASE:MYSQL]
 
[Operator Subtraction DATABASE:MYSQL]
 
[Operator Multiplication DATABASE:MYSQL]
 
[Operator Division DATABASE:MYSQL]
 
[Operator Comparison DATABASE:MYSQL]

[Operator Cast DATABASE:MYSQL]
AD=AD,NA
BL=AD,NA
CH=CH,CH:DT,DT:NC,NC:TM,TM
DB=AD,NA
DT=CH,CH:DT,DT:NC,NC
FL=AD,NA
IT=CH,CH:NC,NC
IV=AD,NA
IY=AD,NA
NC=CH,CH:DT,DT:NC,NC
QD=CH,CH:NC,NC
SM=CH,CH:NC,NC
TM=TM,TM
TS=DT,DT:TM,TM
TT=AD,NA
TZ=AD,NA
VC=CH,CH:DT,DT:NC,NC:TM,TM

; Added Rational ODBC driver for COGCQ00264488
; Changed DRIVER to DATABASE for COGCQ00690796
[Exceptions Operators DATABASE:IBM RATIONAL] 
Add="+" 
And="and" 
Div="/" 
Eql="=" 
Eql= 
Geq=">=" 
Geq= 
Grt=">" 
Grt= 
Leq="<=" 
Leq= 
Les="<" 
Les= 
Mul="*" 
Neq="<>" 
Neq= 
Not="not" 
Or="or" 
Sub="-" 

[Exceptions Predicates DATABASE:IBM RATIONAL] 
Any= 
Exists= 
Between= 
In= 
Is_Null= 
Like= 
Match= 
NotLike= 
Unique= 

[Exceptions Clauses DATABASE:IBM RATIONAL] 
From="from" 
Group_By= 
Order_By= 
Having= 
Where= 

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

[Exceptions AggregateS DATABASE:IBM RATIONAL] 
Avg= 
Count= 
Count_star= 
Max= 
Min= 
Sum= 

[Exceptions Literals DATABASE:IBM RATIONAL] 
Boolean_Literal=F 
Date_Literal=F 
Timestamp_Literal=F 
Time_Literal=F 
Interval_Literal=F 
IntervalYM_Literal=F 
TimeTZ_Literal=F 
TimestampTZ_Literal=F 

[Exceptions Value Expressions DATABASE:SQLDS/VM] 
Current_Date=C 

[Database Functions DATABASE:SQLDS/VM] 
d:current_date()=\{fn CURDATE() \};  

[DRIVER:RATLXML.DLL]
;When connecting using Rational ODBC Driver read the subtype of <Database:IBM RATIONAL>
DBINFO_SUBSECTIONS="DBNAM"
SQL_DBMS_NAME="IBM RATIONAL"

[DRIVER:LIBRATLXML.SO]
;When connecting using Rational ODBC Driver read the subtype of <Database:IBM RATIONAL>
DBINFO_SUBSECTIONS="DBNAM"
SQL_DBMS_NAME="IBM RATIONAL"

[Source Data Type Name Mapping DATABASE:NETEZZASQL]
Interval=Interval_Day_To_Second

[DATABASE:IBM COGNOS NOW!] 
SQL_DBMS_NAME="IBM COGNOS REAL-TIME MONITORING"