IBM Support

PI82437: ORACLE DATE COLUMN SAVED AS TIMESTAMP IN RIT DATABASE STUB

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When IBM Rational Integration Tester (RIT) is learning a
    database during stub creation, if the queries access tables
    containing data of type DATE. the stub uses data type of
    TIMESTAMP.
    
    The table that is created in the stub schema will contain one or
    more columns of type TIMESTAMP instead of type DATE.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Rational Integration Tester virtualizing Oracle     *
    * database content that uses the DATE datatype.                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * A database stub created from an Oracle table with a DATE     *
    * column might result in the equivalent Oracle simulation      *
    * database table using a TIMESTAMP for the column type.        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • In Rational Integration Tester 9.2 the virtual database schema
    when using an Oracle database correctly honors the DATE
    datatype.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI82437

  • Reported component name

    RATL INTEGRA TE

  • Reported component ID

    5725G79IT

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-01

  • Closed date

    2018-04-23

  • Last modified date

    2018-04-23

  • 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 INTEGRA TE

  • Fixed component ID

    5725G79IT

Applicable component levels

  • R800 PSN

       UP

  • R801 PSN

       UP

  • R850 PSN

       UP

  • R851 PSN

       UP

  • R860 PSN

       UP

  • R870 PSN

       UP

  • R871 PSN

       UP

  • R900 PSN

       UP

  • R901 PSN

       UP

  • R910 PSN

       UP

  • R911 PSN

       UP

  • R920 PSY

       UP



Document information

More support for: Rational Test Workbench

Software version: 910

Reference #: PI82437

Modified date: 23 April 2018