JR31084: INCORRECT DATA TYPE RETURNED FROM ERWIN BRIDGE FOR A GIVEN COLUMN.

APAR status

• Closed as program error.

Error description

• My discussion with MITI clarified that they internally have both
  the
  logical and physical datatypes for the view definition CHAR(2)
  and
  VARCHAR2(20).
  Based on the type of the Erwin model (Logical/Physical) the type
  was
  mapped by default as the logical type of VARCHAR2(20).
  As you and the customer stated, this is not the desired type,
  the
  physical type of CHAR(2) is actually the correct type from a
  physical
  perspective which is what the metadata repository wants to
  represent.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  MBB import from ERWin
  ****************************************************************
  PROBLEM DESCRIPTION:
  Error during import
  ****************************************************************
  RECOMMENDATION:
  Apply the appropriate patch
  This change is included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

• Fixed datatype for ERWIN bridge
  

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:

Modules/Macros

• MBB
  

Fix information

• Fixed component name

  METADATA WORKBE

• Fixed component ID

  5724S4100

Applicable component levels

• R800 PSN

     UP