You use the Table Loader with the following properties in SAS^® Data Integration Studio in order to append data to an existing DB2 table:

As shown, the Index Condition properties are meant to switch off the index before appending the data. However, when you run your code, you see an error similar to the following:

This message appears because the schema does not match a user’s default schema.

Use the following workarounds to avoid switching to user-written code:

• Use an alternate user ID that matches the schema name.
• Set the properties to retain the index while appending data, as shown here (this setting can have an impact on performance):

  

• Drop the table and re-create it before appending data (this setting requires that you have permission to create a table):

  

A hot fix is planned for that issue.

Operating System and Release Information