HP 3000 Manuals HP 3000 Manuals
Appendix C Data Type Mapping
Data type conversions occur in Information Access after the data has been
sent to the PC. The following tables show ALLBASE/SQL to Information
Access data type mapping and ORACLE to Information Access data type
mapping.
ALLBASE/SQL to Information Access Data Type Mapping
---------------------------------------------------------------------------------------------
| | |
| ALLBASE/SQL Data Type | Information Access Data Type |
| | |
---------------------------------------------------------------------------------------------
| | |
| CHAR or CHARACTER | 1 - Text String |
| | |
| VARCHAR | 1 - Text String |
| | |
| DEC or DECIMAL or NUMERIC | 7 - Float8 |
| | |
| FLOAT or DOUBLE PRECISION | 7 - Float8 |
| | |
| INTEGER | 4 - Int4 |
| | |
| SMALLINT | 3 - Int3 |
| | |
| DATE | 11 - Date |
| | |
| DATETIME | 11 - Date |
| | |
| INTERVAL | * |
| | |
| Any other data type | * |
| | |
---------------------------------------------------------------------------------------------
* These data types are ignored and no data is displayed. However,
users running in batch mode get an error.
ORACLE to Information Access Data Type Mapping
-----------------------------------------------------------------------------------------------
| | | |
| ORACLE Code | Description | Information Access Data Type |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| 1 | Character String | 1 - Text String |
| | | |
| 2 | ORACLE Number | 7 - Float8 |
| | | |
| 3 | Integer | 7 - Float8 |
| | | |
| 4 | Float | 7 - Float8 |
| | | |
| 5 | Null Terminated String | 1 - Text String |
| | | |
| 6 | VarNum | * |
| | | |
| 7 | Packed Decimal | 7 - Float8 |
| | | |
| 8 | Long Character String | 1 - Text String |
| | | |
| 9 | Variable Char String | 1- Text String |
| | | |
| 10 | Unknown | * |
| | | |
| 11 | RowID | * |
| | | |
| 12 | Date | 11 - Date |
| | | |
| 14 | Julian Date | 7 - Float8 |
| | | |
| 15 | Variable Raw | * |
| | | |
| 23 | Raw | * |
| | | |
| 24 | Long Raw | * |
| | | |
-----------------------------------------------------------------------------------------------
* These data types are ignored and no data is displayed. However,
users running in batch mode get an error.