JR46015: VIEW DATA ON TABLE HAVING BOOL TYPE IS FAILING IN NETEZZA CONNECTOR

IBM InfoSphere Information Server, Version 9.1.2

APAR status

• Closed as program error.

Error description

• In the Netezza Connector, while using view data option on a
  table having bool type (DS type is bit), the view data fails
  with the following error.
  Data type 11 is not supported by Netezza.
  

Local fix

• Use ODBC connector
  

Problem summary

• View Data on table having bool type is failing in Netezza
  Connector
  

Problem conclusion

• In the Netezza Connector, while using view data option on a
  table having bool type (DS type is bit), the view data fails
  with the following error.
  
  Data type 11 is not supported by Netezza.
  
  The code was incorrectly falling into the default case and hence
  the error.
  
  Corrected the code to address the view data issue with boolean
  type
  

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

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R850 PSY

     UP

• R870 PSY

     UP

• R910 PSY

     UP