JR64959: IBM RPA "BULK INSERT" DOES NOT WORK WITH POSTGRES

APAR status

• Closed as program error.

Error description

• When running a Bulk Insert command against a Postgres Database,
  you get the following error:
  "Input string was not in a correct format.Couldn't store in
  <column name> Column. Expected type is Int32."
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users who tries to use the SQL Bulk Insert command       *
  * targeting a PostreSQL database and dont have a correct      *
  * match with the source table and destination table schemas.   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Database operations against PostgreSQL database requires     *
  * data type conversion. The bulk insert command was expecting  *
  * a correspondence of number and order of columns between      *
  * source and destination. Minor changes to the schema of the   *
  * source table causes this logic to break on trying to set the *
  * data to the required type. The Fix changed the way the       *
  * conversion is handled by using the table columns names as    *
  * keys when matching the source and destination table.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Before the fix, the command can be used only if all the      *
  * columns from the destination table are present and in the    *
  * same order of the source datatable.                          *
  ****************************************************************
  

Problem conclusion

• A fix was delivered on 21.0.3
  

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:

Fix information

• Fixed component name

  RPA

• Fixed component ID

  5737N5100

Applicable component levels