Support for BIGINT Data Type
The BIGINT data type, an 8-byte (128-bit) signed integer type that was added to Ingres 9.0.0, is now supported by Enterprise Access gateways for Microsoft SQL Server, Oracle, and IBM DB2 UDB.
In Enterprise Access 2.7 and earlier versions, NUMBER(38) mapped to INTEGER4. This now maps to BIGINT. The INTEGER setting for OPENSQL_ORACLE_NUMBER_MAPPING now maps the Oracle gateway to the following OpenSQL data types:
• NUMBER(0) to INTEGER4
• NUMBER(1-3) to INTEGER1
• NUMBER(4-5) to INTEGER2
• NUMBER(6-10) to INTEGER4
• NUMBER(11+) to BIGINT
For more information about data type mapping, see "Oracle NUMBER Mapping" and appendixes A and B in the Developing Portable Applications Guide.
The iigwscalars table in the catalog build utility was updated for each gateway:
For more information about the gateway catalog build utility, see the Administrator Guide.
The REGISTER PROCEDURE statement now supports and understands BIGINT types.
The Data Definition Language (DDL) for BIGINT was translated into the host data type.