PM56430: Reversed nullables with Retrieve SQL for sqlDataCode

Rational Business Developer 8.5
Rational Business Developer Fix Pack 4 (8.0.1.4) for 8.0.1

APAR status

• Closed as program error.

Error description

• Environment: windows
  Product name: IBM? Rational? Business Developer
  
  Program Version    :  8.0.1.2
  Description.
  RBD is presently implementing sqlDataCodes referring to
  SqlRecords as described below:
  SQL Column Type - sqlDataCodes - Nullable
  a) DATE                       384            YES
  
                                     385            NO
  b) TIME                        388            YES
  
                                     389            NO
  c) TIMESTAMP               392            YES
  
                                     393            NO
  
  This is erroneous behavior as described in the RBD infocenter
  where the initial values above ie 384,388, and 392 should be Not
  NULL:
  http://publib.boulder.ibm.com/infocenter/rbdhelp/v7r5m0/index.js
  p?topic=/com.ibm.egl.lr.doc/topics/regl_data_sql_sql_data_code.h
  tml
  
  
  When therefore using the EGL  capability the sqlDataCode is
  effectively being set to the opposite SQLTypes for Null vs
  non-Null and these values should be reversed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  RBD's Retrieve SQL feature was using the wrong sqlDataCode
  values for date, time, and timestamp columns.  There is a
  pair of values, one even number and one odd number, for each
  of those types.  The even numbers mean a column is declared
  NOT NULL, and odd numbers mean its values may be null.
  Retrieve SQL used odd numbers instead of even numbers, and
  vice versa.
  

Problem conclusion

• The problem has been fixed.
  

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

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels

• R801 PSN

     UP