JR31692: AFTER SUCCESSFUL COLUMN ANALYSIS CUSTOMER IS HAVING PROBLEMS WITH THE DATA TYPE

APAR status

• Closed as fixed if next.

Error description

• After successful column analysis, customer is having problems
  with the Data
  Class she "selects" during column analysis review being kept by
  the system.
  The values selected are systematically replaced by other types -
  see attached documentation. It appears that if you accept the
  systems recommendation of an indentifier type during the review,
  the type will default to a "Large Object". If you change a
  TEXT/Indicator/Indentifier column to CODE as your "selected"
  data type, the system will default the CODE to a TEXT.
  Everything looks fine during the initial review, with the system
  accepting the changes, accepting the "review" checkbox and
  saving the changes. Once you get out of the initial review
  process, the values are changed to the defaults as described
  above. Even if you go back in and change the values once more,
  or re-do the review, in the end the values are defaulted as
  described above. This has been tried on multiple columns in
  multiple tables in several databases.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  81 users trying to set values in CA
  ****************************************************************
  PROBLEM DESCRIPTION:
  After successful column analysis, customer is having problems
  with the Data
  Class she "selects" during column analysis review being kept
   by
  the system.
  The values selected are systematically replaced by other types
  -see attached documentation. It appears that if you accept the
  systems recommendation of an indentifier type during the
  review,the type will default to a "Large Object". If you
    change
   Indentifier column to CODE as your    "selected" data
  type, the system will default the CODE to
       TEXT.        Everything looks fine
  during the initial review,   with the systemaccepting the
  changes, accepting the "review"    checkbox and   saving the
  changes. Once you get out of the      initial review
  process, the values are changed to the       defaults as
  described  above. Even if you go back in and     change the
  values once more,  or re-do the review, in the end   the
  values are defaulted as described above. This has been
  tried on multiple columns in  multiple tables in several
  databases.
  ****************************************************************
  RECOMMENDATION:
  Affected customers should upgrade to 8.1 RP2. This change is
  also included in 8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

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

• CA
  

Fix information

Applicable component levels

• R801 PSN

     UP