IC63189: IDS RETURNS A BAD PLACEHOLDER DESCRIPTION, INTERVAL INSTEAD OF DATETIME, IN CERTAIN CONDITIONS.

APAR status

• Closed as program error.

Error description

• You have  tables like:
  
     create table t1 ( c1 datetime year to fraction,c2 integer);
  
  and run the query:
  
      SELECT * from t1 WHERE c1 < ( ? - (c2 UNITS DAY) )
  
  If you are using a client API that asks for the placeholder
  description CIDESCRIBE (such as JDBC) the type returned will be
  INTERVAL with length=0 instead of DATETIME with a "length"
  compatible with the type of column c1.
  
  This under JDBC can lead to the following exception:
  
   java.lang.ClassNotFoundException: com.informix.jdbc.IfxInterval
  

Local fix

• Explicitly cast the placeholder to the correct type. For the
  example above it would mean:
  
  cast(? as DATETIME YEAR TO FRACTION)
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users with a client API that asks for the placeholder        *
  * description CIDESCRIBE                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Describe input does not give correct host variable           *
  * information for UNITs expression like c1 < ( ? - (c2 UNITS   *
  * DAY) )                                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS-11.50.xC6 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50.xC6
  

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:

  IT01440

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP