RDBPROD: How to RMU/UNLOAD Oracle Rdb Floating Point Data for Oracle 10g External Table
Last updated on NOVEMBER 02, 2016
Applies to:Oracle Rdb Server on OpenVMS - Version 7.2 and later
HP OpenVMS Itanium
HP OpenVMS Alpha
HP OpenVMS VAX
There is an Oracle Rdb database running on OpenVMS. Using the Oracle 10g "external table" feature to allow querying of Oracle Rdb FLOAT and DOUBLE PRECISION columns is requested. RMU/UNLOAD will be used to produce a binary file to become the Oracle 10g external table.
How can the Oracle Rdb FLOAT and DOUBLE PRECISION columns (represented internally as VAX F_FLOAT and G_FLOAT) be converted to Oracle 10g BINARY_FLOAT and BINARY_DOUBLE (represented internally as IEEE S_FLOAT and T_FLOAT)?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms