PH62976: ITX JDBC TYPETREE IMPORTER DOES NOT WORK AS EXPECTED WITH ORACLE DATATYPE BINARY_FLOAT AND BINARY_DOUBLE

APAR status

• Closed as program error.

Error description

• When using the IBM Sterling Transformation Extender (ITX)
  type tree importer against an Oracle database via a JDBC
  connection, the datatypes BINARY_FLOAT and BINARY_DOUBLE are
  supposed to be number but are imported as text.
  
  Here is an example table creation script :
  
  create table ibm_test_case (
     f1 BINARY_FLOAT,
     f2 BINARY_DOUBLE
  );
  
  When running the following import command :
  
  java -cp
  '<DTXHOME>\*;<DTXHOME>\tools\*;<DTXHOME>\extjar\Oracle\*'
  -Duser.language=en -Duser.country=US
  '-Djava.library.path=<DTXHOME>'
  com.hcl.hip.tools.adapterdriver.TreeImporter
  com.hcl.hip.adapters.m4jdbc '<FOLDER_PATH>\typetree.mtt' -url
  <connection_url> -driver oracle.jdbc.driver.OracleDriver -user
  <user> -password <password> -schema <schema> -query 'select *
  from ibm_test_case'
  
  The created type tree has Text items defined, instead of the
  expected Number items.
  

Local fix

• ITXCQ - ITX00062624
  PB / GK
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender jdbc users reading data from Oracle
  DB, specifically including columns of two with data types
  BINARY_FLOAT and BINARY_DOUBLE
  
  Problem Description:
  JDBC - Oracle issue with BINARY_FLOAT and BINARY_DOUBLE
  
  Platforms Affected:
  All
  

Problem conclusion

• The Oracle data types of BINARY_FLOAT and BINARY_DOUBLE have
  been internally mapped to the appropriate data types (32-bit
  Float and 64-bit Float respectively), so they will appear as the
  appropriate data types and not as text data types, in the
  imported schema.
  
  Applies to:
  10.1.2.1
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next fix pack or product release is available,
  check the IBM Transformation Extender product Release Notes
  page:
  https://www.ibm.com/support/pages/node/318755
  
  If a fix pack release is available, download it from Fix
  Central:
  http://www.ibm.com/support/fixcentral/
  
  If a new product release is available, download it from Passport
  Advantage:
  https://www.ibm.com/software/passportadvantage/pao_customer.html
  
  
  If the fix pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a support Case:
  https://www.ibm.com/mysupport
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels