Upgrading from previous versions
To upgrade from previous versions of HCL Informix® OLE DB Provider, your database administrator must follow these steps:
- Run the script doledbp.sql against the sysmaster database as user informix. Ignore any messages about missing database objects.
- Run the script coledbp.sql against the sysmaster database as user informix.
Version 2.8 of HCL Informix OLE DB
Provider changes
the way some features used to operate in earlier versions. If you
have used a version before 2.8 of the HCL Informix OLE DB
Provider,
the issues you must be aware of are:
- OLE DB Provider handles the INTERVAL type differently in this
release. In versions before 2.8, interval data was returned as decimal
numbers with different sections of that number corresponding to year,
month, day, and other fields within the value. In order to interpret
the decimal number correctly. knowledge of the start and end fields
of the interval column was required .
In this release, the default type is a string with the format as described in the HCL Informix Guide to SQL: Reference, with the provision that a conversion to a numeric type is also allowed. If a datetime interval is requested in DB_TYPE_I8 format, the number returned will have 1/100,000 seconds as the unit of measure.
- OLE DB Provider handles complex data types, collections, and row
types differently in this release. Data of these types is presented
in string format as LVARCHAR data. This method is similar to the method
that is used to interact with this data by using the DB-Access tool.
As an example of the format being presented, if a column has the definition:
my_date MULTISET(date not null)Data contained in this column is returned to the application in the format:MULTISET{'08/15/2000','02/02/2002','10/11/1999'} - Type handling for the DECIMAL, MONEY, and DATETIME types has changed from the previous release.