PH35655: DATA CONV FAILED FOR COL B8_FIELD IN TABLE VIRTUAL_TABLE, REASON= INVALID CONV FROM STRING TO NUM, REASON= STRING IS NOT NUMERIC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using CAST to convert Binary into Integer, the following
  error occurs Data conversion failed for column B8_FIELD in table
  VIRTUAL_TABLE, reason = Invalid conversion from string to
  number, reason = String is not numeric
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL USERS                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: ADABAS Binary 2, 4, 8 to Int with       *
  *                      negative numbers not converting         *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  ADABAS Binary 2, 4, 8 to Int with Negative numbers not
  converting
  

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:

  UI75463

Modules/Macros

• HLVSQ29D HLVSQ29N HLVSQ2AD HLVSQ2AN HLVSQ2BD HLVSQ2BN HLVSQ2CD
  HLVSQ2CN HLVSQ2DD HLVSQ2DN HLVSQL9D HLVSQL9N HLVSQLAD HLVSQLAN
  HLVSQLBD HLVSQLBN HLVSQLCD HLVSQLCN HLVSQLDD HLVSQLDN
  

Fix information

• Fixed component name

  IDAA LOADER DAT

• Fixed component ID

  5639OLE01

Applicable component levels

• R210 PSY UI75463

     UP21/05/21 P F105

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.